summaryrefslogtreecommitdiff
path: root/mysql-test/t/insert_select.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-02-29 21:55:04 +0100
committerSergei Golubchik <sergii@pisem.net>2012-02-29 21:55:04 +0100
commite4bfb6f161b77a8c5801ba71b4ffd980066a1399 (patch)
treea48bbc4154695db34ba124f07a70bef5cabab48d /mysql-test/t/insert_select.test
parente293bdb2c19cacad91d4f5a846568ac595b3a48e (diff)
downloadmariadb-git-e4bfb6f161b77a8c5801ba71b4ffd980066a1399.tar.gz
pbxt suite is now a main-pbxt overlay
Diffstat (limited to 'mysql-test/t/insert_select.test')
-rw-r--r--mysql-test/t/insert_select.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/insert_select.test b/mysql-test/t/insert_select.test
index 9aed425e0cb..bcd87c2688d 100644
--- a/mysql-test/t/insert_select.test
+++ b/mysql-test/t/insert_select.test
@@ -106,6 +106,7 @@ insert into t1 select * from t2;
select * from t1;
# REPLACE .. SELECT is not yet supported by PS
replace into t1 select * from t2;
+--sorted_result
select * from t1;
drop table t1,t2;
@@ -320,6 +321,7 @@ INSERT INTO t2 (f1, f2) SELECT f1, f2 FROM t1;
INSERT INTO t2 (f1, f2)
SELECT f1, f1 FROM t2 src WHERE f1 < 2
ON DUPLICATE KEY UPDATE f1 = 100 + src.f1;
+ --sorted_result
SELECT * FROM t2;
DROP TABLE t1, t2;