summaryrefslogtreecommitdiff
path: root/mysql-test/t/lock.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2004-02-11 00:06:46 +0100
committermonty@mysql.com <>2004-02-11 00:06:46 +0100
commitce145789092b294a562f565671478ae2bf51d14a (patch)
tree927515d304bd661aebdb0e534418caf49d322ada /mysql-test/t/lock.test
parent0c6a0b9a3118948efeedefd036d2994982babd08 (diff)
parentefb134f3a874befe4ab1779f597ada09f57ca191 (diff)
downloadmariadb-git-ce145789092b294a562f565671478ae2bf51d14a.tar.gz
Merge with 4.0.18
Diffstat (limited to 'mysql-test/t/lock.test')
-rw-r--r--mysql-test/t/lock.test4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/lock.test b/mysql-test/t/lock.test
index 69c453bf60a..26fc4e32bda 100644
--- a/mysql-test/t/lock.test
+++ b/mysql-test/t/lock.test
@@ -53,5 +53,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;