From cb81894a354e098508965e444de8313150822295 Mon Sep 17 00:00:00 2001 From: unknown Date: Sun, 10 Oct 2004 14:40:24 +0500 Subject: A fix (bug #5382: Server crashes after writing INTO OUTFILE) --- mysql-test/t/outfile.test | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'mysql-test/t/outfile.test') diff --git a/mysql-test/t/outfile.test b/mysql-test/t/outfile.test index a7b81d565e6..28d5ebfaf99 100644 --- a/mysql-test/t/outfile.test +++ b/mysql-test/t/outfile.test @@ -2,6 +2,10 @@ # test of into outfile|dumpfile # +--disable_warnings +drop table if exists t1; +--enable_warnings + # We need to check that we have 'file' privilege. #drop table if exists t1; @@ -26,3 +30,15 @@ #INSERT INTO t VALUES ('2002-12-20 12:01:20','',1,"aaa","bbb"); #select * from t into outfile "check"; #drop table if exists t; + +# +# Bug #5382: 'explain select into outfile' crashes the server +# + +CREATE TABLE t1 (a INT); +EXPLAIN + SELECT * + INTO OUTFILE '/tmp/t1.txt' + FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' + FROM t1; +DROP TABLE t1; -- cgit v1.2.1 From 98bb6fd4babb76b2c539614d66d08ee4d83004dd Mon Sep 17 00:00:00 2001 From: unknown Date: Sun, 10 Oct 2004 15:29:06 +0500 Subject: clean-up, indentation fixes. mysql-test/t/outfile.test: this 'drop...' not needed anymore sql/sql_yacc.yy: indentation fixes --- mysql-test/t/outfile.test | 1 - 1 file changed, 1 deletion(-) (limited to 'mysql-test/t/outfile.test') diff --git a/mysql-test/t/outfile.test b/mysql-test/t/outfile.test index 28d5ebfaf99..59ce6cc56fe 100644 --- a/mysql-test/t/outfile.test +++ b/mysql-test/t/outfile.test @@ -8,7 +8,6 @@ drop table if exists t1; # We need to check that we have 'file' privilege. -#drop table if exists t1; #create table t1 (`a` blob); #insert into t1 values("hello world"),("Hello mars"),(NULL); #select * into outfile "/tmp/select-test.1" from t1; -- cgit v1.2.1