Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
mysqld: /src/10.2/sql/item_sum.cc:1339: void Item_sum_sum::add_helper(bool): Assertion `count > 0' failed.
|
160521 19:34:51 [ERROR] mysqld got signal 6 ;
|
#7 0x00007f994920c1d2 in __assert_fail () from /lib64/libc.so.6
|
#8 0x000055c4a846f1b0 in Item_sum_sum::add_helper (this=0x7f993f867538, perform_removal=true) at /src/10.2/sql/item_sum.cc:1339
|
#9 0x000055c4a846f7d8 in Item_sum_sum::remove (this=0x7f993f867538) at /src/10.2/sql/item_sum.cc:1426
|
#10 0x000055c4a847041a in Item_sum_avg::remove (this=0x7f993f867538) at /src/10.2/sql/item_sum.cc:1685
|
#11 0x000055c4a831c792 in Frame_range_n_top::walk_till_non_peer (this=0x7f993f86b8b8, item=0x7f993f867538) at /src/10.2/sql/sql_window.cc:915
|
#12 0x000055c4a831c676 in Frame_range_n_top::next_partition (this=0x7f993f86b8b8, rownum=0, item=0x7f993f867538) at /src/10.2/sql/sql_window.cc:884
|
#13 0x000055c4a831add6 in compute_window_func_with_frames (item_win=0x7f993f867cd8, tbl=0x7f993f96d088, info=0x7f994b4d9340) at /src/10.2/sql/sql_window.cc:1729
|
#14 0x000055c4a831b219 in Window_func_runner::exec (this=0x7f993f86adc0, tbl=0x7f993f96d088, filesort_result=0x7f993f701000) at /src/10.2/sql/sql_window.cc:1860
|
#15 0x000055c4a831b305 in Window_funcs_sort::exec (this=0x7f993f86ad98, join=0x7f993f868618) at /src/10.2/sql/sql_window.cc:1887
|
#16 0x000055c4a831b6b6 in Window_funcs_computation::exec (this=0x7f993f86ad78, join=0x7f993f868618) at /src/10.2/sql/sql_window.cc:1969
|
#17 0x000055c4a81ec57c in AGGR_OP::end_send (this=0x7f993f86aa40) at /src/10.2/sql/sql_select.cc:25992
|
#18 0x000055c4a81d8625 in sub_select_postjoin_aggr (join=0x7f993f868618, join_tab=0x7f993f869ca0, end_of_records=true) at /src/10.2/sql/sql_select.cc:17973
|
#19 0x000055c4a81d8913 in sub_select (join=0x7f993f868618, join_tab=0x7f993f8698f8, end_of_records=true) at /src/10.2/sql/sql_select.cc:18209
|
#20 0x000055c4a81d81a5 in do_select (join=0x7f993f868618, procedure=0x0) at /src/10.2/sql/sql_select.cc:17803
|
#21 0x000055c4a81b41e6 in JOIN::exec_inner (this=0x7f993f868618) at /src/10.2/sql/sql_select.cc:3342
|
#22 0x000055c4a81b3766 in JOIN::exec (this=0x7f993f868618) at /src/10.2/sql/sql_select.cc:3154
|
#23 0x000055c4a81b4866 in mysql_select (thd=0x7f993f82dc30, tables=0x7f993f867f20, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f993f8685f8, unit=0x7f993f831680, select_lex=0x7f993f831da8) at /src/10.2/sql/sql_select.cc:3538
|
#24 0x000055c4a81aa0b0 in handle_select (thd=0x7f993f82dc30, lex=0x7f993f8315b8, result=0x7f993f8685f8, setup_tables_done_option=0) at /src/10.2/sql/sql_select.cc:377
|
#25 0x000055c4a8179a47 in execute_sqlcom_select (thd=0x7f993f82dc30, all_tables=0x7f993f867f20) at /src/10.2/sql/sql_parse.cc:6318
|
#26 0x000055c4a816f74c in mysql_execute_command (thd=0x7f993f82dc30) at /src/10.2/sql/sql_parse.cc:3356
|
#27 0x000055c4a817d110 in mysql_parse (thd=0x7f993f82dc30, rawbuf=0x7f993f867188 "select o_custkey, Avg(o_custkey) OVER (PARTITION BY abs(o_custkey) ORDER BY o_custkey RANGE BETWEEN 15 FOLLOWING AND 15 FOLLOWING) from orders", length=142, parser_state=0x7f994b4da9e0, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:7730
|
#28 0x000055c4a816b561 in dispatch_command (command=COM_QUERY, thd=0x7f993f82dc30, packet=0x7f993f8611f1 "", packet_length=142, is_com_multi=false, is_next_command=false) at /src/10.2/sql/sql_parse.cc:1794
|
#29 0x000055c4a8169fa0 in do_command (thd=0x7f993f82dc30) at /src/10.2/sql/sql_parse.cc:1355
|
#30 0x000055c4a82a043a in do_handle_one_connection (connect=0x7f9948c84310) at /src/10.2/sql/sql_connect.cc:1358
|
#31 0x000055c4a82a01cc in handle_one_connection (arg=0x7f9948c84310) at /src/10.2/sql/sql_connect.cc:1264
|
#32 0x000055c4a89b55f6 in pfs_spawn_thread (arg=0x7f99441c6ff0) at /src/10.2/storage/perfschema/pfs.cc:1862
|
#33 0x00007f994b1550a4 in start_thread () from /lib64/libpthread.so.0
|
#34 0x00007f99492c304d in clone () from /lib64/libc.so.6
|
CREATE TABLE `orders` ( |
`o_orderkey` int(11) NOT NULL, |
`o_custkey` int(11) DEFAULT NULL, |
`o_orderstatus` char(1) DEFAULT NULL, |
`o_totalprice` double DEFAULT NULL, |
`o_orderDATE` date DEFAULT NULL, |
`o_orderpriority` char(15) DEFAULT NULL, |
`o_clerk` char(15) DEFAULT NULL, |
`o_shippriority` int(11) DEFAULT NULL, |
`o_comment` varchar(79) DEFAULT NULL, |
PRIMARY KEY (`o_orderkey`), |
KEY `i_o_orderdate` (`o_orderDATE`), |
KEY `i_o_custkey` (`o_custkey`) |
) DEFAULT CHARSET=latin1; |
|
INSERT INTO `orders` VALUES (59908,242,'F',33695.83,'1992-09-26','1-URGENT','Clerk#000000016',0,'furiously pending requests wake sly'); |
INSERT INTO `orders` VALUES (59940,238,'F',130910.25,'1994-09-25','5-LOW','Clerk#000000515',0,'ironic, ironic packages cajole slyly across the regular, bold d'); |
|
select o_custkey, Avg(o_custkey) OVER (PARTITION BY abs(o_custkey) ORDER BY o_custkey RANGE BETWEEN 15 FOLLOWING AND 15 FOLLOWING) from orders; |
Attachments
Issue Links
- relates to
-
MDEV-9896 Testing for window functions
- Open