~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
#
2
# Bug#21114 (Foreign key creation fails to table with name format)
3
#
4
# Trying to trick the parser into thinking $FCT(...) is a function call,
5
# which is not in the CREATE TABLE and FOREIGN KEY ... REFERENCES syntax
6
#
7
# Usage :
8
#
9
# let $engine_type=InnoDb;
10
# let $verbose=1;
11
# let $FCT= <value_1>;
12
# -- source parser_stress_func.inc
13
# let $FCT= <value_2>;
14
# -- source parser_stress_func.inc
15
# let $verbose=0;
16
# let $FCT= <value_3>;
17
# -- source parser_stress_func.inc
18
# let $FCT= <value_4>;
19
# -- source parser_stress_func.inc
20
21
-- disable_warnings
22
eval drop table if exists $FCT;
23
drop table if exists bug21114_child;
24
-- enable_warnings
25
26
--disable_query_log
27
--disable_result_log
28
29
eval CREATE TABLE $FCT(
30
  col1 int not null,
31
  col2 int not null,
32
  col3 varchar(10),
33
  CONSTRAINT pk PRIMARY KEY (col1, col2)
1245.3.4 by Stewart Smith
make the equals of KEY=VALUE required for CREATE TABLE options
34
) ENGINE=$engine_type;
1 by brian
clean slate
35
36
eval CREATE TABLE bug21114_child(
37
  pk int not null,
38
  fk_col1 int not null,
39
  fk_col2 int not null,
40
  fk_col3 int not null,
41
  fk_col4 int not null,
42
  CONSTRAINT fk_fct FOREIGN KEY (fk_col1, fk_col2)
43
    REFERENCES $FCT(col1, col2),
44
  CONSTRAINT fk_fct_space FOREIGN KEY (fk_col3, fk_col4)
45
    REFERENCES $FCT (col1, col2)
1245.3.4 by Stewart Smith
make the equals of KEY=VALUE required for CREATE TABLE options
46
) ENGINE=$engine_type;
1 by brian
clean slate
47
48
--enable_query_log
49
--enable_result_log
50
51
if ($verbose)
52
{
53
  eval SHOW CREATE TABLE $FCT;
54
  SHOW CREATE TABLE bug21114_child;
55
}
56
57
DROP TABLE bug21114_child;
58
eval DROP TABLE $FCT;
59