search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
523 stars 161 forks source link

Support running regression tests against MariaDB #200

Closed df7cb closed 2 years ago

df7cb commented 3 years ago

Some error messages differ between MySQL and MariaDB, add alternate _1.out files for these.

df7cb commented 3 years ago

FWIW, this fixes the regression tests against MariaDB in Debian unstable/buster/stretch.

Tests are still broken with MySQL in Ubuntu xenial/bionic/focal since each MySQL version in there seems to have invented a new error code for the localhos test:

14:33:46 --- /tmp/autopkgtest.mWkkz4/tree/expected/connection_validation.out    2020-08-03 10:29:28.000000000 +0000
14:33:46 +++ /tmp/autopkgtest.mWkkz4/tree/results/connection_validation.out 2020-08-03 12:33:45.261017417 +0000
14:33:46 @@ -28,7 +28,7 @@
14:33:46  -- details and fail as the host address is not correct.
14:33:46  ALTER SERVER mysql_svr OPTIONS (SET host 'localhos');
14:33:46  SELECT * FROM f_mysql_test ORDER BY 1, 2;
14:33:46 -ERROR:  failed to connect to MySQL: Unknown MySQL server host 'localhos' (2)
14:33:46 +ERROR:  failed to connect to MySQL: Unknown MySQL server host 'localhos' (22)

I'll just ignore these tests for the postgresql-mysql-fdw.deb packages.