You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
37 lines
1.4 KiB
37 lines
1.4 KiB
#
|
|
# BUG#24594140: VIEW GETS DROPPED IF ALTER VIEW FAILS WITH
|
|
# ERRNO 1213 (ER_LOCK_DEADLOCK)
|
|
#
|
|
CREATE TABLE test.t1(fld1 INT);
|
|
CREATE VIEW test.v1 AS SELECT * FROM test.t1;
|
|
SET SESSION debug= "+d, inject_error_ha_write_row";
|
|
ALTER VIEW test.v1 AS SELECT * FROM test.t1;
|
|
ERROR HY000: Got error 122 - 'Internal (unspecified) error in handler' from storage engine
|
|
SET SESSION debug= "-d, inject_error_ha_write_row";
|
|
# Without patch, results in 'v1' not found error
|
|
# since the view is dropped but the re-create failed
|
|
# during the above ALTER VIEW.
|
|
ALTER VIEW test.v1 AS SELECT * FROM test.t1;
|
|
# Cleanup.
|
|
DROP VIEW test.v1;
|
|
DROP TABLE test.t1;
|
|
#
|
|
# Bug#27041350: ASSERTION `THD->IS_SYSTEM_THREAD() || THD->KILLED ||
|
|
# THD->IS_ERROR()' FAILED
|
|
#
|
|
# Stack overrun was incorrectly masked when
|
|
# View_metadata_updater_error_handler was active.
|
|
CREATE VIEW v1 AS SELECT 1 FROM DUAL;
|
|
CREATE TABLE t1(c INT,d INT,KEY(c));
|
|
ALTER DEFINER=s@1 VIEW v1 AS SELECT * FROM t1;
|
|
Warnings:
|
|
Note 1449 The user specified as a definer ('s'@'1') does not exist
|
|
# Enable stack overrun simulation, after having installed
|
|
# View_metadata_updater_error_handler. Should not trigger assert.
|
|
SET SESSION DEBUG= "+d,enable_stack_overrun_simulation";
|
|
ALTER TABLE t1 KEY_BLOCK_SIZE=8;
|
|
Got one of the listed errors
|
|
# Cleanup
|
|
SET SESSION DEBUG= "-d,enable_stack_overrun_simulation";
|
|
DROP TABLE t1;
|
|
DROP VIEW v1;
|
|
|