diff options
| author | unknown <monty@mysql.com> | 2004-02-03 09:46:48 +0100 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2004-02-03 09:46:48 +0100 |
| commit | 619eaee654d213c68f86981bf33dcccf15b52f02 (patch) | |
| tree | 4e99682a8907f92bf23d26f574c2c1d6a1152c1d /mysql-test/t/lock.test | |
| parent | 8ab97bb111b75a66cfee409123a34da2647bcf99 (diff) | |
| download | mariadb-git-619eaee654d213c68f86981bf33dcccf15b52f02.tar.gz | |
Give error if locked table is used twice in query. This fixes strange error message when doing LOCK TABLES t1 WRITE; INSERT TABLE t1 SELECT * from t1 (Bug #2296)
client/mysqldump.c:
Better help for flush-logs
mysql-test/r/lock.result:
Test for LOCK TABLES ; INSERT ... SELECT
mysql-test/t/lock.test:
Test for LOCK TABLES ; INSERT ... SELECT
Diffstat (limited to 'mysql-test/t/lock.test')
| -rw-r--r-- | mysql-test/t/lock.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/lock.test b/mysql-test/t/lock.test index 385713174d2..9015ce12fde 100644 --- a/mysql-test/t/lock.test +++ b/mysql-test/t/lock.test @@ -51,5 +51,9 @@ check table t1; # Check error message lock tables t1 write; check table t2; +--error 1100 +insert into t1 select nr from t1; unlock tables; +lock tables t1 write, t1 as t1_alias read; +insert into t1 select index1,nr from t1 as t1_alias; drop table t1,t2; |