« back to all changes in this revision
Viewing changes to tests/t/insert_update.test
- Committer: Stewart Smith
- Date: 2009-05-15 06:57:12 UTC
- mto: (991.1.5 for-brian)
- mto: This revision was merged to the branch mainline in revision 1022.
- Revision ID: stewart@flamingspork.com-20090515065712-bmionylacjmexmmm
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);
as you've inserted the explicit value of 0 twice.
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);
as you've inserted the explicit value of 0 twice.
- files modified:
- drizzled/field.cc
added
removed
tests/t/insert_update.test
