diff options
Diffstat (limited to 'mysql-test/t/err000001.test')
| -rw-r--r-- | mysql-test/t/err000001.test | 21 |
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; |