outfile.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:2k
- disable_query_log;
- -- source include/test_outfile.inc
- eval set @tmpdir="$MYSQL_TEST_DIR/var/tmp";
- enable_query_log;
- -- source include/have_outfile.inc
- #
- # test of into outfile|dumpfile
- #
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- create table t1 (`a` blob);
- insert into t1 values("hello world"),("Hello mars"),(NULL);
- disable_query_log;
- eval select * into outfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.1" from t1;
- enable_query_log;
- select load_file(concat(@tmpdir,"/outfile-test.1"));
- disable_query_log;
- eval select * into dumpfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.2" from t1 limit 1;
- enable_query_log;
- select load_file(concat(@tmpdir,"/outfile-test.2"));
- disable_query_log;
- eval select * into dumpfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.3" from t1 where a is null;
- enable_query_log;
- select load_file(concat(@tmpdir,"/outfile-test.3"));
- # the following should give errors
- #disabled as error message has variable path
- #disable_query_log;
- #--error 1086
- #eval select * into outfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.1" from t1;
- #--error 1086
- #eval select * into dumpfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.2" from t1;
- #--error 1086
- #eval select * into dumpfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.3" from t1;
- #enable_query_log;
- --error 13,2
- select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
- --exec rm $MYSQL_TEST_DIR/var/tmp/outfile-test.1
- --exec rm $MYSQL_TEST_DIR/var/tmp/outfile-test.2
- --exec rm $MYSQL_TEST_DIR/var/tmp/outfile-test.3
- drop table t1;
- # Bug#8191
- disable_query_log;
- eval select 1 into outfile "$MYSQL_TEST_DIR/var/tmp/outfile-test.4";
- enable_query_log;
- select load_file(concat(@tmpdir,"/outfile-test.4"));
- --exec rm $MYSQL_TEST_DIR/var/tmp/outfile-test.4
- #
- # 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 'rn'
- FROM t1;
- DROP TABLE t1;
- # End of 4.1 tests