← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Stewart Smith
  • Date: 2011-05-11 14:40:50 UTC
  • mto: (2274.1.7 dbqp_server_setup)
  • mto: This revision was merged to the branch mainline in revision 2312.
  • Revision ID: stewart@flamingspork.com-20110511144050-8isy4j8eox1kt2xu
add some bits of other tests about foreign keys to a binary backwards compatibility test

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;