[MDEV-25986] Assertion `0' failed in Item_sum_percent_rank::val_int Created: 2021-06-22  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Optimizer - Window functions
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None


 Description   

CREATE TABLE t1 (i int);
INSERT INTO t1 values (1),(2),(3);
SELECT  insert('aaa', percent_rank() over (order by 1) ,1, 'bbb') FROM t1 ;

10.2 cd1a195b22d2dac248228b6b

#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x00007fe630e1f859 in __GI_abort () at abort.c:79
#6  0x00007fe630e1f729 in __assert_fail_base (fmt=0x7fe630fb5588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x561a215e0c27 "0", file=0x561a215e0ea8 "/10.2/src/sql/item_windowfunc.h", line=478, function=<optimized out>) at assert.c:92
#7  0x00007fe630e30f36 in __GI___assert_fail (assertion=0x561a215e0c27 "0", file=0x561a215e0ea8 "/10.2/src/sql/item_windowfunc.h", line=478, function=0x561a215e0e70 "virtual longlong Item_sum_percent_rank::val_int()") at assert.c:101
#8  0x0000561a20e95037 in Item_sum_percent_rank::val_int (this=0x7fe5d40128a8) at /10.2/src/sql/item_windowfunc.h:478
#9  0x0000561a20e95543 in Item_window_func::val_int (this=0x7fe5d4012b58) at /10.2/src/sql/item_windowfunc.h:903
#10 0x0000561a20cd53a0 in Item_direct_ref::val_int (this=0x7fe5d4013d58) at /10.2/src/sql/item.cc:8131
#11 0x0000561a20d5b97b in Item_func_insert::val_str (this=0x7fe5d4012d70, str=0x7fe5d4012da0) at /10.2/src/sql/item_strfunc.cc:1446
#12 0x0000561a20ccfd2d in Item::save_in_field (this=0x7fe5d4012d70, field=0x7fe5d40369e8, no_conversions=true) at /10.2/src/sql/item.cc:6397
#13 0x0000561a209c1d56 in Item_result_field::save_in_result_field (this=0x7fe5d4012d70, no_conversions=true) at /10.2/src/sql/item.h:2564
#14 0x0000561a20bf9ef8 in save_window_function_values (window_functions=..., tbl=0x7fe5d4037028, rowid_buf=0x7fe5d40349b0 "\220\254\003\324\345\177") at /10.2/src/sql/sql_window.cc:2559
#15 0x0000561a20bfa339 in compute_window_func (thd=0x7fe5d4000d90, window_functions=..., cursor_managers=..., tbl=0x7fe5d4037028, filesort_result=0x7fe5d4193290) at /10.2/src/sql/sql_window.cc:2679
#16 0x0000561a20bfa716 in Window_func_runner::exec (this=0x7fe5d4015c20, thd=0x7fe5d4000d90, tbl=0x7fe5d4037028, filesort_result=0x7fe5d4193290) at /10.2/src/sql/sql_window.cc:2782
#17 0x0000561a20bfa83c in Window_funcs_sort::exec (this=0x7fe5d4015c18, join=0x7fe5d4013688, keep_filesort_result=true) at /10.2/src/sql/sql_window.cc:2810
#18 0x0000561a20bfad36 in Window_funcs_computation::exec (this=0x7fe5d4015bf8, join=0x7fe5d4013688, keep_last_filesort_result=true) at /10.2/src/sql/sql_window.cc:2937
#19 0x0000561a20aabafc in AGGR_OP::end_send (this=0x7fe5d4015ab8) at /10.2/src/sql/sql_select.cc:26857
#20 0x0000561a20a96541 in sub_select_postjoin_aggr (join=0x7fe5d4013688, join_tab=0x7fe5d4014d90, end_of_records=true) at /10.2/src/sql/sql_select.cc:18583
#21 0x0000561a20a96875 in sub_select (join=0x7fe5d4013688, join_tab=0x7fe5d40149e0, end_of_records=true) at /10.2/src/sql/sql_select.cc:18819
#22 0x0000561a20a96059 in do_select (join=0x7fe5d4013688, procedure=0x0) at /10.2/src/sql/sql_select.cc:18414
#23 0x0000561a20a6fc1d in JOIN::exec_inner (this=0x7fe5d4013688) at /10.2/src/sql/sql_select.cc:3651
#24 0x0000561a20a6f0c4 in JOIN::exec (this=0x7fe5d4013688) at /10.2/src/sql/sql_select.cc:3446
#25 0x0000561a20a7029e in mysql_select (thd=0x7fe5d4000d90, tables=0x7fe5d4012f68, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fe5d4013668, unit=0x7fe5d4004988, select_lex=0x7fe5d40050d8) at /10.2/src/sql/sql_select.cc:3849
#26 0x0000561a20a643f2 in handle_select (thd=0x7fe5d4000d90, lex=0x7fe5d40048c8, result=0x7fe5d4013668, setup_tables_done_option=0) at /10.2/src/sql/sql_select.cc:361
#27 0x0000561a20a2eae6 in execute_sqlcom_select (thd=0x7fe5d4000d90, all_tables=0x7fe5d4012f68) at /10.2/src/sql/sql_parse.cc:6271
#28 0x0000561a20a2565a in mysql_execute_command (thd=0x7fe5d4000d90) at /10.2/src/sql/sql_parse.cc:3582
#29 0x0000561a20a328a2 in mysql_parse (thd=0x7fe5d4000d90, rawbuf=0x7fe5d4012708 "SELECT  insert('aaa', percent_rank() over (order by 1) ,1, 'bbb') FROM t1", length=73, parser_state=0x7fe627106560, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:7793
#30 0x0000561a20a20afd in dispatch_command (command=COM_QUERY, thd=0x7fe5d4000d90, packet=0x7fe5d4008b61 "", packet_length=74, is_com_multi=false, is_next_command=false) at /10.2/src/sql/sql_parse.cc:1827
#31 0x0000561a20a1f5f8 in do_command (thd=0x7fe5d4000d90) at /10.2/src/sql/sql_parse.cc:1381
#32 0x0000561a20b7aa7b in do_handle_one_connection (connect=0x561a22f109c0) at /10.2/src/sql/sql_connect.cc:1336
#33 0x0000561a20b7a7e0 in handle_one_connection (arg=0x561a22f109c0) at /10.2/src/sql/sql_connect.cc:1241
#34 0x0000561a213a6c82 in pfs_spawn_thread (arg=0x561a22ef3db0) at /10.2/src/storage/perfschema/pfs.cc:1869
#35 0x00007fe631340609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#36 0x00007fe630f1c293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

No visible effect on a non-debug builds


Generated at Thu Feb 08 09:41:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.