summaryrefslogtreecommitdiff
path: root/mysql-test/t/table_value_const.test
diff options
context:
space:
mode:
authorGalina Shalygina <galashalygina@gmail.com>2017-06-30 13:54:33 +0300
committerGalina Shalygina <galashalygina@gmail.com>2017-06-30 13:54:33 +0300
commit7ba19ba3848894120548f33c314ac59bcc627d1c (patch)
tree5df983525ebddbea5ba0245cd0de0a70a258a70d /mysql-test/t/table_value_const.test
parent615da8f70bd61aa0918c08a256638d90d425fe0e (diff)
downloadmariadb-git-7ba19ba3848894120548f33c314ac59bcc627d1c.tar.gz
Mistakes corrected, test file corrected.
Diffstat (limited to 'mysql-test/t/table_value_const.test')
-rw-r--r--mysql-test/t/table_value_const.test8
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/t/table_value_const.test b/mysql-test/t/table_value_const.test
index 6d338ab0353..00cd1baad95 100644
--- a/mysql-test/t/table_value_const.test
+++ b/mysql-test/t/table_value_const.test
@@ -1,9 +1,15 @@
+create table t1 (a int, b int);
+
+insert into t1 values (1,2),(4,6),(9,7),(1,1),(2,5),(7,8);
+
values (1,2);
select 1,2 union values (1,2);
values (1,2) union select (1,2);
+values (1,2), (3,4) union select 1,2;
+
select * from t1 where (t1.a,t1.b) in (select 5,7 union values (1,2),(2,3));
select * from t1 where (t1.a,t1.b) in (values (1,2),(2,3) union select 5,7);
@@ -26,5 +32,5 @@ create view v1 as select 1,2 union values (3,4),(5,6);
eval $drop_view;
-
+drop table t1;