~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/insert.test

  • Committer: Monty Taylor
  • Date: 2008-08-02 01:03:15 UTC
  • mto: (236.1.42 codestyle)
  • mto: This revision was merged to the branch mainline in revision 261.
  • Revision ID: monty@inaugust.com-20080802010315-65h5938pymg9d99z
Moved m4 macros to top-level m4 dir, per GNU standards (and where gettext wanted it :)

Show diffs side-by-side

added added

removed removed

Lines of Context:
169
169
insert ignore into t1 values(NULL,100),(NULL,110),(NULL,120);
170
170
insert ignore into t1 values(NULL,10),(NULL,20),(NULL,110),(NULL,120),(NULL,100),(NULL,90);
171
171
insert ignore into t1 values(NULL,130),(NULL,140),(500,110),(550,120),(450,100),(NULL,150);
172
 
# PBXT differs from InnoDB here. Main reason is that inserting
173
 
# 500 causes auto inc value to be set to 501, this is never
174
 
# undone because of possible concurrent inserts.
175
172
select * from t1 order by id;
176
173
 
177
174
drop table t1;