diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-12-16 21:37:10 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-12-16 21:37:10 +0300 |
| commit | 9e3caef632be77bc5aa2b47b3a7fe9d4b55ba4cc (patch) | |
| tree | a8b8a50c43781b76121b7d28f0daca1a51cbbdf4 /mysql-test/t/select.test | |
| parent | 5f0c09dd7220b7ad5709823788e9289fc94ab8fe (diff) | |
| parent | 7e15d855f1fbc72bae6c0ee75dd2b61477c2eaff (diff) | |
| download | mariadb-git-9e3caef632be77bc5aa2b47b3a7fe9d4b55ba4cc.tar.gz | |
Auto-merge from mysql-trunk-merge.
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index c2b42acbe4a..dad7405835b 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4061,4 +4061,18 @@ SELECT * FROM t1 WHERE c1 < 9.12345; DROP TABLE t1; --echo # End of test for bug#49489. + +--echo # +--echo # Bug #49517: Inconsistent behavior while using +--echo # NULLable BIGINT and INT columns in comparison +--echo # +CREATE TABLE t1(a BIGINT UNSIGNED NOT NULL, b BIGINT NULL, c INT NULL); +INSERT INTO t1 VALUES(105, NULL, NULL); +SELECT * FROM t1 WHERE b < 102; +SELECT * FROM t1 WHERE c < 102; +SELECT * FROM t1 WHERE 102 < b; +SELECT * FROM t1 WHERE 102 < c; +DROP TABLE t1; + + --echo End of 5.1 tests |