Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
Reproducible on 10.2-10.4 with MyIsam/Innodb
CREATE TABLE t1 ( f1 int, f2 int, f3 int, f4 int); |
CREATE TABLE t2 ( f1 int, f2 int, f3 int, f4 int); |
|
CREATE VIEW v1 AS SELECT dt1.* FROM (SELECT t2.* FROM t2) dt1 WHERE dt1.f3 <9; |
CREATE VIEW v2 AS SELECT dt1.* |
FROM (SELECT t1.f1, t1.f2, v1.f3, v1.f4 FROM (v1 JOIN t1 on(v1.f2 = t1.f1))) dt1; |
|
CREATE PROCEDURE sp() UPDATE v2 SET f2 = 211, f4 = 1; |
|
--error ER_NON_UPDATABLE_TABLE
|
CALL sp;
|
--error ER_NON_UPDATABLE_TABLE
|
CALL sp;
|
--error ER_NON_UPDATABLE_TABLE |
CALL sp;
|
|
# Cleanup
|
DROP PROCEDURE sp; |
DROP VIEW v1,v2; |
DROP TABLE t1, t2; |
10.2 40b4f9c907e58a4b6567 |
=================================================================
|
==9915==ERROR: AddressSanitizer: heap-use-after-free on address 0x625000109188 at pc 0x563ce8f9fc3b bp 0x7f4995d34790 sp 0x7f4995d34780
|
READ of size 8 at 0x625000109188 thread T27
|
#0 0x563ce8f9fc3a in mysql_derived_prepare(THD*, LEX*, TABLE_LIST*) /10.2/sql/sql_derived.cc:843
|
#1 0x563ce8f9c1a3 in mysql_handle_derived(LEX*, unsigned int) /10.2/sql/sql_derived.cc:121
|
#2 0x563ce9255b57 in mysql_multi_update_prepare(THD*) /10.2/sql/sql_update.cc:1394
|
#3 0x563ce9015de3 in mysql_execute_command(THD*) /10.2/sql/sql_parse.cc:4316
|
#4 0x563ce996db3b in sp_instr_stmt::exec_core(THD*, unsigned int*) /10.2/sql/sp_head.cc:3246
|
#5 0x563ce996c7be in sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*) /10.2/sql/sp_head.cc:3009
|
#6 0x563ce996d418 in sp_instr_stmt::execute(THD*, unsigned int*) /10.2/sql/sp_head.cc:3162
|
#7 0x563ce9962db9 in sp_head::execute(THD*, bool) /10.2/sql/sp_head.cc:1327
|
#8 0x563ce9966c10 in sp_head::execute_procedure(THD*, List<Item>*) /10.2/sql/sp_head.cc:2116
|
#9 0x563ce900e398 in do_execute_sp /10.2/sql/sql_parse.cc:2918
|
#10 0x563ce902014d in mysql_execute_command(THD*) /10.2/sql/sql_parse.cc:5831
|
#11 0x563ce902d430 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.2/sql/sql_parse.cc:8018
|
#12 0x563ce900891c in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.2/sql/sql_parse.cc:1829
|
#13 0x563ce9005a4b in do_command(THD*) /10.2/sql/sql_parse.cc:1379
|
#14 0x563ce932df36 in do_handle_one_connection(CONNECT*) /10.2/sql/sql_connect.cc:1336
|
#15 0x563ce932d93e in handle_one_connection /10.2/sql/sql_connect.cc:1242
|
#16 0x563cea4dcf87 in pfs_spawn_thread /10.2/storage/perfschema/pfs.cc:1862
|
#17 0x7f49ad30e6b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
|
#18 0x7f49ac7a341c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)
|
|
Attachments
Issue Links
- relates to
-
MDEV-16940 Server crashes in unsafe_key_update upon attempt to update view through 2nd execution of SP
- Closed