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/r/lock.result | |
| 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/r/lock.result')
| -rw-r--r-- | mysql-test/r/lock.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/lock.result b/mysql-test/r/lock.result index ad5251b9110..31a18fe6cec 100644 --- a/mysql-test/r/lock.result +++ b/mysql-test/r/lock.result @@ -41,5 +41,9 @@ lock tables t1 write; check table t2; Table Op Msg_type Msg_text test.t2 check error Table 't2' was not locked with LOCK TABLES +insert into t1 select nr from t1; +Table 't1' was not locked with LOCK TABLES 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; |