1let $VERSION_COMPILE_OS_WIN=
2  `SELECT IF(@@version_compile_os like 'Win%', 1, 0)`;
3if ($VERSION_COMPILE_OS_WIN)
4{
5  INSTALL PLUGIN spider SONAME 'ha_spider.dll';
6  if ($MASTER_1_MYPORT)
7  {
8    eval CREATE SERVER s_1 FOREIGN DATA WRAPPER mysql OPTIONS (
9      HOST 'localhost',
10      DATABASE 'auto_test_local',
11      USER 'root',
12      PASSWORD '',
13      PORT $MASTER_1_MYPORT
14    );
15  }
16  if ($CHILD2_1_MYPORT)
17  {
18    eval CREATE SERVER s_2_1 FOREIGN DATA WRAPPER mysql OPTIONS (
19      HOST 'localhost',
20      DATABASE 'auto_test_remote',
21      USER 'root',
22      PASSWORD '',
23      PORT $CHILD2_1_MYPORT
24    );
25  }
26  if ($CHILD2_2_MYPORT)
27  {
28    eval CREATE SERVER s_2_2 FOREIGN DATA WRAPPER mysql OPTIONS (
29      HOST 'localhost',
30      DATABASE 'auto_test_remote2',
31      USER 'root',
32      PASSWORD '',
33      PORT $CHILD2_2_MYPORT
34    );
35  }
36  if ($CHILD2_3_MYPORT)
37  {
38    eval CREATE SERVER s_2_3 FOREIGN DATA WRAPPER mysql OPTIONS (
39      HOST 'localhost',
40      DATABASE 'auto_test_remote3',
41      USER 'root',
42      PASSWORD '',
43      PORT $CHILD2_3_MYPORT
44    );
45  }
46  if ($CHILD3_1_MYPORT)
47  {
48    eval CREATE SERVER s_3_1 FOREIGN DATA WRAPPER mysql OPTIONS (
49      HOST 'localhost',
50      DATABASE 'auto_test_local',
51      USER 'root',
52      PASSWORD '',
53      PORT $CHILD3_1_MYPORT
54    );
55  }
56  if ($CHILD3_2_MYPORT)
57  {
58    eval CREATE SERVER s_3_2 FOREIGN DATA WRAPPER mysql OPTIONS (
59      HOST 'localhost',
60      DATABASE 'auto_test_local',
61      USER 'root',
62      PASSWORD '',
63      PORT $CHILD3_2_MYPORT
64    );
65  }
66  if ($CHILD2_3_MYPORT)
67  {
68    eval CREATE SERVER s_3_3 FOREIGN DATA WRAPPER mysql OPTIONS (
69      HOST 'localhost',
70      DATABASE 'auto_test_local',
71      USER 'root',
72      PASSWORD '',
73      PORT $CHILD2_3_MYPORT
74    );
75  }
76}
77if (!$VERSION_COMPILE_OS_WIN)
78{
79  INSTALL PLUGIN spider SONAME 'ha_spider.so';
80  if ($MASTER_1_MYSOCK)
81  {
82    eval CREATE SERVER s_1 FOREIGN DATA WRAPPER mysql OPTIONS (
83      HOST 'localhost',
84      DATABASE 'auto_test_local',
85      USER 'root',
86      PASSWORD '',
87      SOCKET '$MASTER_1_MYSOCK'
88    );
89  }
90  if ($CHILD2_1_MYSOCK)
91  {
92    eval CREATE SERVER s_2_1 FOREIGN DATA WRAPPER mysql OPTIONS (
93      HOST 'localhost',
94      DATABASE 'auto_test_remote',
95      USER 'root',
96      PASSWORD '',
97      SOCKET '$CHILD2_1_MYSOCK'
98    );
99  }
100  if ($CHILD2_2_MYSOCK)
101  {
102    eval CREATE SERVER s_2_2 FOREIGN DATA WRAPPER mysql OPTIONS (
103      HOST 'localhost',
104      DATABASE 'auto_test_remote2',
105      USER 'root',
106      PASSWORD '',
107      SOCKET '$CHILD2_2_MYSOCK'
108    );
109  }
110  if ($CHILD2_3_MYSOCK)
111  {
112    eval CREATE SERVER s_2_3 FOREIGN DATA WRAPPER mysql OPTIONS (
113      HOST 'localhost',
114      DATABASE 'auto_test_remote3',
115      USER 'root',
116      PASSWORD '',
117      SOCKET '$CHILD2_3_MYSOCK'
118    );
119  }
120  if ($CHILD3_1_MYSOCK)
121  {
122    eval CREATE SERVER s_3_1 FOREIGN DATA WRAPPER mysql OPTIONS (
123      HOST 'localhost',
124      DATABASE 'auto_test_local',
125      USER 'root',
126      PASSWORD '',
127      SOCKET '$CHILD3_1_MYSOCK'
128    );
129  }
130  if ($CHILD3_2_MYSOCK)
131  {
132    eval CREATE SERVER s_3_2 FOREIGN DATA WRAPPER mysql OPTIONS (
133      HOST 'localhost',
134      DATABASE 'auto_test_local',
135      USER 'root',
136      PASSWORD '',
137      SOCKET '$CHILD3_2_MYSOCK'
138    );
139  }
140  if ($CHILD3_3_MYSOCK)
141  {
142    eval CREATE SERVER s_3_3 FOREIGN DATA WRAPPER mysql OPTIONS (
143      HOST 'localhost',
144      DATABASE 'auto_test_local',
145      USER 'root',
146      PASSWORD '',
147      SOCKET '$CHILD3_3_MYSOCK'
148    );
149  }
150}
151
152let $SERVER_NAME=
153  `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(version(), '-', 2), '-', -1)`;
154if (`SELECT IF('$SERVER_NAME' REGEXP '^[0-9]+\$', 1, 0)`)
155{
156  let $SERVER_NAME=
157    `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(version(), '-', 3), '-', -1)`;
158}
159let $SERVER_MAJOR_VERSION=
160  `SELECT SUBSTRING_INDEX(version(), '.', 1)`;
161let $SERVER_MINOR_VERSION=
162  `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(version(), '.', 2), '.', -1)`;
163let $PLUGIN_VERSION=
164  `SELECT SUBSTRING_INDEX(plugin_version, '.', 1)
165     FROM information_schema.plugins
166    WHERE plugin_name = 'SPIDER'`;
167if (`SELECT IF($PLUGIN_VERSION = 3, 1, 0)`)
168{
169  let $HAS_REWRITE=
170    `SELECT IF (STRCMP('$SERVER_NAME', 'MariaDB') = 0,
171                IF ($SERVER_MAJOR_VERSION = 10,
172                    IF ($SERVER_MINOR_VERSION < 4,  0, 1),
173                    IF ($SERVER_MAJOR_VERSION < 10, 0, 1)),
174                0)`;
175  let $HAS_REWRITE= 0;
176  if ($HAS_REWRITE)
177  {
178    let $PLUGIN_NAME= spider_flush_rewrite_cache;
179    let $PLUGIN_EXIST=
180      `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`;
181    while (!$PLUGIN_EXIST)
182    {
183      let $PLUGIN_EXIST=
184        `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`;
185    }
186  }
187}
188let $PLUGIN_NAME= spider_flush_table_mon_cache;
189let $PLUGIN_EXIST=
190  `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`;
191while (!$PLUGIN_EXIST)
192{
193  let $PLUGIN_EXIST=
194    `SELECT COUNT(*) FROM mysql.func WHERE name = '$PLUGIN_NAME'`;
195}
196
197SET spider_internal_sql_log_off= 0;
198