diff options
Diffstat (limited to 'mysql-test/suite/versioning/r/foreign.result')
-rw-r--r-- | mysql-test/suite/versioning/r/foreign.result | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/mysql-test/suite/versioning/r/foreign.result b/mysql-test/suite/versioning/r/foreign.result index e6e2d710fcf..30e65de5316 100644 --- a/mysql-test/suite/versioning/r/foreign.result +++ b/mysql-test/suite/versioning/r/foreign.result @@ -266,6 +266,8 @@ on update cascade ) engine=innodb; insert into parent (value) values (23); select id, value from parent into @id, @value; +Warnings: +Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead insert into child values (default, @id, @value); insert into subchild values (default, @id, @value); select parent_id from subchild; @@ -347,7 +349,7 @@ key(f) INSERT INTO t2 VALUES (1,'against'),(2,'q'); SET SQL_MODE= ''; SET timestamp = 2; -SELECT * FROM t1 INTO OUTFILE 't1.data'; +SELECT * INTO OUTFILE 't1.data' FROM t1; SET timestamp = 3; UPDATE t1 SET f13 = 'q'; SET timestamp = 4; @@ -356,7 +358,7 @@ Warnings: Warning 1265 Data truncated for column 'f12' at row 2 Warning 1265 Data truncated for column 'f12' at row 4 Warning 1265 Data truncated for column 'f12' at row 7 -SELECT * FROM t1 INTO OUTFILE 't1.data.2' ; +SELECT * INTO OUTFILE 't1.data.2' FROM t1; SET timestamp = 5; LOAD DATA INFILE 't1.data.2' REPLACE INTO TABLE t1; Warnings: @@ -365,7 +367,7 @@ Warning 1265 Data truncated for column 'f12' at row 2 Warning 1265 Data truncated for column 'f12' at row 4 Warning 1265 Data truncated for column 'f12' at row 7 Warning 1265 Data truncated for column 'f1' at row 10 -SELECT * FROM t2 INTO OUTFILE 't2.data'; +SELECT * INTO OUTFILE 't2.data' FROM t2; SET timestamp = 6; LOAD DATA INFILE 't2.data' REPLACE INTO TABLE t2; SET FOREIGN_KEY_CHECKS = OFF; |