← Back to branch summary

~drizzle-developers/ubuntu/natty/drizzle/natty

« back to all changes in this revision

Viewing changes to tests/r/transaction.result

  • Committer: Monty Taylor
  • Date: 2010-03-03 19:27:30 UTC
  • mto: (1308.1.2 trunk)
  • mto: This revision was merged to the branch mainline in revision 1278.
  • Revision ID: mordred@inaugust.com-20100303192730-o2o3nmp0lzhuatbe
Tags: upstream-2010.03.1317
Import upstream version 2010.03.1317

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/transaction.result
 
1
DROP TABLE IF EXISTS t1_trx, t1_non_trx;
 
2
SET AUTOCOMMIT= 0;
 
3
CREATE TABLE t1_trx (
 
4
k VARCHAR(10) NOT NULL
 
5
, v VARCHAR(10) NOT NULL
 
6
, PRIMARY KEY (k)
 
7
) ENGINE=InnoDB;
 
8
CREATE TEMPORARY TABLE t1_non_trx (
 
9
k VARCHAR(10) NOT NULL
 
10
, v VARCHAR(10) NOT NULL
 
11
, PRIMARY KEY (k)
 
12
) ENGINE=MyISAM;
 
13
START TRANSACTION;
 
14
INSERT INTO t1_trx VALUES ('key1','value1');
 
15
INSERT INTO t1_trx VALUES ('key2','value2');
 
16
INSERT INTO t1_non_trx VALUES ('key1','value1');
 
17
INSERT INTO t1_non_trx VALUES ('key2','value2');
 
18
ROLLBACK;
 
19
Warnings:
 
20
Warning 1196    Some non-transactional changed tables couldn't be rolled back
 
21
Expected warning about non-trx data changes not being rolled back
 
22
SELECT * FROM t1_trx;
 
23
k       v
 
24
SELECT * FROM t1_non_trx;
 
25
k       v
 
26
key1    value1
 
27
key2    value2
 
28
START TRANSACTION;
 
29
INSERT INTO t1_trx VALUES ('key1','value1');
 
30
INSERT INTO t1_trx VALUES ('key2','value2');
 
31
SELECT t1_trx.k, t1_trx.v
 
32
FROM t1_trx
 
33
INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
 
34
k       v
 
35
key1    value1
 
36
key2    value2
 
37
ROLLBACK;
 
38
SELECT t1_trx.k, t1_trx.v
 
39
FROM t1_trx
 
40
INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
 
41
k       v
 
42
DROP TABLE t1_trx;
 
43
DROP TABLE t1_non_trx;