diff options
| author | Georgi Kodinov <joro@sun.com> | 2010-01-13 12:28:42 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2010-01-13 12:28:42 +0200 |
| commit | 6e72f4171fbc157885672ab45152564cdd3d1bfa (patch) | |
| tree | cbdb25a3a54a2e4391cb90fb8e08590f44d099c8 /mysql-test/r/select.result | |
| parent | 4dc7be62a997a0176e300878d4b5e93865606029 (diff) | |
| parent | 23a3b911409ee7c27937a663ed7a08e13c0adbed (diff) | |
| download | mariadb-git-6e72f4171fbc157885672ab45152564cdd3d1bfa.tar.gz | |
merge 5.1-main to 5.1-bugteam
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 c0526837ba9..dce927a5c8d 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 |