Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.4(EOL)
-
None
-
None
Description
CREATE TABLE t1 (tm time(6) NOT NULL DEFAULT '00:00:00.000000') engine=myisam; |
SELECT 1 FROM t1 WHERE CEILING(tm) ; |
Version: '10.4.16-MariaDB-debug-log' socket: '/10.4/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
mysqld: /10.4/sql/item_func.cc:2317: virtual bool Item_func_ceiling::time_op(THD*, MYSQL_TIME*): Assertion `maybe_null || !null_value' failed.
|
201009 11:25:15 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.16-MariaDB-debug-log
|
|
linux/raise.c:51(__GI_raise)[0x7fa7ff38b7bb]
|
stdlib/abort.c:81(__GI_abort)[0x7fa7ff376535]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fa7ff37640f]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7fa7ff384102]
|
sql/item_func.cc:2318(Item_func_ceiling::time_op(THD*, st_mysql_time*))[0x555ac52d096a]
|
sql/item_func.h:718(Item_func_hybrid_field_type::time_op_with_null_check(THD*, st_mysql_time*))[0x555ac528b6d9]
|
sql/item_func.cc:912(Item_func_hybrid_field_type::val_real_from_time_op())[0x555ac4eac994]
|
sql/sql_type.cc:4989(Type_handler_time_common::Item_func_hybrid_field_type_val_real(Item_func_hybrid_field_type*) const)[0x555ac493788f]
|
sql/item_func.h:788(Item_func_hybrid_field_type::val_real())[0x555ac46cf52e]
|
sql/sql_type.cc:4518(Type_handler_temporal_result::Item_val_bool(Item*) const)[0x555ac4af4f34]
|
sql/item.h:1462(Item::val_bool())[0x555ac4a262d7]
|
sql/item.h:1470(Item::eval_const_cond())[0x555ac4a1f2ae]
|
sql/sql_select.cc:17435(Item::remove_eq_conds(THD*, Item::cond_result*, bool))[0x555ac4a3fa15]
|
sql/sql_select.cc:5331(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x555ac4a11a04]
|
sql/sql_select.cc:2268(JOIN::optimize_inner())[0x555ac4985971]
|
sql/sql_select.cc:1615(JOIN::optimize())[0x555ac49732c5]
|
sql/sql_select.cc:4681(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x555ac498ea3b]
|
sql/sql_select.cc:410(handle_select(THD*, LEX*, select_result*, unsigned long))[0x555ac496602a]
|
sql/sql_parse.cc:6355(execute_sqlcom_select(THD*, TABLE_LIST*))[0x555ac4962aa9]
|
sql/sql_parse.cc:3889(mysql_execute_command(THD*))[0x555ac4d3f695]
|
sql/sql_parse.cc:7896(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555ac4d3ef37]
|
sql/sql_parse.cc:1837(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x555ac636e80f]
|
nptl/pthread_create.c:487(start_thread)[0x7fa7ffe46fa3]
|
|
Query (0x62b000062290): SELECT 1 FROM t1 WHERE CEILING(tm)
|
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-21797 Assertion `maybe_null || !null_value' failed in Item_func_round::time_op
- Confirmed