← 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: 2011-03-09 20:59:40 UTC
  • mfrom: (2226.1.14 build)
  • Revision ID: mordred@inaugust.com-20110309205940-7f5mk6zba2u7bawa
Merged Dave - Filtered Replication docs
Merged Olaf - Refactoring work
Removed archive, blackhole, filesystem_engine, blitzdb, csv and pbxt from
the tree pre-GA as we have no interest in supporting them moving forward.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/pbxt/tests/t/basic_transaction.test
1
 
--source include/have_linux.inc
2
 
--source include/not_valgrind.inc
3
 
SET SESSION storage_engine=pbxt;
4
 
connect (con1,localhost,root,,);
5
 
connect (con2,localhost,root,,);
6
 
connection con1;
7
 
CREATE TABLE t1 (a int primary key);
8
 
connection con2;
9
 
START TRANSACTION WITH CONSISTENT SNAPSHOT;
10
 
SELECT count(*) from t1;
11
 
connection con1;
12
 
BEGIN;
13
 
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);
14
 
connection con2;
15
 
select count(*) from t1;
16
 
connection con1;
17
 
INSERT INTO t1 VALUES  (33),(34),(35),(36),(37),(38),(39),(40),(41),(42);
18
 
COMMIT;
19
 
SELECT count(*) from t1;
20
 
disconnect con1;
21
 
disconnect con2;
22
 
connection default;
23
 
DROP TABLE t1;