diff options
| author | Georgi Kodinov <kgeorge@mysql.com> | 2008-09-19 15:34:37 +0300 |
|---|---|---|
| committer | Georgi Kodinov <kgeorge@mysql.com> | 2008-09-19 15:34:37 +0300 |
| commit | 7be42c86192f93a81402d52f2dc8b70a37065609 (patch) | |
| tree | 89ec9cf56f750b025fd2f254ea1654d9ca25b54c /mysql-test/r/compare.result | |
| parent | 14ce62ffbbbb136f8d913a4dd7986be78749d55a (diff) | |
| parent | bf09a809a6590b4dce0acee2e890444a96fed8c3 (diff) | |
| download | mariadb-git-7be42c86192f93a81402d52f2dc8b70a37065609.tar.gz | |
merge of bug 39353 5.0-5.1.29-rc -> 5.1-5.1.29-rc
Diffstat (limited to 'mysql-test/r/compare.result')
| -rw-r--r-- | mysql-test/r/compare.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/compare.result b/mysql-test/r/compare.result index 44c258d7611..f9563b89b76 100644 --- a/mysql-test/r/compare.result +++ b/mysql-test/r/compare.result @@ -90,4 +90,9 @@ Note 1276 Field or reference 'test.t2.a' of SELECT #2 was resolved in SELECT #1 Note 1276 Field or reference 'test.t2.a' of SELECT #2 was resolved in SELECT #1 Note 1003 select `test`.`t2`.`a` AS `a`,(select count(0) AS `COUNT(*)` from `test`.`t1` where ((`test`.`t1`.`b` = `test`.`t2`.`a`) and (concat(`test`.`t1`.`b`,`test`.`t1`.`c`) = concat('0',`test`.`t2`.`a`,'01')))) AS `x` from `test`.`t2` order by `test`.`t2`.`a` DROP TABLE t1,t2; +CREATE TABLE t1 (a TIMESTAMP); +INSERT INTO t1 VALUES (NOW()),(NOW()),(NOW()); +SELECT * FROM t1 WHERE a > '2008-01-01' AND a = '0000-00-00'; +a +DROP TABLE t1; End of 5.0 tests |