summaryrefslogtreecommitdiffstats
path: root/tests/data/parseTransaction2.in
diff options
context:
space:
mode:
Diffstat (limited to 'tests/data/parseTransaction2.in')
-rw-r--r--tests/data/parseTransaction2.in4
1 files changed, 4 insertions, 0 deletions
diff --git a/tests/data/parseTransaction2.in b/tests/data/parseTransaction2.in
new file mode 100644
index 0000000..672a626
--- /dev/null
+++ b/tests/data/parseTransaction2.in
@@ -0,0 +1,4 @@
+START TRANSACTION;
+SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
+UPDATE table2 SET summary=@A WHERE type=1;
+ROLLBACK; \ No newline at end of file