Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.4(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a time not null) engine=innodb; |
SELECT STD(0) FROM t1 ORDER BY ROUND(a); |
|
DROP TABLE t1; |
10.4 5a42a114fdc9cacb6e64 |
#6 0x00007fabaf624bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55d698342fe0 "maybe_null || !null_value", file=file@entry=0x55d698342c40 "/10.4/sql/item_func.cc", line=line@entry=2552, function=function@entry=0x55d698344a40 <Item_func_round::time_op(THD*, st_mysql_time*)::__PRETTY_FUNCTION__> "virtual bool Item_func_round::time_op(THD*, MYSQL_TIME*)") at assert.c:92
|
#7 0x00007fabaf624c82 in __GI___assert_fail (assertion=0x55d698342fe0 "maybe_null || !null_value", file=0x55d698342c40 "/10.4/sql/item_func.cc", line=2552, function=0x55d698344a40 <Item_func_round::time_op(THD*, st_mysql_time*)::__PRETTY_FUNCTION__> "virtual bool Item_func_round::time_op(THD*, MYSQL_TIME*)") at assert.c:101
|
#8 0x000055d69781513a in Item_func_round::time_op (this=0x7fab54102c40, thd=0x7fab54000a88, to=0x7faba837e9c0) at /10.4/sql/item_func.cc:2552
|
#9 0x000055d697825d8f in Item_func_hybrid_field_type::time_op_with_null_check (this=0x7fab54102c40, thd=0x7fab54000a88, ltime=0x7faba837e9c0) at /10.4/sql/item_func.h:681
|
#10 0x000055d69780e089 in Item_func_hybrid_field_type::val_str_from_time_op (this=0x7fab54102c40, str=0x7fab5404df20) at /10.4/sql/item_func.cc:903
|
#11 0x000055d69763a4cb in Type_handler_time_common::Item_func_hybrid_field_type_val_str (this=0x55d698c60c30 <type_handler_time2>, item=0x7fab54102c40, str=0x7fab5404df20) at /10.4/sql/sql_type.cc:4879
|
#12 0x000055d6973f0fee in Item_func_hybrid_field_type::val_str (this=0x7fab54102c40, str=0x7fab5404df20) at /10.4/sql/item_func.h:769
|
#13 0x000055d6977ab550 in Item_copy_string::copy (this=0x7fab5404def0) at /10.4/sql/item.cc:4837
|
#14 0x000055d69749ade5 in copy_fields (param=0x7fab5404c090) at /10.4/sql/sql_select.cc:25006
|
#15 0x000055d69749d7b4 in JOIN::clear (this=0x7fab5404be70) at /10.4/sql/sql_select.cc:25970
|
#16 0x000055d6974923b8 in end_send_group (join=0x7fab5404be70, join_tab=0x7fab5404d718, end_of_records=true) at /10.4/sql/sql_select.cc:21664
|
#17 0x000055d69748e9d4 in sub_select (join=0x7fab5404be70, join_tab=0x7fab5404d370, end_of_records=true) at /10.4/sql/sql_select.cc:20287
|
#18 0x000055d69748e0f6 in do_select (join=0x7fab5404be70, procedure=0x0) at /10.4/sql/sql_select.cc:19878
|
#19 0x000055d697462c38 in JOIN::exec_inner (this=0x7fab5404be70) at /10.4/sql/sql_select.cc:4452
|
#20 0x000055d697461d72 in JOIN::exec (this=0x7fab5404be70) at /10.4/sql/sql_select.cc:4234
|
#21 0x000055d697463489 in mysql_select (thd=0x7fab54000a88, tables=0x7fab540f6510, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fab540fdd70, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fab540f10a0, unit=0x7fab540049c8, select_lex=0x7fab540382e0) at /10.4/sql/sql_select.cc:4666
|
#22 0x000055d697452dee in handle_select (thd=0x7fab54000a88, lex=0x7fab54004908, result=0x7fab540f10a0, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:420
|
#23 0x000055d697418771 in execute_sqlcom_select (thd=0x7fab54000a88, all_tables=0x7fab540f6510) at /10.4/sql/sql_parse.cc:6359
|
#24 0x000055d69740dd7e in mysql_execute_command (thd=0x7fab54000a88) at /10.4/sql/sql_parse.cc:3898
|
#25 0x000055d69741c8b3 in mysql_parse (thd=0x7fab54000a88, rawbuf=0x7fab5417c010 "SELECT STD(0) FROM t1 ORDER BY ROUND(a)", length=39, parser_state=0x7faba837ffd0, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7900
|
#26 0x000055d69740794e in dispatch_command (command=COM_QUERY, thd=0x7fab54000a88, packet=0x7fab54007bc9 "", packet_length=39, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1842
|
#27 0x000055d697405faf in do_command (thd=0x7fab54000a88) at /10.4/sql/sql_parse.cc:1360
|
#28 0x000055d6975964e3 in do_handle_one_connection (connect=0x55d69a677978) at /10.4/sql/sql_connect.cc:1412
|
#29 0x000055d69759620c in handle_one_connection (arg=0x55d69a677978) at /10.4/sql/sql_connect.cc:1316
|
#30 0x000055d697ff3955 in pfs_spawn_thread (arg=0x55d69a60bbe8) at /10.4/storage/perfschema/pfs.cc:1869
|
#31 0x00007fabb0b1b6ba in start_thread (arg=0x7faba8381700) at pthread_create.c:333
|
#32 0x00007fabaf6fe41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
Attachments
Issue Links
- relates to
-
MDEV-20816 Assertions `maybe_null || !null_value' and `args[0]->type_handler()->mysql_timestamp_type() == MYSQL_TIMESTAMP_TIME' fail in Item_func_round::time_op
- Confirmed
-
MDEV-23928 Assertion `maybe_null || !null_value' fails in Item_func_ceiling::time_op
- Confirmed