Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.3.0, 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
-
Ubuntu 20.04
Description
Run these queries in debug build:
CREATE TABLE t0 ( c57 DOUBLE ( 170 , 28 ) ) ;
INSERT INTO t0 ( c57 ) SELECT -121 AS c38 WHERE -32 NOT REGEXP RAND ( ) IS NOT NULL = -78 ;
CREATE INDEX i0 ON t0 ( c57 ) ;
INSERT INTO t0 VALUES ( -101 ) , ( -73 ) ;
SELECT t0 . c57 AS c59 FROM ( SELECT LAST_VALUE ( 99 ) OVER ( PARTITION BY c57 , c57 , BIT_AND( EXP ( 6319111429908606278 ) IS TRUE ) OVER ( ) IN ( ( SELECT t1 . c54 AS c31 FROM ( SELECT ~ SIN ( 74 ) LIKE LENGTH ( 128 ) AS c54 FROM t0 ) AS t1 LIMIT 1 ) % RTRIM ( CONVERT ( -2 , UNSIGNED ) SOUNDS LIKE INSERT ( t0 . c57 , 'JQlgi7hi [*&(-Po Llzic]"m/s9H=y7G.&C-mxkT)K~(@XD?ItNemjIJoab' , 'Q' , '
SvJ#n /ec% ;VGOTpBjju]3p;6sf-f^|z%' ) ) ) , t0 . c57 , c57 , t0 . c57 , t0 . c57 , c57 ) % HEX ( -45 ) IN ( 2 , 13 = ( CONVERT ( 20 , UNSIGNED ) ) ) OR - SUM( 84 ) OVER ( PARTITION BY -80 , -41 , -108 ) AS c20 FROM t0 GROUP BY c57 ) AS t2 JOIN t0 ON t0 . c57 = t2 . c20 WHERE RAND ( t2 . c20 ) ;
Will trigger Assertion Failed.
GDB info:
#0 0x00007ffff6c0c00b in raise () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x00007ffff6beb859 in abort () from /lib/x86_64-linux-gnu/libc.so.6
#2 0x00007ffff6beb729 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#3 0x00007ffff6bfcfd6 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#4 0x0000555557c7fd58 in Item_func_exp::val_real (this=0x6290000f69e0) at /home/wx/mariadb-11.3.0/sql/item_func.cc:2075
#5 0x00005555578b4ae2 in Type_handler_real_result::Item_val_bool (this=0x55555b7b6c00 <type_handler_double>, item=0x6290000f69e0) at /home/wx/mariadb-11.3.0/sql/sql_type.cc:5077
#6 0x0000555556e147f6 in Item::val_bool (this=0x6290000f69e0) at /home/wx/mariadb-11.3.0/sql/item.h:1701
#7 0x0000555557bef4c8 in Item_func_truth::val_bool (this=0x6290000f6a98) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1179
#8 0x0000555557bef6e8 in Item_func_truth::val_int (this=0x6290000f6a98) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1202
#9 0x0000555557e034e6 in Item_sum_and::add (this=0x6290000f6b60) at /home/wx/mariadb-11.3.0/sql/item_sum.cc:2747
#10 0x00005555579135a9 in Frame_cursor::add_value_to_items (this=0x62d00003f7a0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1166
#11 0x0000555557915cdd in Frame_range_current_row_bottom::pre_next_partition (this=0x62d00003f7a0, rownum=0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1576
#12 0x0000555557913cfb in Cursor_manager::notify_cursors_partition_changed (this=0x60300023e3c0, rownum=0) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:1225
#13 0x000055555790ed44 in compute_window_func (thd=0x62c0001e0288, window_functions=..., cursor_managers=..., tbl=0x62100016bda8, filesort_result=0x6150001c4b00) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:2907
#14 0x000055555790f54d in Window_func_runner::exec (this=0x6290001c3710, thd=0x62c0001e0288, tbl=0x62100016bda8, filesort_result=0x6150001c4b00) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3039
#15 0x000055555790f79c in Window_funcs_sort::exec (this=0x6290001c3708, join=0x6290001bd4b0, keep_filesort_result=true) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3067
#16 0x00005555579105c8 in Window_funcs_computation::exec (this=0x6290001c36e0, join=0x6290001bd4b0, keep_last_filesort_result=true) at /home/wx/mariadb-11.3.0/sql/sql_window.cc:3196
#17 0x00005555573a1ea2 in AGGR_OP::end_send (this=0x6290001c1088) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32300
#18 0x000055555735ebd8 in sub_select_postjoin_aggr (join=0x6290001bd4b0, join_tab=0x6290001c2720, end_of_records=true) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23128
#19 0x000055555735f713 in sub_select (join=0x6290001bd4b0, join_tab=0x6290001c22a8, end_of_records=true) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23378
#20 0x000055555735dbe3 in do_select (join=0x6290001bd4b0, procedure=0x0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22963
#21 0x00005555572dbfe9 in JOIN::exec_inner (this=0x6290001bd4b0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#22 0x00005555572d93a0 in JOIN::exec (this=0x6290001bd4b0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#23 0x00005555572ddbab in mysql_select (thd=0x62c0001e0288, tables=0x6290001862a8, fields=..., conds=0x0, og_num=3, order=0x0, group=0x6290000f66a0, having=0x0, proc_param=0x0, select_options=2201188305408, result=0x6290001bd3b8, unit=0x629000186b00, select_lex=0x6290000f5ed8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
#24 0x00005555570d9bea in mysql_derived_fill (thd=0x62c0001e0288, lex=0x62c0001e45f8, derived=0x629000187398) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1266
#25 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001e45f8, derived=0x629000187398, phases=96) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#26 0x000055555732a50c in st_join_table::preread_init (this=0x62d00003d008) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#27 0x000055555735f8c8 in sub_select (join=0x629000189b70, join_tab=0x62d00003d008, end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#28 0x000055555736194d in evaluate_join_record (join=0x629000189b70, join_tab=0x62d00003cb90, error=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
#29 0x00005555573601c2 in sub_select (join=0x629000189b70, join_tab=0x62d00003cb90, end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
#30 0x000055555735dadd in do_select (join=0x629000189b70, procedure=0x0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#31 0x00005555572dbfe9 in JOIN::exec_inner (this=0x629000189b70) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#32 0x00005555572d93a0 in JOIN::exec (this=0x629000189b70) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#33 0x00005555572ddbab in mysql_select (thd=0x62c0001e0288, tables=0x629000187398, fields=..., conds=0x629000189120, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2165049856, result=0x629000189b40, unit=0x62c0001e46d8, select_lex=0x6290000f5878) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
#34 0x00005555572ad18a in handle_select (thd=0x62c0001e0288, lex=0x62c0001e45f8, result=0x629000189b40, setup_tables_done_option=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:628
#35 0x00005555571ce583 in execute_sqlcom_select (thd=0x62c0001e0288, all_tables=0x629000187398) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:6013
#36 0x00005555571becf6 in mysql_execute_command (thd=0x62c0001e0288, is_called_from_prepared_stmt=false) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:3912
#37 0x00005555571d95e2 in mysql_parse (thd=0x62c0001e0288, rawbuf=0x6290000f52a8 "SELECT t0 . c57 AS c59 FROM ( SELECT LAST_VALUE ( 99 ) OVER ( PARTITION BY c57 , c57 , BIT_AND( EXP ( 6319111429908606278 ) IS TRUE ) OVER ( ) IN ( ( SELECT t1 . c54 AS c31 FROM ( SELECT ~ SIN ( 74 ) "..., length=688, parser_state=0x7fffe33b0870) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
#38 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001e0288, packet=0x6290000fa289 "", packet_length=691, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
#39 0x00005555571adf7c in do_command (thd=0x62c0001e0288, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
#40 0x000055555768e557 in do_handle_one_connection (connect=0x611000090088, put_in_cache=true) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
#41 0x000055555768deb4 in handle_one_connection (arg=0x611000079ec8) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
#42 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000005108) at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
#43 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#44 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6
Attachments
Activity
|
|
CREATE TABLE t0 ( c57 DOUBLE ( 170 , 28 ) ) ; |
INSERT INTO t0 ( c57 ) SELECT -121 AS c38 WHERE -32 NOT REGEXP RAND ( ) IS NOT NULL = -78 ; |
CREATE INDEX i0 ON t0 ( c57 ) ; |
INSERT INTO t0 VALUES ( -101 ) , ( -73 ) ; |
|
|
SELECT t0 . c57 FROM ( |
SELECT LAST_VALUE ( 99 ) OVER ( PARTITION BY c57 , BIT_AND( 6319111429908606278 ) OVER ( )) FROM t0 GROUP BY c57 ) |
AS t2 JOIN t0 ; |
Could you please confirm whether the simplification process we applied has been helpful for developers in diagnosing and addressing this issue?
Thanks!
I repeated as described on 10.4-11.3
Version: '10.4.32-MariaDB-debug-log'mysqld: /home/alice/am/m4-10.4/src/sql/item_func.cc:2010: virtual double Item_func_exp::val_real(): Assertion `fixed == 1' failed.231107 18:08:15 [ERROR] mysqld got signal 6 ;Server version: 10.4.32-MariaDB-debug-log source revision: e5a5573f782723e40c372f38346a60b1ccc644d6/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f3745130fd6]sql/item_func.cc:2011(Item_func_exp::val_real())[0x55e18a6ae498]sql/sql_type.cc:4633(Type_handler_real_result::Item_val_bool(Item*) const)[0x55e18a2ff348]sql/item.h:1474(Item::val_bool())[0x55e189abbd52]sql/item_cmpfunc.cc:1185(Item_func_truth::val_bool())[0x55e18a611c5f]sql/item_cmpfunc.cc:1208(Item_func_truth::val_int())[0x55e18a611e84]sql/item_sum.cc:2713(Item_sum_and::add())[0x55e18a7cd415]sql/sql_window.cc:1164(Frame_cursor::add_value_to_items())[0x55e18a3466b3]sql/sql_window.cc:1577(Frame_range_current_row_bottom::pre_next_partition(unsigned long long))[0x55e18a348de7]sql/sql_window.cc:1224(Cursor_manager::notify_cursors_partition_changed(unsigned long long))[0x55e18a346e05]sql/sql_window.cc:2907(compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*))[0x55e18a341db4]sql/sql_window.cc:3030(Window_func_runner::exec(THD*, TABLE*, SORT_INFO*))[0x55e18a342570]sql/sql_window.cc:3058(Window_funcs_sort::exec(JOIN*, bool))[0x55e18a3427be]sql/sql_window.cc:3185(Window_funcs_computation::exec(JOIN*, bool))[0x55e18a3435c6]sql/sql_select.cc:29697(AGGR_OP::end_send())[0x55e189f0a83a]sql/sql_select.cc:20621(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55e189ec6e5f]sql/sql_select.cc:20867(sub_select(JOIN*, st_join_table*, bool))[0x55e189ec795a]sql/sql_select.cc:20445(do_select(JOIN*, Procedure*))[0x55e189ec605a]sql/sql_select.cc:4625(JOIN::exec_inner())[0x55e189e53a9c]sql/sql_select.cc:4408(JOIN::exec())[0x55e189e510cc]sql/sql_select.cc:4848(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55e189e552a8]sql/sql_derived.cc:1265(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55e189ca90a5]sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55e189ca1b1a]sql/sql_select.cc:13885(st_join_table::preread_init())[0x55e189e96c87]sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55e189ec7b23]sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55e189ec5f54]sql/sql_select.cc:4625(JOIN::exec_inner())[0x55e189e53a9c]sql/sql_select.cc:4408(JOIN::exec())[0x55e189e510cc]sql/sql_select.cc:4848(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55e189e552a8]sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55e189e25b1e]sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55e189d91886]sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x55e189d7effd]sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55e189d9adc5]sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55e189d71187]sql/sql_parse.cc:1378(do_command(THD*))[0x55e189d6dcb2]sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55e18a17d5b5]sql/sql_connect.cc:1325(handle_one_connection)[0x55e18a17ce59]perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55e18ae1947e]nptl/pthread_create.c:478(start_thread)[0x7f374564b609]Query (0x62b0000a1290): SELECT t0 . c57 AS c59 FROM ( SELECT LAST_VALUE ( 99 ) OVER ( PARTITION BY c57 , c57 , BIT_AND( EXP ( 6319111429908606278 ) IS TRUE ) OVER ( ) IN ( ( SELECT t1 . c54 AS c31 FROM ( SELECT ~ SIN ( 74 ) LIKE LENGTH ( 128 ) AS c54 FROM t0 ) AS t1 LIMIT 1 ) % RTRIM ( CONVERT ( -2 , UNSIGNED ) SOUNDS LIKE INSERT ( t0 . c57 , 'JQlgi7hi [*&(-Po Llzic]"m/s9H=y7G.&C-mxkT)K~(@XD?ItNemjIJoab' , 'Q' , 'SvJ#n /ec% ;VGOTpBjju]3p;6sf-f^|z%' ) ) ) , t0 . c57 , c57 , t0 . c57 , t0 . c57 , c57 ) % HEX ( -45 ) IN ( 2 , 13 = ( CONVERT ( 20 , UNSIGNED ) ) ) OR - SUM( 84 ) OVER ( PARTITION BY -80 , -41 , -108 ) AS c20 FROM t0 GROUP BY c57 ) AS t2 JOIN t0 ON t0 . c57 = t2 . c20 WHERE RAND ( t2 . c20 )