diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-01-19 14:10:05 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-01-19 14:10:05 +0400 |
| commit | a66924353a9fb4a1c1bfa05ad45aa3cabc34c3b6 (patch) | |
| tree | 07f70de0b3bdf2c8a4fcbc67e7bacae76a56328a | |
| parent | 2f7bf967fd5510822627b60fa79d4117d1439f7a (diff) | |
| download | mariadb-git-a66924353a9fb4a1c1bfa05ad45aa3cabc34c3b6.tar.gz | |
Test case for the bug #2198: SELECT INTO OUTFILE (with Sub-Select) Problem.
| -rw-r--r-- | mysql-test/r/subselect.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 12 |
2 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 672a39299dd..ded98265a1c 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -1569,3 +1569,12 @@ INSERT INTO t2 VALUES (100, 200, 'C'); SELECT DISTINCT COLC FROM t1 WHERE COLA = (SELECT COLA FROM t2 WHERE COLB = 200 AND COLC ='C' LIMIT 1); COLC DROP TABLE t1, t2; +create table t1 (a int, b decimal(13, 3)); +insert into t1 values (1, 0.123); +select a, (select max(b) from t1) into outfile "subselect.out.file.1" from t1; +delete from t1; +load data infile "subselect.out.file.1" into table t1; +select * from t1; +a b +1 0.123 +drop table t1; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 95e4f022f2d..37dbc8f24d9 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1009,3 +1009,15 @@ INSERT INTO t1 VALUES (1,1,'1A3240'), (1,2,'4W2365'); INSERT INTO t2 VALUES (100, 200, 'C'); SELECT DISTINCT COLC FROM t1 WHERE COLA = (SELECT COLA FROM t2 WHERE COLB = 200 AND COLC ='C' LIMIT 1); DROP TABLE t1, t2; + +# +# Bug 2198 +# + +create table t1 (a int, b decimal(13, 3)); +insert into t1 values (1, 0.123); +select a, (select max(b) from t1) into outfile "subselect.out.file.1" from t1; +delete from t1; +load data infile "subselect.out.file.1" into table t1; +select * from t1; +drop table t1; |