~drizzle-trunk/drizzle/development

Merge from Monty.

added added

removed removed

create table t1 (a int not null, b int, primary key (a));

insert into t1 values (1,1);

create table if not exists t1 select 2;

ERROR HY000: Field 'a' doesn't have a default value

select * from t1;

a b

1 1

drop table t1;

create table t1 select 1,2,3;

create table if not exists t1 select 1,2;

ERROR HY000: Field '1' doesn't have a default value

create table if not exists t1 select 1;

ERROR HY000: Field '1' doesn't have a default value

select * from t1;

1 2 3

drop table t1;

create table t1 (a int not null primary key auto_increment, b int, c int, d int);

create table if not exists t1 select 1,2;

Warnings:

Note 1050 Table 't1' already exists

select * from t1;

a b c d

1 NULL 1 2

drop table t1;