diff options
author | Alexander Barkov <bar@mariadb.org> | 2015-06-02 15:42:01 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2015-06-02 15:42:01 +0400 |
commit | 3709c7fc6d46c624c24523907eb2a0ad8a1e5062 (patch) | |
tree | 5a1d1d5c445e6d952be1633584a723696e94061e /mysql-test/t/func_like.test | |
parent | 8f92a70e214837f092b9e0c06b645654377f03d6 (diff) | |
download | mariadb-git-3709c7fc6d46c624c24523907eb2a0ad8a1e5062.tar.gz |
MDEV-8222 "string_field LIKE int_const" returns a wrong result in case of UCS2
MDEV-8257 Erroneous "Impossible where" when mixing decimal comparison and LIKE
Diffstat (limited to 'mysql-test/t/func_like.test')
-rw-r--r-- | mysql-test/t/func_like.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test index bc64504c742..aab3c7fe43b 100644 --- a/mysql-test/t/func_like.test +++ b/mysql-test/t/func_like.test @@ -143,3 +143,26 @@ SELECT '' LIKE '1' ESCAPE COUNT(1); --echo # SELECT 'a' LIKE REPEAT('',0); SELECT 'a' LIKE EXTRACTVALUE('bar','qux'); + +--echo # +--echo # End of 10.0 tests +--echo # + +--echo # +--echo # Start of 10.1 tests +--echo # + +--echo # +--echo # MDEV-8257 Erroneous "Impossible where" when mixing decimal comparison and LIKE +--echo # +CREATE TABLE t1 (a DECIMAL(8,2)); +INSERT INTO t1 VALUES (10),(20); +SELECT * FROM t1 WHERE a=10.0; +SELECT * FROM t1 WHERE a LIKE 10.00; +SELECT * FROM t1 WHERE a=10.0 AND a LIKE 10.00; +EXPLAIN EXTENDED SELECT * FROM t1 WHERE a=10.0 AND a LIKE 10.00; +DROP TABLE t1; + +--echo # +--echo # End of 10.1 tests +--echo # |