|
The closest one, that I got:
sql/sql_base.cc:5708(find_field_in_table(THD*, TABLE*, char const*, unsigned long, bool, unsigned int*))[0x5637473aaa32]
|
sql/sql_base.cc:5866(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x5637473af443]
|
sql/sql_base.cc:6168(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x5637473af864]
|
sql/item.cc:6151(Item_field::fix_fields(THD*, Item**))[0x5637475d876b]
|
sql/item_func.cc:363(Item_func::fix_fields(THD*, Item**))[0x56374760dbcf]
|
sql/item.h:826(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x5637473ab8af]
|
sql/sql_base.cc:8118(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x5637473abadc]
|
sql/sql_select.cc:647(setup_without_group)[0x56374743d197]
|
sql/sql_union.cc:667(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long, bool))[0x56374748d1f5]
|
sql/sql_union.cc:977(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long))[0x56374748fd9a]
|
sql/sql_derived.cc:766(mysql_derived_prepare(THD*, LEX*, TABLE_LIST*))[0x5637473cbf9a]
|
sql/sql_derived.cc:104(mysql_handle_derived(LEX*, unsigned int))[0x5637473cb4fe]
|
sql/sql_base.cc:5012(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x5637473aa6b4]
|
sql/sql_prepare.cc:2027(mysql_test_create_view)[0x563747414ec4]
|
sql/sql_prepare.cc:4877(Prepared_statement::execute_immediate(char const*, unsigned int))[0x563747417244]
|
sql/sql_prepare.cc:2880(mysql_sql_stmt_execute_immediate(THD*))[0x563747417476]
|
sql/sql_parse.cc:3774(mysql_execute_command(THD*))[0x5637473fcae6]
|
sql/sql_class.h:1809(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563747402fc9]
|
sql/sql_parse.cc:1850(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56374740504a]
|
sql/sql_parse.cc:1397(do_command(THD*))[0x5637474057ce]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5637474cbdaf]
|
sql/sql_connect.cc:1310(handle_one_connection)[0x5637474cbed4]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f01f58696ba]
|
x86_64/clone.S:111(clone)[0x7f01f46ce41d]
|
with test case
CREATE TABLE t1 (
|
eid int ,
|
entity_type_id int ,
|
t4ibute_set_id int ,
|
type_id varchar(32) ,
|
sku varchar(32) ,
|
has_options smallint(6) ,
|
required_options int ,
|
created_at timestamp NULL ,
|
updated_at timestamp NULL
|
) ENGINE=InnoDB ;
|
|
insert into t1
|
select seq,seq,seq,'grouped',"varchar",seq,seq,now(),now() from seq_1_to_100;
|
|
CREATE TABLE t2 (
|
product_id int ,
|
website_id int
|
) ENGINE=InnoDB ;
|
|
insert into t2 select seq,seq from seq_1_to_10;
|
|
CREATE TABLE t3 (
|
id int ,
|
code varchar(32) ,
|
website_id int ,
|
group_id int ,
|
name varchar(255),
|
sort_order int ,
|
is_active int
|
) ENGINE=InnoDB ;
|
|
insert into t3
|
select seq,CONCAT("varchar",seq),seq,seq,"varchar",seq,seq from seq_1_to_10;
|
|
CREATE TABLE t4 (
|
eid int NOT NULL,
|
id int(5) NOT NULL,
|
c1 varchar(255) NOT NULL,
|
i1 int(11),
|
v1 varchar(255),
|
d1 datetime,
|
text_value text,
|
decimal_value decimal(12,4),
|
refreshed_at timestamp NOT NULL
|
);
|
|
insert into t4 select seq ,0, "visibility", seq, "varchar", now(), "text", seq, now() from seq_1_to_10;
|
|
|
CREATE TABLE t5 (
|
maker_id int ,
|
maker_sku varchar(32),
|
parent_id int ,
|
parent_sku varchar(32),
|
parent_type varchar(32),
|
eid int ,
|
entity_sku varchar(32),
|
entity_type varchar(32),
|
refreshed_at longtext
|
) ENGINE=InnoDB ;
|
|
insert into t5 select seq, "varchar", seq, "varchar","varchar" , seq,"varchar","varchar","longtext" from seq_1_to_10;
|
|
EXECUTE IMMEDIATE "CREATE view v_maker AS WITH cte1 AS
|
( SELECT DISTINCT t1.eid AS maker_id, t1.sku AS maker_sku, 1 AS is_visible FROM t1
|
JOIN (SELECT DISTINCT maker_id, maker_sku, eid FROM t5) AS heir on t1.eid=heir.eid),
|
|
ranked AS
|
( SELECT maker_id, RANK() OVER (PARTITION BY maker_id ORDER BY is_visible DESC, maker_id ASC) AS rank FROM cte1 )
|
|
SELECT * FROM ranked WHERE rank = 1;";
|
It is not repeatable after commit d8b8079e421a7d19d3e0c2c4e4a by Igor Babaev "EV-16992 Assertion `table_ref->table || table_ref->view' failed"
If the problem persists in 10.3.10, please comment here and this case will be investigated further.
|
crashy2.sql
