← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/insert.test

  • Committer: Lee Bieber
  • Date: 2011-01-21 05:20:24 UTC
  • mfrom: (2099.1.3 build)
  • Revision ID: kalebral@gmail.com-20110121052024-43pl0aj8j5fmqnvl
Merge Stewart - Fix bug 664222: DDL operations have an implicit commit
Merge Stewart - Fix bug #695201: autocommit=1 not resetting session->server_status properly when committing ongoing txn
Add BSD copyright file to win32/config.h
Merge Brian - cleanup user_locks.kill_wait test

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/insert.test
94
94
create table t2(id2 int not null, t char(12));
95
95
create table t3(id3 int not null, t char(12), index(id3));
96
96
disable_query_log;
97
 
set autocommit=0;
98
97
begin;
99
98
let $1 = 100;
100
99
while ($1)
120
119
insert into  t2 select t1.* from t1, t2 t, t3 where  t1.id1 = t.id2 and t.id2 = t3.id3;
121
120
insert into  t2 select SQL_BIG_RESULT t1.* from t1, t2 t, t3 where  t1.id1 = t.id2 and t.id2 = t3.id3;
122
121
select count(*) from t2;
 
122
COMMIT;
123
123
drop table t1,t2,t3;
124
124
 
125
125
#