Details
Description
Reproducible on 10.4-10.5, with MyIsam, not with InnoDB, with empty table t1.
create table t1 (a1 int, a2 decimal(10,0) not null) engine=myisam; |
select min(1 mod a1), bit_or(a2) over () from t1; |
10.4 ea7830eef48333e28f98a9 |
#3 <signal handler called>
|
#4 0x00007f75bc066428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f75bc06802a in __GI_abort () at abort.c:89
|
#6 0x00007f75bc05ebd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55b47e2f8ab5 "!field->is_null()", file=file@entry=0x55b47e2f8a38 "/10.4/sql/my_decimal.cc", line=line@entry=382, function=function@entry=0x55b47e2f8c10 <my_decimal::my_decimal(Field*)::__PRETTY_FUNCTION__> "my_decimal::my_decimal(Field*)") at assert.c:92
|
#7 0x00007f75bc05ec82 in __GI___assert_fail (assertion=0x55b47e2f8ab5 "!field->is_null()", file=0x55b47e2f8a38 "/10.4/sql/my_decimal.cc", line=382, function=0x55b47e2f8c10 <my_decimal::my_decimal(Field*)::__PRETTY_FUNCTION__> "my_decimal::my_decimal(Field*)") at assert.c:101
|
#8 0x000055b47d8df4f3 in my_decimal::my_decimal (this=0x7f75b45b90c0, field=0x7f756419eb30) at /10.4/sql/my_decimal.cc:382
|
#9 0x000055b47d756d82 in Field::do_field_decimal (copy=0x7f7564017870) at /10.4/sql/field_conv.cc:416
|
#10 0x000055b47d495b64 in copy_fields (param=0x7f75640177d0) at /10.4/sql/sql_select.cc:25029
|
#11 0x000055b47d48d65c in end_write (join=0x7f7564015170, join_tab=0x7f7564017428, end_of_records=false) at /10.4/sql/sql_select.cc:21786
|
#12 0x000055b47d4a0868 in AGGR_OP::put_record (this=0x7f7564017ac8, end_of_records=false) at /10.4/sql/sql_select.cc:28596
|
#13 0x000055b47d4a64f1 in AGGR_OP::put_record (this=0x7f7564017ac8) at /10.4/sql/sql_select.h:1046
|
#14 0x000055b47d48954a in sub_select_postjoin_aggr (join=0x7f7564015170, join_tab=0x7f7564017428, end_of_records=false) at /10.4/sql/sql_select.cc:20086
|
#15 0x000055b47d488f38 in do_select (join=0x7f7564015170, procedure=0x0) at /10.4/sql/sql_select.cc:19904
|
#16 0x000055b47d45dbf9 in JOIN::exec_inner (this=0x7f7564015170) at /10.4/sql/sql_select.cc:4459
|
#17 0x000055b47d45cd36 in JOIN::exec (this=0x7f7564015170) at /10.4/sql/sql_select.cc:4241
|
#18 0x000055b47d45e44b in mysql_select (thd=0x7f7564000af0, tables=0x7f7564014108, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f7564015148, unit=0x7f7564004a18, select_lex=0x7f7564013260) at /10.4/sql/sql_select.cc:4673
|
#19 0x000055b47d44dee4 in handle_select (thd=0x7f7564000af0, lex=0x7f7564004958, result=0x7f7564015148, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:422
|
#20 0x000055b47d4147ac in execute_sqlcom_select (thd=0x7f7564000af0, all_tables=0x7f7564014108) at /10.4/sql/sql_parse.cc:6359
|
#21 0x000055b47d40ae98 in mysql_execute_command (thd=0x7f7564000af0) at /10.4/sql/sql_parse.cc:3898
|
#22 0x000055b47d41878d in mysql_parse (thd=0x7f7564000af0, rawbuf=0x7f7564013198 "select min(1 mod a1), bit_or(a2) over () from t1", length=48, parser_state=0x7f75b45ba3f0, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7900
|
#23 0x000055b47d404d2d in dispatch_command (command=COM_QUERY, thd=0x7f7564000af0, packet=0x7f75641372a1 "", packet_length=48, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1842
|
#24 0x000055b47d4034a3 in do_command (thd=0x7f7564000af0) at /10.4/sql/sql_parse.cc:1360
|
#25 0x000055b47d58c3fe in do_handle_one_connection (connect=0x55b48080e9d0) at /10.4/sql/sql_connect.cc:1412
|
#26 0x000055b47d58c127 in handle_one_connection (arg=0x55b48080e9d0) at /10.4/sql/sql_connect.cc:1316
|
#27 0x000055b47df8d87d in pfs_spawn_thread (arg=0x55b48077dc80) at /10.4/storage/perfschema/pfs.cc:1869
|
#28 0x00007f75bd5556ba in start_thread (arg=0x7f75b45bb700) at pthread_create.c:333
|
#29 0x00007f75bc13841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
No visible effect on non-debug build
Attachments
Issue Links
- relates to
-
MDEV-22700 Assertion `subq_pred->engine->engine_type() == subselect_engine::SINGLE_SELECT_ENGINE' failed in setup_jtbm_semi_joins
- Stalled
-
MDEV-23438 Assertion `!field->is_null()' failed in my_decimal::my_decimal fails in ONLY_FULL_GROUP_BY mode
- Stalled
-
MDEV-23749 Assertion `!field->is_null()' failed in my_decimal::my_decimal on SELECT
- Stalled