diff options
| author | monty@tik.mysql.fi <> | 2001-07-16 03:04:30 +0300 |
|---|---|---|
| committer | monty@tik.mysql.fi <> | 2001-07-16 03:04:30 +0300 |
| commit | bf9876a195414ab8a5e2e1a56c5b041d807d926b (patch) | |
| tree | 12ce618a9c1f4bb3a79632d66e11232e84ab2e12 /mysql-test/t/limit.test | |
| parent | cc35643e1cbe0c4a1988b3eac1ee540726f639a3 (diff) | |
| download | mariadb-git-bf9876a195414ab8a5e2e1a56c5b041d807d926b.tar.gz | |
Patch for netBSD
Added warning for tables where the auto_increment key is 0
Fixed DELETE ... LIMIT 0
Fixed UPDATE ..LIMIT 0
Diffstat (limited to 'mysql-test/t/limit.test')
| -rw-r--r-- | mysql-test/t/limit.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/limit.test b/mysql-test/t/limit.test index ba075f73d37..112761abd87 100644 --- a/mysql-test/t/limit.test +++ b/mysql-test/t/limit.test @@ -17,3 +17,14 @@ select * from t1; delete from t1 limit 1; select * from t1; drop table t1; + +create table t1 (i int); +insert into t1 (i) values(1); +insert into t1 (i) values(1); +insert into t1 (i) values(1); +delete from t1 limit 1; +update t1 set i=2 limit 1; +delete from t1 limit 0; +update t1 set i=3 limit 0; +select * from t1; +drop table t1; |