diff options
Diffstat (limited to 'mysql-test/r/limit.result')
| -rw-r--r-- | mysql-test/r/limit.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/limit.result b/mysql-test/r/limit.result index 6c3a1ed17e4..f341eebb968 100644 --- a/mysql-test/r/limit.result +++ b/mysql-test/r/limit.result @@ -1,25 +1,50 @@ +drop table if exists t1; +create table t1 (a int primary key, b int not null); +insert into t1 () values (); +insert into t1 values (1,1),(2,1),(3,1); +update t1 set a=4 where b=1 limit 1; +select * from t1; a b 0 0 4 1 2 1 3 1 +update t1 set b=2 where b=1 limit 2; +select * from t1; a b 0 0 4 2 2 2 3 1 +update t1 set b=4 where b=1; +select * from t1; a b 0 0 4 2 2 2 3 4 +delete from t1 where b=2 limit 1; +select * from t1; a b 0 0 2 2 3 4 +delete from t1 limit 1; +select * from t1; a b 2 2 3 4 +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; i 2 1 +drop table t1; |