mirror of
https://github.com/MariaDB/server.git
synced 2025-04-19 13:45:32 +02:00
782b2a7500
mysql_discard_or_import_tablespace(): On successful ALTER TABLE...DISCARD TABLESPACE, evict the table handle from the table definition cache, so that ha_innobase::close() will be invoked, like InnoDB expects to be the case. This will avoid an assertion failure ut_a(table->get_ref_count() == 0) during IMPORT TABLESPACE. ha_innobase::open(): Do not issue any ER_TABLESPACE_DISCARDED warning. Member functions for DML will do that. ha_innobase::truncate(), ha_innobase::check_if_supported_inplace_alter(): Issue ER_TABLESPACE_DISCARDED warnings, to compensate for the removal of the warning in ha_innobase::open(). row_quiesce_write_indexes(): Only write information about committed indexes. The ALTER TABLE t NOWAIT ADD INDEX(c) in the nondeterministic test case will most of the time fail due to a metadata lock (MDL) timeout and leave behind an uncommitted index. Reviewed by: Sergei Golubchik
26 lines
595 B
Text
26 lines
595 B
Text
#
|
|
# MDEV-29144 ER_TABLE_SCHEMA_MISMATCH or crash on DISCARD/IMPORT
|
|
#
|
|
CREATE TABLE t (pk int PRIMARY KEY, c varchar(1024))
|
|
ENGINE=InnoDB CHARSET latin1;
|
|
INSERT INTO t SELECT seq, 'x' FROM seq_1_to_100;
|
|
connect con1,localhost,root,,test;
|
|
BEGIN NOT ATOMIC
|
|
DECLARE a INT DEFAULT 0;
|
|
REPEAT
|
|
SET a= a+1;
|
|
UPDATE t SET c = 'xx' WHERE pk = a;
|
|
UNTIL a = 100
|
|
END REPEAT;
|
|
END
|
|
$
|
|
connection default;
|
|
ALTER TABLE t NOWAIT ADD INDEX (c);
|
|
connection con1;
|
|
connection default;
|
|
FLUSH TABLE t FOR EXPORT;
|
|
UNLOCK TABLES;
|
|
DROP TABLE t;
|
|
ALTER TABLE t DISCARD TABLESPACE;
|
|
ALTER TABLE t IMPORT TABLESPACE;
|
|
DROP TABLE t;
|