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