~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/limit.test

• browse files at revision 383.1.44
• compare with another revision
• download diff
• download tarball
• view history from revision 383.1.44

• reverse the comparison (383.1.44 to 575.1.8)
• stop comparing with revision 575.1.8

Show diffs side-by-side

added

removed

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

16

15

select * from t1;

17

16

update t1 set b=4 where b=1;

18

 

--sorted_result

19

17

select * from t1;

20

18

delete from t1 where b=2 limit 1;

21

 

--sorted_result

22

19

select * from t1;

23

20

delete from t1 limit 1;

24

 

--sorted_result

25

21

select * from t1;

26

22

drop table t1;

27

23

 

31

27

update t1 set i=2 limit 1;

32

28

delete from t1 limit 0;

33

29

update t1 set i=3 limit 0;

34

 

--sorted_result

35

30

select * from t1;

36

31

drop table t1;

37

32

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1