← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/execute/r/transaction.result

  • Committer: Jay Pipes
  • Date: 2009-02-28 20:43:31 UTC
  • mto: (910.2.6 mordred-noatomics)
  • mto: This revision was merged to the branch mainline in revision 912.
  • Revision ID: jpipes@serialcoder-20090228204331-6x804cdbfzyy9w8i
Merged in remove-timezone work

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/execute/r/transaction.result
1
 
CREATE TABLE t1 (a SERIAL);
2
 
SET @insert_var= "INSERT INTO t1 VALUES()";
3
 
EXECUTE @insert_var;
4
 
SELECT a FROM t1;
5
 
a
6
 
1
7
 
SET AUTOCOMMIT= 0;
8
 
START TRANSACTION;
9
 
EXECUTE @insert_var;
10
 
COMMIT;
11
 
SELECT a FROM t1;
12
 
a
13
 
1
14
 
2
15
 
START TRANSACTION;
16
 
EXECUTE @insert_var;
17
 
ROLLBACK;
18
 
SELECT a FROM t1;
19
 
a
20
 
1
21
 
2
22
 
START TRANSACTION;
23
 
SET @insert_var= "INSERT INTO t1 VALUES(); SELECT WILL_ERROR;";
24
 
EXECUTE @insert_var;
25
 
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '; SELECT WILL_ERROR;' at line 1
26
 
COMMIT;
27
 
SELECT a FROM t1;
28
 
a
29
 
1
30
 
2
31
 
DROP TABLE t1;