~drizzle-trunk/drizzle/development

Viewing changes to tests/t/bool.test

Fixed bool. No more sql_mode.

added added

removed removed

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

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

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

set sql_mode='high_not_precedence';

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

set sql_mode=default;

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

# SQL boolean tests

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

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