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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
Some tests have output that varies a lot between MySQL versions and also MariaDB.
Ignore these for Debian.
--- a/expected/connection_validation.out
+++ b/expected/connection_validation.out
@@ -27,8 +27,6 @@ SELECT * FROM f_mysql_test ORDER BY 1, 2
-- Set wrong host, subsequent operation on this server should use updated
-- details and fail as the host address is not correct.
ALTER SERVER mysql_svr OPTIONS (SET host 'localhos');
-SELECT * FROM f_mysql_test ORDER BY 1, 2;
-ERROR: failed to connect to MySQL: Unknown MySQL server host 'localhos' (2)
-- Set the correct host-name, next operation should succeed.
ALTER SERVER mysql_svr OPTIONS (SET host :MYSQL_HOST);
SELECT * FROM f_mysql_test ORDER BY 1, 2;
--- a/expected/connection_validation_1.out
+++ b/expected/connection_validation_1.out
@@ -27,8 +27,6 @@ SELECT * FROM f_mysql_test ORDER BY 1, 2
-- Set wrong host, subsequent operation on this server should use updated
-- details and fail as the host address is not correct.
ALTER SERVER mysql_svr OPTIONS (SET host 'localhos');
-SELECT * FROM f_mysql_test ORDER BY 1, 2;
-ERROR: failed to connect to MySQL: Unknown MySQL server host 'localhos' (-2)
-- Set the correct host-name, next operation should succeed.
ALTER SERVER mysql_svr OPTIONS (SET host :MYSQL_HOST);
SELECT * FROM f_mysql_test ORDER BY 1, 2;
--- a/sql/connection_validation.sql
+++ b/sql/connection_validation.sql
@@ -27,7 +27,6 @@ SELECT * FROM f_mysql_test ORDER BY 1, 2
-- Set wrong host, subsequent operation on this server should use updated
-- details and fail as the host address is not correct.
ALTER SERVER mysql_svr OPTIONS (SET host 'localhos');
-SELECT * FROM f_mysql_test ORDER BY 1, 2;
-- Set the correct host-name, next operation should succeed.
ALTER SERVER mysql_svr OPTIONS (SET host :MYSQL_HOST);
--- a/expected/dml.out
+++ b/expected/dml.out
@@ -74,9 +74,6 @@ SELECT a, b FROM f_mysql_test ORDER BY 1
-- creating the foreign table, so it will consider the schema name of foreign
-- table as database name and try to connect/lookup into that database. Will
-- throw an error.
-INSERT INTO fdw126_ft2 VALUES(2, 'Two');
-ERROR: failed to execute the MySQL query:
-Unknown database 'public'
-- Check with the same table name from different database. fdw126_ft3 is
-- pointing to the mysql_fdw_regress1.numbers and not mysql_fdw_regress.numbers
-- table. INSERT/UPDATE/DELETE should be failing. SELECT will return no rows.
--- a/expected/dml_1.out
+++ b/expected/dml_1.out
@@ -74,9 +74,6 @@ SELECT a, b FROM f_mysql_test ORDER BY 1
-- creating the foreign table, so it will consider the schema name of foreign
-- table as database name and try to connect/lookup into that database. Will
-- throw an error.
-INSERT INTO fdw126_ft2 VALUES(2, 'Two');
-ERROR: failed to execute the MySQL query:
-Unknown database 'public'
-- Check with the same table name from different database. fdw126_ft3 is
-- pointing to the mysql_fdw_regress1.numbers and not mysql_fdw_regress.numbers
-- table. INSERT/UPDATE/DELETE should be failing. SELECT will return no rows.
--- a/sql/dml.sql
+++ b/sql/dml.sql
@@ -63,7 +63,6 @@ SELECT a, b FROM f_mysql_test ORDER BY 1
-- creating the foreign table, so it will consider the schema name of foreign
-- table as database name and try to connect/lookup into that database. Will
-- throw an error.
-INSERT INTO fdw126_ft2 VALUES(2, 'Two');
-- Check with the same table name from different database. fdw126_ft3 is
-- pointing to the mysql_fdw_regress1.numbers and not mysql_fdw_regress.numbers
|
