← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/suite/backwards_compat/t/foreign_key.test

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/backwards_compat/t/foreign_key.test
 
1
#
 
2
# Test syntax of foreign keys
 
3
#
 
4
 
 
5
show create table product_order;
 
6
 
 
7
SHOW CREATE TABLE bug56143_2;
 
8
 
 
9
--disable_query_log
 
10
begin;
 
11
let $i=257;
 
12
while ($i)
 
13
{
 
14
insert into B(f1) values(1);
 
15
dec $i;
 
16
}
 
17
let $i=486;
 
18
while ($i)
 
19
{
 
20
insert into C(f1) values(2);
 
21
dec $i;
 
22
}
 
23
commit;
 
24
--enable_query_log
 
25
 
 
26
# Following Deletes should not report error
 
27
DELETE FROM A where id = 1;
 
28
DELETE FROM C where f1 = 2;
 
29
DELETE FROM A where id = 1;