69 lines
1.7 KiB
Plaintext
69 lines
1.7 KiB
Plaintext
--echo #
|
|
--echo # WL#9451 -- Backup Log
|
|
--echo #
|
|
--source include/master-slave.inc
|
|
|
|
CREATE TABLE t1 (a INT);
|
|
|
|
--enable_connect_log
|
|
|
|
CREATE USER 'testuser1'@'localhost';
|
|
GRANT all ON *.* TO 'testuser1'@'localhost';
|
|
|
|
--connect (con1, localhost, testuser1,,)
|
|
SET lock_wait_timeout= 1;
|
|
SET autocommit= 0;
|
|
|
|
--connection default
|
|
LOCK INSTANCE FOR BACKUP;
|
|
|
|
--connection con1
|
|
--error ER_LOCK_WAIT_TIMEOUT
|
|
CREATE DATABASE testdb;
|
|
--error ER_LOCK_WAIT_TIMEOUT
|
|
CREATE TABLESPACE testtablespace ADD DATAFILE 'ts.ibd' ENGINE=InnoDB;
|
|
--error ER_LOCK_WAIT_TIMEOUT
|
|
CREATE TABLE testtable_1 (c1 int, c2 varchar(10));
|
|
CREATE TEMPORARY TABLE temptable_1 (tt1 int);
|
|
INSERT INTO temptable_1 SELECT * FROM t1;
|
|
SELECT * FROM temptable_1;
|
|
|
|
--connection default
|
|
UNLOCK INSTANCE;
|
|
|
|
--connection con1
|
|
CREATE DATABASE testdb;
|
|
CREATE TABLESPACE testtablespace ADD DATAFILE 'ts.ibd' ENGINE=InnoDB;
|
|
CREATE TABLE testtable_1 (c1 int, c2 varchar(10)) TABLESPACE testtablespace;
|
|
|
|
--connection default
|
|
LOCK INSTANCE FOR BACKUP;
|
|
|
|
--connection con1
|
|
INSERT INTO testtable_1 VALUES(1,'aaa'),(2,'bbbbbb'),(3,'cccccccc');
|
|
INSERT INTO testtable_1 VALUES(4,'ddd'),(5,'eeeee'),(3,'fffffff');
|
|
UPDATE testtable_1 SET c1=11, c2='yyy' WHERE c1=1;
|
|
DELETE FROM testtable_1 WHERE c2 LIKE "aa";
|
|
--error ER_LOCK_WAIT_TIMEOUT
|
|
ALTER DATABASE testdb CHARACTER SET 'latin1';
|
|
--error ER_LOCK_WAIT_TIMEOUT
|
|
ALTER TABLE testtable_1 ADD INDEX i2(c2);
|
|
--error ER_LOCK_WAIT_TIMEOUT
|
|
|
|
--connection default
|
|
UNLOCK INSTANCE;
|
|
|
|
--connection con1
|
|
DROP DATABASE testdb;
|
|
DROP TABLE testtable_1;
|
|
DROP TABLESPACE testtablespace;
|
|
|
|
--connection default
|
|
--disconnect con1
|
|
|
|
DROP USER 'testuser1'@'localhost';
|
|
DROP TABLE t1;
|
|
--disable_connect_log
|
|
--source include/rpl_end.inc
|
|
|