Make sql_mode=NO_AUTO_VALUE_ON_ZERO default for Drizzle.
Also fix DEFAULT keyword handling for auto-increment so that it defaults to NULL and not 0 so that the following is valid and generates two auto-inc values:
create table t1 (a int auto_increment primary key) insert into t1 (a) values (default); insert into t1 (a) values (default);
Important to note that 0 is no longer magic. So this gives you duplicate primary key error:
insert into t1 (a) values(0); insert into t1 (a) values(0);