~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/transaction.result

  • Committer: Brian Aker
  • Date: 2011-01-13 09:25:42 UTC
  • mfrom: (2073.1.4 catalogs)
  • mto: This revision was merged to the branch mainline in revision 2080.
  • Revision ID: brian@gir-3-20110113092542-lmomnx1t0zpidzl4
Merge of current catalogs

Show diffs side-by-side

added added

removed removed

Lines of Context:
26
26
key1    value1
27
27
key2    value2
28
28
START TRANSACTION;
29
 
Warnings:
30
 
Warning 1746    There is already a transaction in progress
31
29
INSERT INTO t1_trx VALUES ('key1','value1');
32
30
INSERT INTO t1_trx VALUES ('key2','value2');
33
31
SELECT t1_trx.k, t1_trx.v
41
39
FROM t1_trx
42
40
INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
43
41
k       v
44
 
COMMIT;
45
42
DROP TABLE t1_trx;
46
43
DROP TABLE t1_non_trx;