← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/insert.test

  • Committer: Monty Taylor
  • Date: 2008-07-22 05:48:51 UTC
  • mto: (202.1.3 toru)
  • mto: This revision was merged to the branch mainline in revision 204.
  • Revision ID: monty@inaugust.com-20080722054851-airxt73370725p7x
Re-enabled optimizations for the normal build, and added back the --with-debug option to turn them off. 

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/insert.test
90
90
create table t2(id2 int not null, t char(12));
91
91
create table t3(id3 int not null, t char(12), index(id3));
92
92
disable_query_log;
93
 
set autocommit=0;
94
 
begin;
95
93
let $1 = 100;
96
94
while ($1)
97
95
 {
169
167
insert ignore into t1 values(NULL,100),(NULL,110),(NULL,120);
170
168
insert ignore into t1 values(NULL,10),(NULL,20),(NULL,110),(NULL,120),(NULL,100),(NULL,90);
171
169
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
170
select * from t1 order by id;
176
171
 
177
172
drop table t1;