Details
Description
Note: the difference between this bug and MDEV-10467 is that this one is reproducible on all of 5.5, 10.0, 10.1, 10.2.
select STDDEV_POP(f) FROM (SELECT "1e+309" AS f UNION SELECT "-1e+309" AS f) tbl; |
Stack trace from 5.5 commit 5fdb3cfcd432b85dc305a1a61c2d018a798a6ac3 |
mysqld: /data/src/5.5/sql/item_sum.cc:1765: virtual double Item_sum_std::val_real(): Assertion `nr >= 0.0' failed.
|
160801 0:54:35 [ERROR] mysqld got signal 6 ;
|
 |
#6 0x00007f8a90eea266 in __assert_fail_base (fmt=0x7f8a91023238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xdbee62 "nr >= 0.0", file=file@entry=0xdbecbb "/data/src/5.5/sql/item_sum.cc", line=line@entry=1765, function=function@entry=0xdbf800 <Item_sum_std::val_real()::__PRETTY_FUNCTION__> "virtual double Item_sum_std::val_real()") at assert.c:92
|
#7 0x00007f8a90eea312 in __GI___assert_fail (assertion=0xdbee62 "nr >= 0.0", file=0xdbecbb "/data/src/5.5/sql/item_sum.cc", line=1765, function=0xdbf800 <Item_sum_std::val_real()::__PRETTY_FUNCTION__> "virtual double Item_sum_std::val_real()") at assert.c:101
|
#8 0x00000000008596b4 in Item_sum_std::val_real (this=0x7f8a8b9482a0) at /data/src/5.5/sql/item_sum.cc:1765
|
#9 0x00000000007cfafa in Item::send (this=0x7f8a8b9482a0, protocol=0x7f8a8ca74628, buffer=0x7f8a92f411b0) at /data/src/5.5/sql/item.cc:6595
|
#10 0x0000000000568e30 in Protocol::send_result_set_row (this=0x7f8a8ca74628, row_items=0x7f8a8b97be50) at /data/src/5.5/sql/protocol.cc:903
|
#11 0x00000000005cb47a in select_send::send_data (this=0x7f8a8b97ba60, items=...) at /data/src/5.5/sql/sql_class.cc:2374
|
#12 0x000000000065e459 in end_send_group (join=0x7f8a8b97ba80, join_tab=0x7f8a8b97dcf8, end_of_records=true) at /data/src/5.5/sql/sql_select.cc:18186
|
#13 0x000000000065b251 in sub_select (join=0x7f8a8b97ba80, join_tab=0x7f8a8b97d9d8, end_of_records=true) at /data/src/5.5/sql/sql_select.cc:16904
|
#14 0x000000000065ad3a in do_select (join=0x7f8a8b97ba80, fields=0x7f8a8b97be50, table=0x0, procedure=0x0) at /data/src/5.5/sql/sql_select.cc:16615
|
#15 0x000000000063955f in JOIN::exec (this=0x7f8a8b97ba80) at /data/src/5.5/sql/sql_select.cc:2873
|
#16 0x0000000000639d2a in mysql_select (thd=0x7f8a8ca74060, rref_pointer_array=0x7f8a8ca77ce0, tables=0x7f8a8b97b3e8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8a8b97ba60, unit=0x7f8a8ca77390, select_lex=0x7f8a8ca77a70) at /data/src/5.5/sql/sql_select.cc:3094
|
#17 0x0000000000630610 in handle_select (thd=0x7f8a8ca74060, lex=0x7f8a8ca772e0, result=0x7f8a8b97ba60, setup_tables_done_option=0) at /data/src/5.5/sql/sql_select.cc:319
|
#18 0x0000000000609b07 in execute_sqlcom_select (thd=0x7f8a8ca74060, all_tables=0x7f8a8b97b3e8) at /data/src/5.5/sql/sql_parse.cc:4689
|
#19 0x0000000000602e58 in mysql_execute_command (thd=0x7f8a8ca74060) at /data/src/5.5/sql/sql_parse.cc:2234
|
#20 0x000000000060c6d2 in mysql_parse (thd=0x7f8a8ca74060, rawbuf=0x7f8a8b948078 "select STDDEV_POP(f) FROM (SELECT \"1e+309\" AS f UNION SELECT \"-1e+309\" AS f) tbl", length=80, parser_state=0x7f8a92f42650) at /data/src/5.5/sql/sql_parse.cc:5934
|
#21 0x00000000006003e7 in dispatch_command (command=COM_QUERY, thd=0x7f8a8ca74060, packet=0x7f8a8d74e061 "", packet_length=80) at /data/src/5.5/sql/sql_parse.cc:1079
|
#22 0x00000000005ff5a1 in do_command (thd=0x7f8a8ca74060) at /data/src/5.5/sql/sql_parse.cc:793
|
#23 0x000000000070171f in do_handle_one_connection (thd_arg=0x7f8a8ca74060) at /data/src/5.5/sql/sql_connect.cc:1270
|
#24 0x00000000007014ac in handle_one_connection (arg=0x7f8a8ca74060) at /data/src/5.5/sql/sql_connect.cc:1186
|
#25 0x00000000009437a5 in pfs_spawn_thread (arg=0x7f8a8d77a300) at /data/src/5.5/storage/perfschema/pfs.cc:1015
|
#26 0x00007f8a92b7e0a4 in start_thread (arg=0x7f8a92f43700) at pthread_create.c:309
|
#27 0x00007f8a90fa487d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Attachments
Issue Links
- relates to
-
MDEV-5781 Item_sum_std::val_real(): Assertion `nr >= 0.0' fails on query with STDDEV_POP, ROUND and variable
- Closed
-
MDEV-10467 [5.5] Assertion `nr >= 0.0' failed in Item_sum_std::val_real()
- Closed