diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-12-11 17:24:09 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-12-11 17:24:09 +0200 |
| commit | 35adb5cf7af2f90020db57e5f941ee1c32f5e808 (patch) | |
| tree | 1129e00806256cbb890b09d93180f8e9cf3437fa /mysql-test | |
| parent | ca2d22679e558c97e2aeff6b9f18900325ad27aa (diff) | |
| parent | 684c7aba09583e54c5272cc3b0eec207afc87a39 (diff) | |
| download | mariadb-git-35adb5cf7af2f90020db57e5f941ee1c32f5e808.tar.gz | |
merge
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/select.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/select.test | 9 |
2 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index fa030670d6e..c0526837ba9 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -4694,4 +4694,14 @@ HAVING v <= 't' ORDER BY pk; v DROP TABLE t1; +# +# Bug#49489 Uninitialized cache led to a wrong result. +# +CREATE TABLE t1(c1 DOUBLE(5,4)); +INSERT INTO t1 VALUES (9.1234); +SELECT * FROM t1 WHERE c1 < 9.12345; +c1 +9.1234 +DROP TABLE t1; +# End of test for bug#49489. End of 5.1 tests diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 116a09f5d00..61a694599ed 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4014,4 +4014,13 @@ ORDER BY pk; DROP TABLE t1; +--echo # +--echo # Bug#49489 Uninitialized cache led to a wrong result. +--echo # +CREATE TABLE t1(c1 DOUBLE(5,4)); +INSERT INTO t1 VALUES (9.1234); +SELECT * FROM t1 WHERE c1 < 9.12345; +DROP TABLE t1; +--echo # End of test for bug#49489. + --echo End of 5.1 tests |