Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL)
-
None
Description
Note: Possibly it's just an ugly side-effect of MDEV-20815, as I couldn't reproduce it with a "good" aggregate query, or without views.
CREATE TABLE t1 (a TIME NOT NULL); |
CREATE VIEW v1 AS SELECT * FROM t1; |
|
SET SQL_MODE= 'ONLY_FULL_GROUP_BY'; |
SELECT ROUND(a), COUNT(*) FROM v1; |
|
# Cleanup
|
DROP VIEW v1; |
DROP TABLE t1; |
10.4 36824d2b |
mysqld: /data/src/10.4/sql/item_func.cc:2551: virtual bool Item_func_round::time_op(THD*, MYSQL_TIME*): Assertion `maybe_null || !null_value' failed.
|
191012 18:33:35 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f72ae4baf12 in __GI___assert_fail (assertion=0x55fa7f51a5e0 "maybe_null || !null_value", file=0x55fa7f51a248 "/data/src/10.4/sql/item_func.cc", line=2551, function=0x55fa7f51c040 <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 0x000055fa7ea7498c in Item_func_round::time_op (this=0x7f7298013810, thd=0x7f7298000b00, to=0x7f72a868a9e8) at /data/src/10.4/sql/item_func.cc:2551
|
#9 0x000055fa7e8a5ab5 in Type_handler_time_common::Item_func_hybrid_field_type_get_date (this=0x55fa7fe1dc10 <type_handler_time2>, thd=0x7f7298000b00, item=0x7f7298013810, warn=0x7f72a868a610, ltime=0x7f72a868a9e8, fuzzydate=...) at /data/src/10.4/sql/sql_type.cc:4875
|
#10 0x000055fa7e8a4814 in Type_handler::Item_func_hybrid_field_type_get_date_with_warn (this=0x55fa7fe1dc10 <type_handler_time2>, thd=0x7f7298000b00, item=0x7f7298013810, ltime=0x7f72a868a9e8, mode=...) at /data/src/10.4/sql/sql_type.cc:4408
|
#11 0x000055fa7e66ba34 in Item_func_hybrid_field_type::get_date (this=0x7f7298013810, thd=0x7f7298000b00, to=0x7f72a868a9e8, mode=...) at /data/src/10.4/sql/item_func.h:777
|
#12 0x000055fa7e8ba5b0 in Item::get_time (this=0x7f7298013810, thd=0x7f7298000b00, ltime=0x7f72a868a9e8) at /data/src/10.4/sql/item.h:1752
|
#13 0x000055fa7e8aa49f in Type_handler::Item_send_time (this=0x55fa7fe1dc10 <type_handler_time2>, item=0x7f7298013810, protocol=0x7f72980010c8, buf=0x7f72a868a9e0) at /data/src/10.4/sql/sql_type.cc:6822
|
#14 0x000055fa7e8b73da in Type_handler_time_common::Item_send (this=0x55fa7fe1dc10 <type_handler_time2>, item=0x7f7298013810, protocol=0x7f72980010c8, buf=0x7f72a868a9e0) at /data/src/10.4/sql/sql_type.h:5250
|
#15 0x000055fa7e56523a in Item::send (this=0x7f7298013810, protocol=0x7f72980010c8, buffer=0x7f72a868a9e0) at /data/src/10.4/sql/item.h:1034
|
#16 0x000055fa7e55f385 in Protocol::send_result_set_row (this=0x7f72980010c8, row_items=0x7f7298013318) at /data/src/10.4/sql/protocol.cc:1035
|
#17 0x000055fa7e613fa4 in select_send::send_data (this=0x7f7298018220, items=...) at /data/src/10.4/sql/sql_class.cc:3002
|
#18 0x000055fa7e6f69cf in return_zero_rows (join=0x7f7298018248, result=0x7f7298018220, tables=..., fields=..., send_row=true, select_options=2147748608, info=0x55fa7f388b28 "no matching row in const table", having=0x0, all_fields=...) at /data/src/10.4/sql/sql_select.cc:14196
|
#19 0x000055fa7e6dabed in JOIN::exec_inner (this=0x7f7298018248) at /data/src/10.4/sql/sql_select.cc:4314
|
#20 0x000055fa7e6da13e in JOIN::exec (this=0x7f7298018248) at /data/src/10.4/sql/sql_select.cc:4168
|
#21 0x000055fa7e6db853 in mysql_select (thd=0x7f7298000b00, tables=0x7f7298013b40, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f7298018220, unit=0x7f7298004a30, select_lex=0x7f72980131d0) at /data/src/10.4/sql/sql_select.cc:4600
|
#22 0x000055fa7e6cb7c4 in handle_select (thd=0x7f7298000b00, lex=0x7f7298004968, result=0x7f7298018220, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:420
|
#23 0x000055fa7e692193 in execute_sqlcom_select (thd=0x7f7298000b00, all_tables=0x7f7298013b40) at /data/src/10.4/sql/sql_parse.cc:6352
|
#24 0x000055fa7e68787a in mysql_execute_command (thd=0x7f7298000b00) at /data/src/10.4/sql/sql_parse.cc:3894
|
#25 0x000055fa7e6962b1 in mysql_parse (thd=0x7f7298000b00, rawbuf=0x7f7298013128 "SELECT ROUND(a), COUNT(*) FROM v1", length=33, parser_state=0x7f72a868c170, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7912
|
#26 0x000055fa7e681544 in dispatch_command (command=COM_QUERY, thd=0x7f7298000b00, packet=0x7f7298008331 "", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1841
|
#27 0x000055fa7e67fbd1 in do_command (thd=0x7f7298000b00) at /data/src/10.4/sql/sql_parse.cc:1359
|
#28 0x000055fa7e807603 in do_handle_one_connection (connect=0x55fa81bbfaf0) at /data/src/10.4/sql/sql_connect.cc:1412
|
#29 0x000055fa7e807352 in handle_one_connection (arg=0x55fa81bbfaf0) at /data/src/10.4/sql/sql_connect.cc:1316
|
#30 0x000055fa7f2088bb in pfs_spawn_thread (arg=0x55fa81bdb680) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#31 0x00007f72b00304a4 in start_thread (arg=0x7f72a868d700) at pthread_create.c:456
|
#32 0x00007f72ae577d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Also reproducible on 10.5.
Couldn't reproduce with 10.3, but maybe it's because of different defaults.
No obvious effect on a non-debug build.
Attachments
Issue Links
- relates to
-
MDEV-20501 Assertion `maybe_null || !null_value' failed in Item_func_round::date_op
- Stalled
-
MDEV-20815 ONLY_FULL_GROUP_BY is ignored with derived_merge=on or merge views
- Open
-
MDEV-21797 Assertion `maybe_null || !null_value' failed in Item_func_round::time_op
- Confirmed
-
MDEV-23928 Assertion `maybe_null || !null_value' fails in Item_func_ceiling::time_op
- Confirmed