diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-12-16 21:35:25 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-12-16 21:35:25 +0300 |
| commit | 7e15d855f1fbc72bae6c0ee75dd2b61477c2eaff (patch) | |
| tree | 6cc5a2304ff1d8e8e5da08709d43daa27a50e91f /mysql-test/r/select.result | |
| parent | f1e83a4163458f7e25c709403cc7c7b48a7ef23e (diff) | |
| parent | c5e6a11e149600b3c454043706170fad4e7c6ce4 (diff) | |
| download | mariadb-git-7e15d855f1fbc72bae6c0ee75dd2b61477c2eaff.tar.gz | |
Manual merge from mysql-5.1.
Conflicts:
- mysql-test/r/select.result
- mysql-test/t/select.test
- sql/item_cmpfunc.h
- sql/sql_show.cc
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index a126ca26257..695d45deba9 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -4704,4 +4704,19 @@ c1 9.1234 DROP TABLE t1; # End of test for bug#49489. +# +# Bug #49517: Inconsistent behavior while using +# NULLable BIGINT and INT columns in comparison +# +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; +a b c +SELECT * FROM t1 WHERE c < 102; +a b c +SELECT * FROM t1 WHERE 102 < b; +a b c +SELECT * FROM t1 WHERE 102 < c; +a b c +DROP TABLE t1; End of 5.1 tests |