summaryrefslogtreecommitdiff
path: root/mysql-test/t/row.test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-01-06 01:48:59 +0200
committermonty@mashka.mysql.fi <>2003-01-06 01:48:59 +0200
commit1f6ecc0cd3d9acf4751ebbbf8db8b6ee468d3abf (patch)
tree5fe133480d7e74a88990405ae324694fb8797fa5 /mysql-test/t/row.test
parentf9772317eefe95fe8152d69593082b2864164e16 (diff)
downloadmariadb-git-1f6ecc0cd3d9acf4751ebbbf8db8b6ee468d3abf.tar.gz
Changed mysql-test to print warnings for not existing table to DROP TABLE
Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names. changed store_warning() -> push_warning_print()
Diffstat (limited to 'mysql-test/t/row.test')
-rw-r--r--mysql-test/t/row.test9
1 files changed, 7 insertions, 2 deletions
diff --git a/mysql-test/t/row.test b/mysql-test/t/row.test
index 593e2342856..099eaa95c77 100644
--- a/mysql-test/t/row.test
+++ b/mysql-test/t/row.test
@@ -1,3 +1,8 @@
+# Initialise
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
+
select row(1,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3));
select row(10,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3));
select row(1,2,3) IN (row(3,NULL,3), row(1,2,3), row(1,3,3));
@@ -33,7 +38,7 @@ SELECT ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,3));
SELECT ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,NULL));
-- error 1239
SELECT ROW('test',2,ROW(3,33))=ROW('test',2,4);
-drop table if exists t1;
+
create table t1 ( a int, b int, c int);
insert into t1 values (1,2,3), (2,3,1), (3,2,1), (1,2,NULL);
select * from t1 where ROW(1,2,3)=ROW(a,b,c);
@@ -47,7 +52,7 @@ drop table t1;
-- error 1239
select ROW(1,1);
-drop table if exists t1;
+
create table t1 (i int);
-- error 1239
select 1 from t1 where ROW(1,1);