← 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: Daniel Nichter
  • Date: 2011-10-23 16:01:37 UTC
  • mto: This revision was merged to the branch mainline in revision 2448.
  • Revision ID: daniel@percona.com-20111023160137-7ac3blgz8z4tf8za
Add Administration Getting Started and Logging.  Capitalize SQL clause keywords.

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
Warnings:
 
17
Warning 1747    There is already a transaction in progress
 
18
EXECUTE @insert_var;
 
19
ROLLBACK;
 
20
SELECT a FROM t1;
 
21
a
 
22
1
 
23
2
 
24
START TRANSACTION;
 
25
Warnings:
 
26
Warning 1747    There is already a transaction in progress
 
27
SET @insert_var= "INSERT INTO t1 VALUES(); SELECT WILL_ERROR;";
 
28
EXECUTE @insert_var;
 
29
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
 
30
COMMIT;
 
31
SELECT a FROM t1;
 
32
a
 
33
1
 
34
2
 
35
SET AUTOCOMMIT= 1;
 
36
DROP TABLE t1;