summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2002-06-29 16:25:09 +0300
committerunknown <Sinisa@sinisa.nasamreza.org>2002-06-29 16:25:09 +0300
commitb936b25d79b1b98ecb9528048dc4bb431f1d9c58 (patch)
tree5267b84a9907913f772241f1b990102e711bf9f3 /mysql-test
parentd7a84c7af0e1eb166c48ce7a7c3e3dca83f43baf (diff)
downloadmariadb-git-b936b25d79b1b98ecb9528048dc4bb431f1d9c58.tar.gz
Added functions :
* binary XOR * logical XOR * CHECK_LOCK("lock_name")
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/func_test.result6
-rw-r--r--mysql-test/r/rpl_get_lock.result3
-rw-r--r--mysql-test/t/func_test.test3
-rw-r--r--mysql-test/t/rpl_get_lock.test1
4 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result
index deea5b8bb8b..7d0ef3cff89 100644
--- a/mysql-test/r/func_test.result
+++ b/mysql-test/r/func_test.result
@@ -40,6 +40,12 @@ select 2 in (3,2,5,9,5,1),"monty" in ("david","monty","allan"), 1.2 in (1.4,1.2,
select -1.49 or -1.49,0.6 or 0.6;
-1.49 or -1.49 0.6 or 0.6
1 1
+select 3 ^ 11;
+3 ^ 11
+8
+select 1 XOR 0;
+1 XOR 0
+1
select 5 between 0 and 10 between 0 and 1,(5 between 0 and 10) between 0 and 1;
5 between 0 and 10 between 0 and 1 (5 between 0 and 10) between 0 and 1
0 1
diff --git a/mysql-test/r/rpl_get_lock.result b/mysql-test/r/rpl_get_lock.result
index c86b8f830a5..6201a751961 100644
--- a/mysql-test/r/rpl_get_lock.result
+++ b/mysql-test/r/rpl_get_lock.result
@@ -17,4 +17,7 @@ get_lock("lock",3)
select * from t1;
n
1
+select check_lock("lock");
+check_lock("lock")
+1
drop table t1;
diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test
index ec44009b1a6..844db1a0214 100644
--- a/mysql-test/t/func_test.test
+++ b/mysql-test/t/func_test.test
@@ -15,7 +15,8 @@ select 2 between 1 and 3, "monty" between "max" and "my",2=2 and "monty" between
select 'b' between 'a' and 'c', 'B' between 'a' and 'c';
select 2 in (3,2,5,9,5,1),"monty" in ("david","monty","allan"), 1.2 in (1.4,1.2,1.0);
select -1.49 or -1.49,0.6 or 0.6;
-
+select 3 ^ 11;
+select 1 XOR 0;
#
# Wrong usage of functions
#
diff --git a/mysql-test/t/rpl_get_lock.test b/mysql-test/t/rpl_get_lock.test
index 3fe45eecf46..e197b9911bb 100644
--- a/mysql-test/t/rpl_get_lock.test
+++ b/mysql-test/t/rpl_get_lock.test
@@ -22,6 +22,7 @@ sync_with_master;
select get_lock("lock",3);
select * from t1;
connection master1;
+select check_lock("lock");
drop table t1;
save_master_pos;
connection slave;