summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_test.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/func_test.test')
-rw-r--r--mysql-test/main/func_test.test8
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/main/func_test.test b/mysql-test/main/func_test.test
index 570fd0ae87a..02b08d13dbe 100644
--- a/mysql-test/main/func_test.test
+++ b/mysql-test/main/func_test.test
@@ -6,7 +6,10 @@ drop table if exists t1,t2;
#
select 0=0,1>0,1>=1,1<0,1<=0,1!=0,strcmp("abc","abcd"),strcmp("b","a"),strcmp("a","a") ;
select "a"<"b","a"<="b","b">="a","b">"a","a"="A","a"<>"b";
-select "a "="A", "A "="a", "a " <= "A b";
+#enable after fix MDEV-28535
+--disable_view_protocol
+select "a "="A", "A "="a", "a " <= "A b";
+--enable_view_protocol
select "abc" like "a%", "abc" not like "%d%", "a%" like "a\%","abc%" like "a%\%","abcd" like "a%b_%d", "a" like "%%a","abcde" like "a%_e","abc" like "abc%";
select "a" like "%%b","a" like "%%ab","ab" like "a\%", "ab" like "_", "ab" like "ab_", "abc" like "%_d", "abc" like "abc%d";
select '?' like '|%', '?' like '|%' ESCAPE '|', '%' like '|%', '%' like '|%' ESCAPE '|', '%' like '%';
@@ -15,7 +18,10 @@ select "Det här är svenska" regexp "h[[:alpha:]]+r", "aba" regexp "^(a|b)*$";
select "aba" regexp concat("^","a");
select !0,NOT 0=1,!(0=0),1 AND 1,1 && 0,0 OR 1,1 || NULL, 1=1 or 1=1 and 1=0;
select 2 between 1 and 3, "monty" between "max" and "my",2=2 and "monty" between "max" and "my" and 3=3;
+#enable after fix MDEV-28535
+--disable_view_protocol
select 'b' between 'a' and 'c', 'B' between 'a' and 'c';
+--enable_view_protocol
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, 1 ^ 1, 1 ^ 0, 1 ^ NULL, NULL ^ 1;