diff options
| author | monty@mysql.com <> | 2004-02-03 09:46:48 +0100 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-02-03 09:46:48 +0100 |
| commit | 268521a61df055896bda6a30bd56843ca51541a6 (patch) | |
| tree | 4e99682a8907f92bf23d26f574c2c1d6a1152c1d /mysql-test/r/lock.result | |
| parent | 31ad5e4903fc3fda8336f8d7b2bfd7f042576eae (diff) | |
| download | mariadb-git-268521a61df055896bda6a30bd56843ca51541a6.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)
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; |