Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
Can result in hang or crash
-
Q3/2026 Server Maintenance
Description
Version used:
-------------------------
Release build
branch: MDEV-37713
commit: 308bd4f2c455f82e4044707282444d1a85d0cbe8
How to repro:
SELECT ROW_NUMBER() OVER () OR TRUE; |
Stack trace:
#0 __pthread_kill_implementation (no_tid=0, signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=11, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=11) at ./nptl/pthread_kill.c:89
|
#3 handle_fatal_signal ()
|
#4 <signal handler called>
|
#5 Item_field::Item_field(THD*, Field*) ()
|
#6 Window_funcs_sort::setup(THD*, SQL_SELECT*, List_iterator<Item_window_func>&, st_join_table*) ()
|
#7 Window_funcs_computation::setup(THD*, List<Item_window_func>*, st_join_table*) ()
|
#8 JOIN::make_aggr_tables_info() ()
|
#9 JOIN::optimize_stage2() ()
|
#10 JOIN::optimize_inner() ()
|
#11 JOIN::optimize() ()
|
#12 mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) ()
|
#13 handle_select(THD*, LEX*, select_result*, unsigned long long) ()
|
#14 execute_sqlcom_select(THD*, TABLE_LIST*) ()
|
#15 mysql_execute_command(THD*, bool) ()
|
#16 mysql_parse(THD*, char*, unsigned int, Parser_state*) ()
|
#17 dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) ()
|
#18 do_command(THD*, bool) ()
|
#19 do_handle_one_connection(CONNECT*, bool) ()
|
#20 handle_one_connection ()
|
#21 pfs_spawn_thread ()
|
#22 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
|
#23 clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Attachments
Issue Links
- is caused by
-
MDEV-37713 Missed optimization opportunities of "TRUE OR any_expr" in SELECT clause
-
- In Testing
-