Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.0, 11.1, 11.2
-
None
Description
CREATE TABLE t1 (a VARCHAR(8)) COLLATE latin1_swedish_ci; |
CREATE TABLE t2 (b VARCHAR(8)) COLLATE latin1_general_ci; |
|
PREPARE stmt FROM 'SELECT * FROM ((SELECT * FROM t1 WHERE a IN (SELECT b FROM t2)) AS sq)'; |
|
--error ER_CANT_AGGREGATE_2COLLATIONS
|
EXECUTE stmt; |
EXECUTE stmt; |
|
# Cleanup
|
DROP TABLE t1, t2; |
10.5 dd62a285b88958dae9b9f3e49fdd0c55f6eced72 |
#3 <signal handler called>
|
#4 0x000055d20acd6f0f in mark_select_range_as_dependent (thd=0x62b000069218, last_select=0x62b00009bf60, current_sel=0x62b00009d4b8, found_field=0x61900009bb20, found_item=0x62b00009d9a8, resolved_item=0x62b00009d9a8, suppress_warning_output=true) at /data/src/10.5-asan/sql/item.cc:5234
|
#5 0x000055d20a2c0944 in find_field_in_tables (thd=0x62b000069218, item=0x62b00009d9a8, first_table=0x62b00009db58, last_table=0x0, ref=0x62b00009daf8, report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at /data/src/10.5-asan/sql/sql_base.cc:6399
|
#6 0x000055d20acdcee8 in Item_field::fix_fields (this=0x62b00009d9a8, thd=0x62b000069218, reference=0x62b00009daf8) at /data/src/10.5-asan/sql/item.cc:5957
|
#7 0x000055d20a19ca43 in Item::fix_fields_if_needed (this=0x62b00009d9a8, thd=0x62b000069218, ref=0x62b00009daf8) at /data/src/10.5-asan/sql/item.h:990
|
#8 0x000055d20a19ca79 in Item::fix_fields_if_needed_for_scalar (this=0x62b00009d9a8, thd=0x62b000069218, ref=0x62b00009daf8) at /data/src/10.5-asan/sql/item.h:994
|
#9 0x000055d20a2c8207 in setup_fields (thd=0x62b000069218, ref_pointer_array=..., fields=..., column_usage=MARK_COLUMNS_READ, sum_func_list=0x62b000038ef0, pre_fix=0x62b00009d638, allow_sum_func=true) at /data/src/10.5-asan/sql/sql_base.cc:7657
|
#10 0x000055d20a4fcaf1 in JOIN::prepare (this=0x62b000038bc0, tables_init=0x62b00009db58, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x62b00009d4b8, unit_arg=0x62b00009e2a0) at /data/src/10.5-asan/sql/sql_select.cc:1356
|
#11 0x000055d20aeb224a in subselect_single_select_engine::prepare (this=0x62b00009ed38, thd=0x62b000069218) at /data/src/10.5-asan/sql/item_subselect.cc:3851
|
#12 0x000055d20ae8b1d8 in Item_subselect::fix_fields (this=0x62b00009eae0, thd_param=0x62b000069218, ref=0x62b00009f690) at /data/src/10.5-asan/sql/item_subselect.cc:291
|
#13 0x000055d20aeaf0f7 in Item_in_subselect::fix_fields (this=0x62b00009eae0, thd_arg=0x62b000069218, ref=0x62b00009f690) at /data/src/10.5-asan/sql/item_subselect.cc:3513
|
#14 0x000055d20a19ca43 in Item::fix_fields_if_needed (this=0x62b00009eae0, thd=0x62b000069218, ref=0x62b00009f690) at /data/src/10.5-asan/sql/item.h:990
|
#15 0x000055d20a19ca79 in Item::fix_fields_if_needed_for_scalar (this=0x62b00009eae0, thd=0x62b000069218, ref=0x62b00009f690) at /data/src/10.5-asan/sql/item.h:994
|
#16 0x000055d20a2d6d67 in Item::fix_fields_if_needed_for_bool (this=0x62b00009eae0, thd=0x62b000069218, ref=0x62b00009f690) at /data/src/10.5-asan/sql/item.h:998
|
#17 0x000055d20a2cd7fe in setup_on_expr (thd=0x62b000069218, table=0x62b00009f630, is_update=false) at /data/src/10.5-asan/sql/sql_base.cc:8372
|
#18 0x000055d20a2ce410 in setup_conds (thd=0x62b000069218, tables=0x62b00009f630, leaves=..., conds=0x62b0000388a0) at /data/src/10.5-asan/sql/sql_base.cc:8491
|
#19 0x000055d20a4f5252 in setup_without_group (thd=0x62b000069218, ref_pointer_array=..., tables=0x62b00009f630, leaves=..., fields=..., all_fields=..., conds=0x62b0000388a0, order=0x0, group=0x0, win_specs=..., win_funcs=..., hidden_group_fields=0x62b000038777) at /data/src/10.5-asan/sql/sql_select.cc:752
|
#20 0x000055d20a4fce19 in JOIN::prepare (this=0x62b000038488, tables_init=0x62b00009f630, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x62b00009bf60, unit_arg=0x62b00009a310) at /data/src/10.5-asan/sql/sql_select.cc:1361
|
#21 0x000055d20a5225f8 in mysql_select (thd=0x62b000069218, tables=0x62b00009f630, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x62b00009fd80, unit=0x62b00009a310, select_lex=0x62b00009bf60) at /data/src/10.5-asan/sql/sql_select.cc:4855
|
#22 0x000055d20a4f326a in handle_select (thd=0x62b000069218, lex=0x62b00009a248, result=0x62b00009fd80, setup_tables_done_option=0) at /data/src/10.5-asan/sql/sql_select.cc:450
|
#23 0x000055d20a45c1f1 in execute_sqlcom_select (thd=0x62b000069218, all_tables=0x62b00009f630) at /data/src/10.5-asan/sql/sql_parse.cc:6343
|
#24 0x000055d20a44ace5 in mysql_execute_command (thd=0x62b000069218) at /data/src/10.5-asan/sql/sql_parse.cc:4020
|
#25 0x000055d20a4bc374 in Prepared_statement::execute (this=0x619000099c98, expanded_query=0x7f48f48d1da0, open_cursor=false) at /data/src/10.5-asan/sql/sql_prepare.cc:5119
|
#26 0x000055d20a4b7819 in Prepared_statement::execute_loop (this=0x619000099c98, expanded_query=0x7f48f48d1da0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.5-asan/sql/sql_prepare.cc:4541
|
#27 0x000055d20a4b13f3 in mysql_sql_stmt_execute (thd=0x62b000069218) at /data/src/10.5-asan/sql/sql_prepare.cc:3594
|
#28 0x000055d20a44ad2a in mysql_execute_command (thd=0x62b000069218) at /data/src/10.5-asan/sql/sql_parse.cc:4036
|
#29 0x000055d20a46721b in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "EXECUTE stmt", length=12, parser_state=0x7f48f48d2c10, is_com_multi=false, is_next_command=false) at /data/src/10.5-asan/sql/sql_parse.cc:8121
|
#30 0x000055d20a43cb1e in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000253219 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.5-asan/sql/sql_parse.cc:1891
|
#31 0x000055d20a4394b1 in do_command (thd=0x62b000069218) at /data/src/10.5-asan/sql/sql_parse.cc:1375
|
#32 0x000055d20a88a4b9 in do_handle_one_connection (connect=0x608000002b38, put_in_cache=true) at /data/src/10.5-asan/sql/sql_connect.cc:1416
|
#33 0x000055d20a889e81 in handle_one_connection (arg=0x608000002ab8) at /data/src/10.5-asan/sql/sql_connect.cc:1318
|
#34 0x000055d20b4dac32 in pfs_spawn_thread (arg=0x615000005318) at /data/src/10.5-asan/storage/perfschema/pfs.cc:2201
|
#35 0x00007f48fc0a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#36 0x00007f48fc12861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Reproducible on 10.5+.
Not reproducible on 10.4.
Attachments
Issue Links
- relates to
-
MDEV-32684 Server crash in JOIN::transform_in_predicates_into_in_subq on 2nd execution of PS with a mix of collations
-
- Open
-