5
5
CREATE TABLE t1 (i1 int, i2 int, c1 VARCHAR(256), c2 VARCHAR(256));
6
6
INSERT INTO t1 VALUES (101, 202, '-r-', '=raker=');
7
7
# FIELDS TERMINATED BY 'raker', error:
8
SELECT * INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' FIELDS TERMINATED BY 'raker' FROM t1;
8
SELECT * INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' FIELDS TERMINATED BY 'raker' FROM t1;
9
9
ERROR HY000: First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
10
10
# Only numeric fields, FIELDS TERMINATED BY 'r', no warnings:
11
SELECT i1, i2 INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' FIELDS TERMINATED BY 'r' FROM t1;
12
SELECT LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug31663.txt');
13
LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug31663.txt')
11
SELECT i1, i2 INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' FIELDS TERMINATED BY 'r' FROM t1;
12
SELECT LOAD_FILE('DRIZZLETEST_VARDIR/tmp/bug31663.txt');
13
LOAD_FILE('DRIZZLETEST_VARDIR/tmp/bug31663.txt')
16
16
CREATE TABLE t2 SELECT i1, i2 FROM t1;
17
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' INTO TABLE t2 FIELDS TERMINATED BY 'r';
17
LOAD DATA INFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' INTO TABLE t2 FIELDS TERMINATED BY 'r';
18
18
SELECT i1, i2 FROM t2;
23
23
# FIELDS TERMINATED BY '0', warning:
24
SELECT * INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' FIELDS TERMINATED BY '0' FROM t1;
24
SELECT * INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' FIELDS TERMINATED BY '0' FROM t1;
25
25
ERROR HY000: First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
26
26
# FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0', warning:
27
SELECT * INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0' FROM t1;
27
SELECT * INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0' FROM t1;
28
28
ERROR HY000: First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
29
29
CREATE TABLE t2 SELECT * FROM t1;
30
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' INTO TABLE t2 FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0';
31
ERROR HY000: Can't find file: 'MYSQLTEST_VARDIR/tmp/bug31663.txt' (errno: 2)
30
LOAD DATA INFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' INTO TABLE t2 FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0';
31
ERROR HY000: Can't find file: 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' (errno: 2)
33
33
# Only string fields, FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0', no warnings:
34
SELECT c1, c2 INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0' FROM t1;
35
SELECT LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug31663.txt');
36
LOAD_FILE('MYSQLTEST_VARDIR/tmp/bug31663.txt')
34
SELECT c1, c2 INTO OUTFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0' FROM t1;
35
SELECT LOAD_FILE('DRIZZLETEST_VARDIR/tmp/bug31663.txt');
36
LOAD_FILE('DRIZZLETEST_VARDIR/tmp/bug31663.txt')
39
39
CREATE TABLE t2 SELECT c1, c2 FROM t1;
40
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/bug31663.txt' INTO TABLE t2 FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0';
40
LOAD DATA INFILE 'DRIZZLETEST_VARDIR/tmp/bug31663.txt' INTO TABLE t2 FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '0';
41
41
SELECT c1, c2 FROM t2;
added
removed
tests/r/outfile_loaddata.result
