diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-10-28 10:01:50 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-10-28 10:01:50 +0200 |
| commit | a8de8f261d1b7621b8e16396e87dfaac14891162 (patch) | |
| tree | 9b8ec45858c2757305e0bdecf237fcb59251020c /mysql-test/main/func_test.result | |
| parent | e183aec1d75ea7b424ebe237e6b1643961903f2d (diff) | |
| parent | 42e1815ad850384fad292534665ff61b78dd96f6 (diff) | |
| download | mariadb-git-a8de8f261d1b7621b8e16396e87dfaac14891162.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/func_test.result')
| -rw-r--r-- | mysql-test/main/func_test.result | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/mysql-test/main/func_test.result b/mysql-test/main/func_test.result index 4243ed9cfb0..04aee8b5522 100644 --- a/mysql-test/main/func_test.result +++ b/mysql-test/main/func_test.result @@ -89,15 +89,6 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select -1 AS `- a` from dual drop table t1; -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 -select 1 and 2 between 2 and 10, 2 between 2 and 10 and 1; -1 and 2 between 2 and 10 2 between 2 and 10 and 1 -1 1 -select 1 and 0 or 2, 2 or 1 and 0; -1 and 0 or 2 2 or 1 and 0 -1 1 select _koi8r'a' = _koi8r'A'; _koi8r'a' = _koi8r'A' 1 @@ -273,16 +264,6 @@ NULL select mod(NULL, 2.0) as 'NULL'; NULL NULL -create table t1 (a int, b int); -insert into t1 values (1,2), (2,3), (3,4), (4,5); -select * from t1 where a not between 1 and 2; -a b -3 4 -4 5 -select * from t1 where a not between 1 and 2 and b not between 3 and 4; -a b -4 5 -drop table t1; SELECT GREATEST(1,NULL) FROM DUAL; GREATEST(1,NULL) NULL |