← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/pbxt/tests/t/basic_transaction.test

  • Committer: Monty Taylor
  • Date: 2010-08-17 15:18:37 UTC
  • mfrom: (1711.1.20 build)
  • Revision ID: mordred@inaugust.com-20100817151837-xg0sc9n6tgjaf4mn
Rollup merge.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/pbxt/tests/t/basic_transaction.test
 
1
connect (con1,localhost,root,,);
 
2
connect (con2,localhost,root,,);
 
3
connection con1;
 
4
CREATE TABLE t1 (a int primary key);
 
5
connection con2;
 
6
START TRANSACTION WITH CONSISTENT SNAPSHOT;
 
7
SELECT count(*) from t1;
 
8
connection con1;
 
9
BEGIN;
 
10
INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10), (11),(12),(13),(14),(15),(16),(17),(18),(19),(20), (21),(22),(23),(24),(25),(26),(27),(28),(29),(30), (31),(32);
 
11
connection con2;
 
12
select count(*) from t1;
 
13
connection con1;
 
14
INSERT INTO t1 VALUES  (33),(34),(35),(36),(37),(38),(39),(40),(41),(42);
 
15
COMMIT;
 
16
SELECT count(*) from t1;
 
17
disconnect con1;
 
18
disconnect con2;
 
19
connection default;
 
20
DROP TABLE t1;