← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/execute_concurrent.test

  • Committer: Brian Aker
  • Date: 2010-11-12 21:22:46 UTC
  • mto: (1932.2.1 trunk)
  • mto: This revision was merged to the branch mainline in revision 1930.
  • Revision ID: brian@tangent.org-20101112212246-jsn2vgxzgesuv9pt
Test for issues on CONCURRENT to be sure it operates in a single
transaction.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/execute_concurrent.test
39
39
show schemas LIKE "e";
40
40
DROP SCHEMA d;
41
41
DROP SCHEMA e;
 
42
 
 
43
 
 
44
# We are now going to make sure that data is actually committed.
 
45
CREATE TABLE foo (a serial);
 
46
 
 
47
SET @var="INSERT INTO foo VALUES(); INSERT INTO foo VALUES ()";
 
48
EXECUTE @var CONCURRENT;
 
49
EXECUTE @sleep;
 
50
SELECT * FROM foo;
 
51
 
 
52
SET @var="SAVEPOINT mine; INSERT INTO foo VALUES(); INSERT INTO foo VALUES ()";
 
53
EXECUTE @var CONCURRENT;
 
54
EXECUTE @sleep;
 
55
SELECT * FROM foo;
 
56
 
 
57
SET @var="SAVEPOINT mine; INSERT INTO foo VALUES(); INSERT INTO foo VALUES (); RELEASE SAVEPOINT mine";
 
58
EXECUTE @var CONCURRENT;
 
59
EXECUTE @sleep;
 
60
SELECT * FROM foo;
 
61
 
 
62
SET @var="SAVEPOINT mine; INSERT INTO foo VALUES (); INSERT INTO foo VALUES (); ROLLBACK TO SAVEPOINT mine";
 
63
EXECUTE @var CONCURRENT;
 
64
EXECUTE @sleep;
 
65
SELECT * FROM foo;
 
66
 
 
67
DROP TABLE foo;
 
68