diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/main/check.result | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz |
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/main/check.result')
-rw-r--r-- | mysql-test/main/check.result | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/mysql-test/main/check.result b/mysql-test/main/check.result new file mode 100644 index 00000000000..341c4411298 --- /dev/null +++ b/mysql-test/main/check.result @@ -0,0 +1,54 @@ +connect con1,localhost,root,,; +connect con2,localhost,root,,; +connection con1; +drop table if exists t1,t2; +drop view if exists v1; +create table t1(n int not null, key(n), key(n), key(n), key(n)); +Warnings: +Note 1831 Duplicate index `n_2`. This is deprecated and will be disallowed in a future release +Note 1831 Duplicate index `n_3`. This is deprecated and will be disallowed in a future release +Note 1831 Duplicate index `n_4`. This is deprecated and will be disallowed in a future release +check table t1 extended; +connection con2; +insert into t1 values (200000); +connection con1; +Table Op Msg_type Msg_text +test.t1 check status OK +connection default; +disconnect con1; +disconnect con2; +drop table t1; +Create table t1(f1 int); +Create table t2(f1 int); +Create view v1 as Select * from t1; +Check Table v1,t2; +Table Op Msg_type Msg_text +test.v1 check status OK +test.t2 check status OK +drop view v1; +drop table t1, t2; +CREATE TEMPORARY TABLE t1(a INT); +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check status OK +REPAIR TABLE t1; +Table Op Msg_type Msg_text +test.t1 repair status OK +DROP TABLE t1; +# +# Bug#56422 CHECK TABLE run when the table is locked reports corruption +# along with timeout +# +DROP TABLE IF EXISTS t1; +CREATE TABLE t1(a INT); +LOCK TABLE t1 WRITE; +connect con1, localhost, root; +SET lock_wait_timeout= 1; +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check Error Lock wait timeout exceeded; try restarting transaction +test.t1 check status Operation failed +connection default; +UNLOCK TABLES; +DROP TABLE t1; +disconnect con1; |