Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.3(EOL)
Description
Setting to minor, as it's an old 10.3-only debug failure. 10.3 goes EOL anyway, so it won't be fixed, filing it for the record.
CREATE TABLE t (a INT); |
INSERT INTO t VALUES (1),(2); |
PREPARE stmt FROM 'SELECT * FROM t ORDER BY ?'; |
ALTER TABLE t ADD INDEX (a); |
EXECUTE stmt USING 1; |
|
|
# Cleanup
|
DROP TABLE t; |
|
10.3 55a53949 |
mysqld: /data/src/10.3/sql/item.cc:4956: virtual bool Item_param::basic_const_item() const: Assertion `fixed || state == NO_VALUE' failed.
|
230503 19:04:55 [ERROR] mysqld got signal 6 ;
|
|
|
#9 0x00007f0747e53df2 in __GI___assert_fail (assertion=0x5635f86479a0 "fixed || state == NO_VALUE", file=0x5635f8643800 "/data/src/10.3/sql/item.cc", line=4956, function=0x5635f86479e0 "virtual bool Item_param::basic_const_item() const") at ./assert/assert.c:101
|
#10 0x00005635f6db33c4 in Item_param::basic_const_item (this=0x62b0000412e8) at /data/src/10.3/sql/item.cc:4956
|
#11 0x00005635f673483c in find_order_in_list (thd=0x62a000060208, ref_pointer_array=..., tables=0x62b000040c30, order=0x62b0000414b0, fields=..., all_fields=..., is_group_field=false, add_to_all_fields=true, from_window_spec=false) at /data/src/10.3/sql/sql_select.cc:23681
|
#12 0x00005635f6735be5 in setup_order (thd=0x62a000060208, ref_pointer_array=..., tables=0x62b000040c30, fields=..., all_fields=..., order=0x62b0000414b0, from_window_spec=false) at /data/src/10.3/sql/sql_select.cc:23846
|
#13 0x00005635f6684503 in setup_without_group (thd=0x62a000060208, ref_pointer_array=..., tables=0x62b000040c30, leaves=..., fields=..., all_fields=..., conds=0x62b000000fe8, order=0x62b0000414b0, group=0x0, win_specs=..., win_funcs=..., hidden_group_fields=0x62b000000ec7, reserved=0x62b00003fdc4) at /data/src/10.3/sql/sql_select.cc:691
|
#14 0x00005635f668a45b in JOIN::prepare (this=0x62b000000be0, tables_init=0x62b000040c30, wild_num=0, conds_init=0x0, og_num=1, order_init=0x62b0000414b0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x62b00003fab8, unit_arg=0x62b00003f2f8) at /data/src/10.3/sql/sql_select.cc:1181
|
#15 0x00005635f66abec6 in mysql_select (thd=0x62a000060208, tables=0x62b000040c30, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x62b0000414b0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x62b000041520, unit=0x62b00003f2f8, select_lex=0x62b00003fab8) at /data/src/10.3/sql/sql_select.cc:4371
|
#16 0x00005635f668205b in handle_select (thd=0x62a000060208, lex=0x62b00003f238, result=0x62b000041520, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:372
|
#17 0x00005635f65f66e6 in execute_sqlcom_select (thd=0x62a000060208, all_tables=0x62b000040c30) at /data/src/10.3/sql/sql_parse.cc:6340
|
#18 0x00005635f65e44b7 in mysql_execute_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:3871
|
#19 0x00005635f6650b29 in Prepared_statement::execute (this=0x619000082088, expanded_query=0x7f073f041dd0, open_cursor=false) at /data/src/10.3/sql/sql_prepare.cc:5029
|
#20 0x00005635f664bf58 in Prepared_statement::execute_loop (this=0x619000082088, expanded_query=0x7f073f041dd0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.3/sql/sql_prepare.cc:4457
|
#21 0x00005635f6646148 in mysql_sql_stmt_execute (thd=0x62a000060208) at /data/src/10.3/sql/sql_prepare.cc:3545
|
#22 0x00005635f65e44fc in mysql_execute_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:3887
|
#23 0x00005635f6600180 in mysql_parse (thd=0x62a000060208, rawbuf=0x62b000000228 "EXECUTE stmt USING 1", length=20, parser_state=0x7f073f0439b0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7855
|
#24 0x00005635f65d6faf in dispatch_command (command=COM_QUERY, thd=0x62a000060208, packet=0x6290000dc209 "EXECUTE stmt USING 1", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
|
#25 0x00005635f65d3b47 in do_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:1398
|
#26 0x00005635f699bf5c in do_handle_one_connection (connect=0x6080000006a8) at /data/src/10.3/sql/sql_connect.cc:1404
|
#27 0x00005635f699b889 in handle_one_connection (arg=0x6080000006a8) at /data/src/10.3/sql/sql_connect.cc:1309
|
#28 0x00005635f7f82bd5 in pfs_spawn_thread (arg=0x615000003008) at /data/src/10.3/storage/perfschema/pfs.cc:1869
|
#29 0x00007f0747ea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#30 0x00007f0747f285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|