summaryrefslogtreecommitdiff
path: root/mysql-test/t/err000001.test
diff options
context:
space:
mode:
authormonty@donna.mysql.com <>2000-12-28 03:56:38 +0200
committermonty@donna.mysql.com <>2000-12-28 03:56:38 +0200
commitc0f40d14cc36f56f5b4dba288583acd345429e4e (patch)
treec27e400395741740f2e230395445236b38db27c1 /mysql-test/t/err000001.test
parent361067e9150f7fa57d5b2ac722ed55df9c14cc53 (diff)
downloadmariadb-git-c0f40d14cc36f56f5b4dba288583acd345429e4e.tar.gz
Added support for hex strings to mysqlimport
A lot of new tests to mysqltest Fixed bug with BDB tables and autocommit
Diffstat (limited to 'mysql-test/t/err000001.test')
-rw-r--r--mysql-test/t/err000001.test21
1 files changed, 18 insertions, 3 deletions
diff --git a/mysql-test/t/err000001.test b/mysql-test/t/err000001.test
index f264c0bb172..9957cefff9b 100644
--- a/mysql-test/t/err000001.test
+++ b/mysql-test/t/err000001.test
@@ -1,3 +1,18 @@
-use test;
-drop table if exists foo;
-!$1146 insert into foo values(1);
+#
+# Test some error conditions
+#
+
+drop table if exists t1;
+!$1146 insert into t1 values(1);
+!$1146 delete from t1;
+!$1146 update t1 set a=1;
+create table t1 (a int);
+!$1054 select count(test.t1.b) from t1;
+!$1109 select count(not_existing_database.t1) from t1;
+!$1109 select count(not_existing_database.t1.a) from t1;
+!$1044 select count(not_existing_database.t1.a) from not_existing_database.t1;
+!$1054 select 1 from t1 order by 2;
+!$1054 select 1 from t1 group by 2;
+!$1054 select 1 from t1 order by t1.b;
+!$1054 select count(*),b from t1;
+drop table t1;