1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
--- a/expected/connection_validation.out
+++ b/expected/connection_validation.out
@@ -34,7 +34,7 @@ $$
BEGIN
SELECT * FROM f_mysql_test ORDER BY 1, 2;
EXCEPTION WHEN others THEN
- IF SQLERRM LIKE 'failed to connect to MySQL: Unknown MySQL server host ''localhos'' (%)' THEN
+ IF SQLERRM LIKE 'failed to connect to MySQL: Unknown %server host ''localhos'' (%)' THEN
RAISE NOTICE 'failed to connect to MySQL: Unknown MySQL server host ''localhos''';
ELSE
RAISE NOTICE '%', SQLERRM;
--- a/sql/connection_validation.sql
+++ b/sql/connection_validation.sql
@@ -34,7 +34,7 @@ $$
BEGIN
SELECT * FROM f_mysql_test ORDER BY 1, 2;
EXCEPTION WHEN others THEN
- IF SQLERRM LIKE 'failed to connect to MySQL: Unknown MySQL server host ''localhos'' (%)' THEN
+ IF SQLERRM LIKE 'failed to connect to MySQL: Unknown %server host ''localhos'' (%)' THEN
RAISE NOTICE 'failed to connect to MySQL: Unknown MySQL server host ''localhos''';
ELSE
RAISE NOTICE '%', SQLERRM;
--- a/expected/dml.out
+++ b/expected/dml.out
@@ -83,7 +83,7 @@ $$
BEGIN
INSERT INTO fdw126_ft2 VALUES(2, 'Two');
EXCEPTION WHEN others THEN
- IF SQLERRM LIKE '%SELECT command denied to user ''%''@''%'' for table ''student''' THEN
+ IF SQLERRM LIKE '%SELECT command denied to user ''%''@''%'' for table %student%' THEN
RAISE NOTICE E'failed to execute the MySQL query: \nUnknown database ''public''';
ELSE
RAISE NOTICE '%', SQLERRM;
--- a/sql/dml.sql
+++ b/sql/dml.sql
@@ -70,7 +70,7 @@ $$
BEGIN
INSERT INTO fdw126_ft2 VALUES(2, 'Two');
EXCEPTION WHEN others THEN
- IF SQLERRM LIKE '%SELECT command denied to user ''%''@''%'' for table ''student''' THEN
+ IF SQLERRM LIKE '%SELECT command denied to user ''%''@''%'' for table %student%' THEN
RAISE NOTICE E'failed to execute the MySQL query: \nUnknown database ''public''';
ELSE
RAISE NOTICE '%', SQLERRM;
|
