diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-26 17:43:59 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-26 17:43:59 +0200 |
| commit | 0bc42602266815b81fe86b08c2228912c1a95340 (patch) | |
| tree | 7379577fac279387ec64d9ec0d752db11b0e425c /mysql-test/main/type_decimal.result | |
| parent | 7225bef7275da77faab316b863da0f4f5bf24a8f (diff) | |
| parent | 2d592f757cd624fe964ac39d05b6bdd985a827e2 (diff) | |
| download | mariadb-git-0bc42602266815b81fe86b08c2228912c1a95340.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/type_decimal.result')
| -rw-r--r-- | mysql-test/main/type_decimal.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/type_decimal.result b/mysql-test/main/type_decimal.result index 769c59b197d..6e7d7c8b6fe 100644 --- a/mysql-test/main/type_decimal.result +++ b/mysql-test/main/type_decimal.result @@ -1020,6 +1020,26 @@ 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 +# +# # Start of 10.2 tests # # |