diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-03-26 11:37:18 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-03-26 11:37:18 +0400 |
| commit | 6fbbb0853e7e58621f73f0afc600cd95995413ed (patch) | |
| tree | 5206eecee6f4a398db8a24f7273c08f7d1e7afaa /mysql-test/r | |
| parent | ed643f4bb31d8e5a9c0bc161583b8c9b2a08c26b (diff) | |
| download | mariadb-git-6fbbb0853e7e58621f73f0afc600cd95995413ed.tar.gz | |
MDEV-18968 Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_group.result | 8 | ||||
| -rw-r--r-- | mysql-test/r/type_decimal.result | 20 |
2 files changed, 24 insertions, 4 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index e0e870d1573..b9875faacb6 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -1979,8 +1979,8 @@ FROM t2); MIN(t2.pk) NULL Warnings: -Warning 1292 Truncated incorrect INTEGER value: 'j' -Warning 1292 Truncated incorrect INTEGER value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' EXPLAIN SELECT MIN(t2.pk) @@ -1993,8 +1993,8 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE 2 MATERIALIZED t2 ALL NULL NULL NULL NULL 2 Warnings: -Warning 1292 Truncated incorrect INTEGER value: 'j' -Warning 1292 Truncated incorrect INTEGER value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' # # 2) Test that subquery materialization is setup for query with diff --git a/mysql-test/r/type_decimal.result b/mysql-test/r/type_decimal.result index e515326e851..c9adf6a4f88 100644 --- a/mysql-test/r/type_decimal.result +++ b/mysql-test/r/type_decimal.result @@ -1019,3 +1019,23 @@ cast('-0.0' as decimal(5,1)) < 0 # # End of 5.5 tests # +# +# Start of 10.1 tests +# +# +# MDEV-18968 Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set +# +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (10); +SELECT CASE WHEN 0.1 THEN 'TRUE' ELSE 'FALSE' END FROM t1; +CASE WHEN 0.1 THEN 'TRUE' ELSE 'FALSE' END +TRUE +SELECT * FROM t1 WHERE 0.1; +a +10 +SELECT * FROM t1 WHERE NOT 0.1; +a +DROP TABLE t1; +# +# End of 10.1 tests +# |