[MDEV-28578] Server crashes in Item_field::fix_outer_field after CREATE SELECT Created: 2022-05-16  Updated: 2022-05-16  Resolved: 2022-05-16

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26412 Server crash in Item_field::fix_outer... Closed

 Description   

CREATE TABLE t1 (i int) ;
CREATE TABLE t2 (j int) ;
create table t SELECT 1 FROM t1 JOIN t2 ON (SELECT dt.i);

bb-10.4-release 2ab6983e595ab994b1d

Version: '10.4.25-MariaDB-debug-log'  
220516 15:29:09 [ERROR] mysqld got signal 11 ;
 
Server version: 10.4.25-MariaDB-debug-log
 
sql/signal_handler.cc:222(handle_fatal_signal)[0x556892d71af0]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7fe1e689b730]
sql/item.cc:5567(Item_field::fix_outer_field(THD*, Field**, Item**))[0x556892da2ec2]
sql/item.cc:5984(Item_field::fix_fields(THD*, Item**))[0x556892da4551]
sql/item.h:965(Item::fix_fields_if_needed(THD*, Item**))[0x556892928ec1]
sql/item.h:968(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x556892928eef]
sql/sql_base.cc:7714(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool))[0x5568929a88ba]
sql/sql_select.cc:1278(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x556892a8943a]
sql/item_subselect.cc:3845(subselect_single_select_engine::prepare(THD*))[0x556892e62408]
sql/item_subselect.cc:289(Item_subselect::fix_fields(THD*, Item**))[0x556892e54cae]
sql/item.h:965(Item::fix_fields_if_needed(THD*, Item**))[0x556892928ec1]
sql/item.h:968(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x556892928eef]
sql/item.h:973(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x5568929ae833]
sql/sql_base.cc:8332(setup_on_expr(THD*, TABLE_LIST*, bool))[0x5568929aa867]
sql/sql_base.cc:8451(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x5568929aacfe]
sql/sql_select.cc:724(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x556892a8670e]
sql/sql_select.cc:1283(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x556892a89570]
sql/sql_select.cc:4729(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*))[0x556892a962ee]
sql/sql_select.cc:436(handle_select(THD*, LEX*, select_result*, unsigned long))[0x556892a85d08]
sql/sql_table.cc:11616(Sql_cmd_create_table_like::execute(THD*))[0x556892b3c3f2]
sql/sql_parse.cc:6208(mysql_execute_command(THD*))[0x556892a4a04b]
sql/sql_parse.cc:8011(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556892a4f37b]
sql/sql_parse.cc:1876(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556892a3b7e3]
sql/sql_parse.cc:1378(do_command(THD*))[0x556892a39ef0]
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x556892bc7d3f]
sql/sql_connect.cc:1317(handle_one_connection)[0x556892bc79e4]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55689310a90e]
nptl/pthread_create.c:487(start_thread)[0x7fe1e6890fa3]
x86_64/clone.S:97(clone)[0x7fe1e6499eff]
 
Query (0x7fe1d0014768): create table t SELECT 1 FROM t1 JOIN t2 ON (SELECT dt.i)


Generated at Thu Feb 08 10:01:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.