~kalebral-deactivatedaccount/drizzle/change-error_num_to_enum-2

« back to all changes in this revision

Viewing changes to plugin/pbxt/tests/t/basic_transaction_autocommit.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:
 
1
connect (con1,localhost,root,,);
 
2
connect (con2,localhost,root,,);
 
3
connection con1;
 
4
CREATE TABLE t1 (a int primary key);
 
5
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);
 
6
connection con2;
 
7
select count(*) from t1;
 
8
connection con1;
 
9
INSERT INTO t1 VALUES  (33),(34),(35),(36),(37),(38),(39),(40),(41),(42);
 
10
COMMIT;
 
11
SELECT count(*) from t1;
 
12
disconnect con1;
 
13
disconnect con2;
 
14
connection default;
 
15
DROP TABLE t1;
 
16