← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/limit.test

  • Committer: Brian Aker
  • Date: 2008-10-11 18:46:03 UTC
  • mfrom: (499.1.1 codestyle)
  • Revision ID: brian@tangent.org-20081011184603-acnvl454409fzhvq
Merging Monty

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/limit.test
12
12
update t1 set a=4 where b=1 limit 1;
13
13
select * from t1;
14
14
update t1 set b=2 where b=1 limit 2;
 
15
--sorted_result
15
16
select * from t1;
16
17
update t1 set b=4 where b=1;
 
18
--sorted_result
17
19
select * from t1;
18
20
delete from t1 where b=2 limit 1;
 
21
--sorted_result
19
22
select * from t1;
20
23
delete from t1 limit 1;
 
24
--sorted_result
21
25
select * from t1;
22
26
drop table t1;
23
27
 
27
31
update t1 set i=2 limit 1;
28
32
delete from t1 limit 0;
29
33
update t1 set i=3 limit 0;
 
34
--sorted_result
30
35
select * from t1;
31
36
drop table t1;
32
37