Skip to content

CASE max(1) OVER () WHEN 1 THEN 1 END segfaults

picodata> box.execute([[SELECT CASE max(1) OVER () WHEN 1 THEN 1 END]])
Segmentation fault
  code: SEGV_MAPERR
  addr: 0x268
  context: 0x1cceb300
  siginfo: 0x1cceb430
  rax      0x0                0
  rbx      0x0                0
  rcx      0x10               16
  rdx      0x1                1
  rsi      0x0                0
  rdi      0x61               97
  rsp      0x74b6098801a0     128325192778144
  rbp      0x74b609880238     128325192778296
  r8       0x10000            65536
  r9       0x1                1
  r10      0x0                0
  r11      0x1cd33350         483603280
  r12      0x74b609880238     128325192778296
  r13      0x74b609880236     128325192778294
  r14      0x74b609880990     128325192780176
  r15      0x8a00000000001    2427721674129409
  rip      0x1923bec          26360812
  eflags   0x10246            66118
  cs       0x33               51
  gs       0x0                0
  fs       0x0                0
  cr2      0x268              616
  err      0x4                4
  oldmask  0x0                0
  trapno   0xe                14
Current time: 1757340996
Please file a bug at support@picodata.io
Attempting backtrace... Note: since the server has already crashed,
this may fail as well
#1  0x177c89d in crash_signal_cb+157
#2  0x74b60a042520 in __sigaction+80
#3  0x1923bec in sql_column_collation+28
#4  0x192c89c in sql_expr_coll+492
#5  0x192d1ee in sql_binary_compare_coll_seq+62
#6  0x192d2a8 in codeCompare.isra.0+72
#7  0x1934c9a in sqlExprIfFalse+202
#8  0x1930c71 in sqlExprCodeTarget+545
#9  0x19354e0 in sqlExprCodeExprList+304
#10 0x19578c5 in selectInnerLoop+597
#11 0x195af80 in sqlSelect+2848
#12 0x1921241 in sqlParser+14209
#13 0x195fc32 in sqlRunParser+210
#14 0x194c95b in sql_stmt_compile+187
#15 0x1915723 in sql_prepare_and_execute+67
#16 0x199f624 in lbox_execute+1076
#17 0x1a00423 in lj_BC_FUNCC+70
#18 0x1a07345 in lua_pcall+117
#19 0x180670f in luaT_call+15
#20 0x17fd481 in lua_main+97
#21 0x17fd98a in run_script_f+1242
#22 0x18213c1 in fiber_cxx_invoke(int (*)(__va_list_tag*), __va_list_tag*)+17
#23 0x1783f87 in fiber_loop+55
#24 0x17de198 in coro_init+72