Bug#1036162: unblock: postgresql-mysql-fdw/2.8.0-4

[Christoph Berg]

Package: release.debian.org
Severity: normal
User: release.debian....@packages.debian.org
Usertags: unblock
X-Debbugs-Cc: postgresql-mysql-...@packages.debian.org
Control: affects -1 + src:postgresql-mysql-fdw

Please unblock package postgresql-mysql-fdw

[ Reason ]
The new version fixes the regression tests (breakage caused by changes
on the mariadb side I think).

[ Impact ]
Test-only fix, the software remains unchanged.

[ Tests ]
It's the tests themselves, there are no extra tests :)

[ Risks ]
None.

[ Checklist ]
  [x] all changes are documented in the d/changelog
  [x] I reviewed all changes and I approve them
  [x] attach debdiff against the package in testing

unblock postgresql-mysql-fdw/2.8.0-4

Christoph

No differences were encountered between the control files

diff -Nru postgresql-mysql-fdw-2.8.0/debian/changelog postgresql-mysql-fdw-2.8.0/debian/changelog
--- postgresql-mysql-fdw-2.8.0/debian/changelog	2022-10-24 16:01:20.000000000 +0200
+++ postgresql-mysql-fdw-2.8.0/debian/changelog	2023-05-15 15:11:37.000000000 +0200
@@ -1,3 +1,9 @@
+postgresql-mysql-fdw (2.8.0-4) unstable; urgency=medium
+
+  * Adjust tests for changed mysql error messages. (Closes: #1033836)
+
+ -- Christoph Berg <m...@debian.org>  Mon, 15 May 2023 15:11:37 +0200
+
 postgresql-mysql-fdw (2.8.0-3) unstable; urgency=medium
 
   * Upload for PostgreSQL 15.
diff -Nru postgresql-mysql-fdw-2.8.0/debian/patches/mysql-error-text postgresql-mysql-fdw-2.8.0/debian/patches/mysql-error-text
--- postgresql-mysql-fdw-2.8.0/debian/patches/mysql-error-text	2022-10-24 16:01:20.000000000 +0200
+++ postgresql-mysql-fdw-2.8.0/debian/patches/mysql-error-text	2023-05-15 15:11:37.000000000 +0200
@@ -20,3 +20,25 @@
  	  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;