Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
Description
Not repeatable in maria-5.3 . May be related to 794890 .
backtrace:
#4 <signal handler called>
#5 0x081b6829 in st_table::set_table_map (this=0x0, map_arg=8, tablenr_arg=3) at table.h:966
#6 0x081b5a42 in st_select_lex::remap_tables (this=0xae62c1b8, derived=0xae614168, map=8, tablenr=3, parent_lex=0xae613730) at sql_lex.cc:3356
#7 0x081b5c1e in st_select_lex::merge_subquery (this=0xae613730, derived=0xae614168, subq_select=0xae62c1b8, table_no=1, map=2) at sql_lex.cc:3425
#8 0x0846a8e4 in mysql_derived_merge (thd=0xa7a0730, lex=0xa7a1df0, derived=0xae614168) at sql_derived.cc:390
#9 0x0846ad28 in mysql_derived_merge_for_insert (thd=0xa7a0730, lex=0xa7a1df0, derived=0xae614168) at sql_derived.cc:507
#10 0x0846a637 in mysql_handle_single_derived (lex=0xa7a1df0, derived=0xae614168, phases=16) at sql_derived.cc:171
#11 0x08314ee4 in TABLE_LIST::handle_derived (this=0xae614168, lex=0xa7a1df0, phases=16) at table.cc:5762
#12 0x081b574c in st_select_lex::handle_derived (this=0xae613730, lex=0xa7a1df0, phases=16) at sql_lex.cc:3205
#13 0x08314ea7 in TABLE_LIST::handle_derived (this=0xae612f60, lex=0xa7a1df0, phases=16) at table.cc:5760
#14 0x0834ea92 in mysql_prepare_insert (thd=0xa7a0730, table_list=0xae612f60, table=0x0, fields=..., values=0xae613258, update_fields=...,
update_values=..., duplic=DUP_ERROR, where=0xae99f6c0, select_insert=false, check_fields=true, abort_on_warning=false) at sql_insert.cc:1276
#15 0x0834d346 in mysql_insert (thd=0xa7a0730, table_list=0xae612f60, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR,
ignore=false) at sql_insert.cc:669
#16 0x082ab457 in mysql_execute_command (thd=0xa7a0730) at sql_parse.cc:3172
#17 0x082b4106 in mysql_parse (thd=0xa7a0730, rawbuf=0xae612eb0 "INSERT INTO v3 (f1) VALUES (1)", length=30, found_semicolon=0xae9a0228) at sql_parse.cc:6087
#18 0x082a657b in dispatch_command (command=COM_QUERY, thd=0xa7a0730, packet=0xa7fb231 "INSERT INTO v3 (f1) VALUES (1)", packet_length=30)
at sql_parse.cc:1206
#19 0x082a5a01 in do_command (thd=0xa7a0730) at sql_parse.cc:904
#20 0x082a2a7c in handle_one_connection (arg=0xa7a0730) at sql_connect.cc:1177
#21 0x00821919 in start_thread () from /lib/libpthread.so.0
#22 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 int );
CREATE TABLE t2 ( f1 int );
CREATE TABLE t3 ( f1 int );
CREATE VIEW v1 AS SELECT t1.f1 FROM t1 JOIN t2 ;
CREATE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT f1 FROM t2;
CREATE VIEW v3 AS SELECT v1.f1 FROM v1 JOIN v2 ;
INSERT INTO v3 (f1) VALUES (1);
bzr version-info
revision-id: <email address hidden>
date: 2011-06-09 00:13:00 -0700
build-date: 2011-06-09 11:17:09 +0300
revno: 3029
branch-nick: maria-5.3-mwl106