From 82952a24bc0cd57d49d5d68ec71a5f2d6f389e42 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 5 Aug 2003 16:29:09 +0200 Subject: make it clear for optimizer that XOR's are not optimizable at the moment (BUG#992) --- mysql-test/t/func_test.test | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'mysql-test/t/func_test.test') diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test index f5ad2e21c73..700fab97f5e 100644 --- a/mysql-test/t/func_test.test +++ b/mysql-test/t/func_test.test @@ -18,6 +18,11 @@ select -1.49 or -1.49,0.6 or 0.6; select 3 ^ 11, 1 ^ 1, 1 ^ 0, 1 ^ NULL, NULL ^ 1; select 1 XOR 1, 1 XOR 0, 0 XOR 1, 0 XOR 0, NULL XOR 1, 1 XOR NULL, 0 XOR NULL; +create table t1 (a int); +insert t1 values (1); +select * from t1 where 1 xor 1; +drop table t1; + # # Wrong usage of functions # -- cgit v1.2.1