main.loaddata w3 [ fail ]
|
Test ended at 2019-04-11 06:42:33
|
|
CURRENT_TEST: main.loaddata
|
|
|
mysqltest failed but provided no output
|
The result from queries just before the failure was:
|
< snip >
|
CREATE VIEW v2 AS SELECT * FROM v1;
|
LOAD DATA INFILE '../../std_data/loaddata7.dat' INTO TABLE v1
|
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';
|
ERROR HY000: Incorrect usage of Multi-table VIEW and LOAD
|
LOAD DATA INFILE '../../std_data/loaddata7.dat' INTO TABLE v2
|
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';
|
ERROR HY000: Incorrect usage of Multi-table VIEW and LOAD
|
DROP VIEW IF EXISTS v2,v1;
|
DROP TABLE IF EXISTS t1,t0;
|
CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a), UNIQUE(b));
|
INSERT INTO t1 VALUES (1,1);
|
CREATE TABLE t2 (c INT);
|
CREATE VIEW v AS SELECT t1.* FROM t1 JOIN t2;
|
SELECT a, b FROM t1 INTO OUTFILE '15645.data';
|
LOAD DATA INFILE '15645.data' IGNORE INTO TABLE v (a,b);
|
ERROR HY000: Incorrect usage of Multi-table VIEW and LOAD
|
LOAD DATA INFILE '15645.data' REPLACE INTO TABLE v (a,b);
|
ERROR HY000: Incorrect usage of Multi-table VIEW and LOAD
|
drop table t1,t2;
|
drop view v;
|