~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/bool.test

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

Show diffs side-by-side

added

removed

tests/t/bool.test

20

20

SELECT * FROM t1 where (1 AND a)=1;

21

21

SELECT * FROM t1 where (1 AND a) IS NULL;

22

22

 

23

 

# WL#638 - Behaviour of NOT does not follow SQL specification

24

 

set sql_mode='high_not_precedence';

25

 

select * from t1 where not a between 2 and 3;

26

 

set sql_mode=default;

27

 

select * from t1 where not a between 2 and 3;

28

 

 

29

23

# SQL boolean tests

30

24

select a, a is false, a is true, a is unknown from t1;

31

25

select a, a is not false, a is not true, a is not unknown from t1;

• Older »

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