~drizzle-trunk/drizzle/development

drop table if exists t1;

insert into t1 values(1);

ERROR 42S02: Unknown table 'test.t1'

delete from t1;

ERROR 42S02: Unknown table 'test.t1'

update t1 set a=1;

ERROR 42S02: Unknown table 'test.t1'

create table t1 (a int);

select count(test.t1.b) from t1;

ERROR 42S22: Unknown column 'test.t1.b' in 'field list'

select count(not_existing_database.t1) from t1;

ERROR 42S22: Unknown column 'not_existing_database.t1' in 'field list'

select count(not_existing_database.t1.a) from t1;

ERROR 42S22: Unknown column 'not_existing_database.t1.a' in 'field list'

select count(not_existing_database.t1.a) from not_existing_database.t1;

Got one of the listed errors

select 1 from t1 order by 2;

ERROR 42S22: Unknown column '2' in 'order clause'

select 1 from t1 group by 2;

ERROR 42S22: Unknown column '2' in 'group statement'

select 1 from t1 order by t1.b;

ERROR 42S22: Unknown column 't1.b' in 'order clause'

select count(*),b from t1;

ERROR 42S22: Unknown column 'b' in 'field list'

drop table t1;

create table t1 (a varchar(66000));

ERROR 42000: Column length too big for column 'a' (max = 16383); use BLOB or TEXT instead

CREATE TABLE t1 (a INT);

SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));

ERROR 22012: Division by 0

INSERT INTO t1 VALUES(1);

SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));

ERROR 22012: Division by 0

INSERT INTO t1 VALUES(2),(3);

SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));

ERROR 22012: Division by 0

DROP TABLE t1;

CREATE TABLE t1( a INT );

SELECT b FROM t1;

ERROR 42S22: Unknown column 'b' in 'field list'

SHOW ERRORS;

Level	Code	Message

Error	1054	Unknown column 'b' in 'field list'

CREATE TABLE t2 SELECT b FROM t1;

ERROR 42S22: Unknown column 'b' in 'field list'

SHOW ERRORS;

Level	Code	Message

Error	1054	Unknown column 'b' in 'field list'

INSERT INTO t1 SELECT b FROM t1;

ERROR 42S22: Unknown column 'b' in 'field list'

DROP TABLE t1;