← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/transaction.result

  • Committer: Brian Aker
  • Date: 2011-02-12 08:20:19 UTC
  • mto: This revision was merged to the branch mainline in revision 2161.
  • Revision ID: brian@tangent.org-20110212082019-09gs5y1b0pxoaesb
Merge in optimizer pieces.

Show diffs side-by-side

added added

removed removed

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