← Back to branch summary

~mordred/drizzle/drizzled-as-lib

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/tests/r/basic_transaction.result

  • Committer: Monty Taylor
  • Date: 2010-04-16 23:10:22 UTC
  • mfrom: (1471.1.4 bad-staging)
  • Revision ID: mordred@inaugust.com-20100416231022-xf1iiuuuw1kka2bb
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/embedded_innodb/tests/r/basic_transaction.result
1
 
CREATE TABLE t1 (a int);
 
1
CREATE TABLE t1 (a int primary key);
2
2
START TRANSACTION WITH CONSISTENT SNAPSHOT;
3
3
SELECT count(*) from t1;
4
4
count(*)
5
5
0
6
6
BEGIN;
7
 
INSERT INTO t1 VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1), (1),(1),(1),(1),(1),(1),(1),(1),(1),(1), (1),(1),(1),(1),(1),(1),(1),(1),(1),(1), (1),(1);
 
7
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);
8
8
select count(*) from t1;
9
9
count(*)
10
10
0
11
 
INSERT INTO t1 VALUES  (1),(1),(1),(1),(1),(1),(1),(1),(1),(1);
 
11
INSERT INTO t1 VALUES  (33),(34),(35),(36),(37),(38),(39),(40),(41),(42);
12
12
COMMIT;
13
13
SELECT count(*) from t1;
14
14
count(*)