diff options
| author | unknown <gkodinov/kgeorge@macbook.gmz> | 2006-11-07 18:44:37 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.gmz> | 2006-11-07 18:44:37 +0200 |
| commit | 5ad3ed8c190fbd36043bc9b5299439dca66dc764 (patch) | |
| tree | 1d89504499c7786fd26b7b8f0881bc789d9996ed /mysql-test/t/subselect.test | |
| parent | c0487fb97057727c9587cc05150df64f118c2d31 (diff) | |
| parent | 5af4fd256321748a5ac7c8d4407f8ce977345e04 (diff) | |
| download | mariadb-git-5ad3ed8c190fbd36043bc9b5299439dca66dc764.tar.gz | |
Merge macbook.gmz:/Users/kgeorge/mysql/work/B11032-4.1-opt
into macbook.gmz:/Users/kgeorge/mysql/work/B11032-5.0-opt
mysql-test/r/subselect.result:
merge fixes
mysql-test/t/subselect.test:
merge fixes
sql/item_subselect.cc:
merge fixes
sql/item_subselect.h:
merge fixes
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 051a64b9f9a..75c1c0c0ffe 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1972,6 +1972,22 @@ SELECT a, a IN (SELECT a FROM t1) FROM t2; DROP TABLE t1,t2; +# +# Bug #11302: getObject() returns a String for a sub-query of type datetime +# +CREATE TABLE t1 (a DATETIME); +INSERT INTO t1 VALUES ('1998-09-23'), ('2003-03-25'); + +CREATE TABLE t2 AS SELECT + (SELECT a FROM t1 WHERE a < '2000-01-01') AS sub_a + FROM t1 WHERE a > '2000-01-01'; +SHOW CREATE TABLE t2; + +CREATE TABLE t3 AS (SELECT a FROM t1 WHERE a < '2000-01-01') UNION (SELECT a FROM t1 WHERE a > '2000-01-01'); +SHOW CREATE TABLE t3; + +DROP TABLE t1,t2,t3; + # End of 4.1 tests # |