summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_test.result
diff options
context:
space:
mode:
authorunknown <ram@gw.mysql.r18.ru>2004-02-16 19:43:43 +0400
committerunknown <ram@gw.mysql.r18.ru>2004-02-16 19:43:43 +0400
commit6c2de2409a57299d0145f47ac47565b531a06acd (patch)
tree46a736219504febcba841b7caab314d49f44d97b /mysql-test/r/func_test.result
parent653112051422ab0191f728b0b33f4858e52d2d2c (diff)
downloadmariadb-git-6c2de2409a57299d0145f47ac47565b531a06acd.tar.gz
fix for the bug #2786 incorrect precedence for XOR operator
Diffstat (limited to 'mysql-test/r/func_test.result')
-rw-r--r--mysql-test/r/func_test.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result
index e11eaa0d246..aaf5039eb43 100644
--- a/mysql-test/r/func_test.result
+++ b/mysql-test/r/func_test.result
@@ -46,6 +46,9 @@ 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;
1 XOR 1 1 XOR 0 0 XOR 1 0 XOR 0 NULL XOR 1 1 XOR NULL 0 XOR NULL
0 1 1 0 NULL NULL NULL
+select 1 like 2 xor 2 like 1;
+1 like 2 xor 2 like 1
+0
create table t1 (a int);
insert t1 values (1);
select * from t1 where 1 xor 1;