Attachment #214480 for bug #246462

Lines 1-3 Link Here

(-)databases/postgresql-mysql_fdw/distinfo (-3 / +3 lines)
1	TIMESTAMP = 1564831233	1	TIMESTAMP = 1589394566
2	SHA256 (EnterpriseDB-mysql_fdw-REL-2_5_1_GH0.tar.gz) = 8367ed71e76000d4ec9661cab7e12c3c8d0ecc887d6f677f7d448a5a35bbd96e	2	SHA256 (EnterpriseDB-mysql_fdw-REL-2_5_3_GH0.tar.gz) = 820e5bf1a55d64db91e4a5247f2859c2d485cc5eece28b6ad520e179e543e518
3	SIZE (EnterpriseDB-mysql_fdw-REL-2_5_1_GH0.tar.gz) = 42615	3	SIZE (EnterpriseDB-mysql_fdw-REL-2_5_3_GH0.tar.gz) = 42804




See https://github.com/EnterpriseDB/mysql_fdw/pull/190/commits/043a77c9b4a600f0884b4e50ee05be68c3c731e7, add support for binary / varbinary
--- ./mysql_fdw.c.ORIG	2019-09-28 08:02:16.000000000 +0200
+++ ./mysql_fdw.c	2020-05-13 21:07:32.069351000 +0200
@@ -1946,6 +1946,9 @@
                      "    WHEN c.DATA_TYPE = 'blob' THEN 'bytea'"
                      "    WHEN c.DATA_TYPE = 'mediumblob' THEN 'bytea'"
                      "    WHEN c.DATA_TYPE = 'longblob' THEN 'bytea'"
+                     "    WHEN c.DATA_TYPE = 'tinyblob' THEN 'bytea'" 
+                     "    WHEN c.DATA_TYPE = 'binary' THEN 'bytea'" 
+                     "    WHEN c.DATA_TYPE = 'varbinary' THEN 'bytea'"
                      "    ELSE c.DATA_TYPE"
                      "  END,"
                      "  c.COLUMN_TYPE,"

Lines 3-9 Link Here

(-)databases/postgresql-mysql_fdw/Makefile (-2 / +2 lines)
3		3
4	PORTNAME= mysql_fdw	4	PORTNAME= mysql_fdw
5	DISTVERSIONPREFIX= REL-	5	DISTVERSIONPREFIX= REL-
6	DISTVERSION= 2_5_1	6	DISTVERSION= 2_5_3
7	CATEGORIES= databases	7	CATEGORIES= databases
8	PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}-	8	PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}-
9		9
Lines 13-19 Link Here
13	LICENSE= PostgreSQL	13	LICENSE= PostgreSQL
14	LICENSE_FILE= ${WRKSRC}/LICENSE	14	LICENSE_FILE= ${WRKSRC}/LICENSE
15		15
16	USES= gmake pgsql:9.3-11 mysql	16	USES= gmake pgsql:9.5-12 mysql
17	WANT_PGSQL= server	17	WANT_PGSQL= server
18	USE_GITHUB= yes	18	USE_GITHUB= yes
19	GH_ACCOUNT= EnterpriseDB	19	GH_ACCOUNT= EnterpriseDB

Return to bug 246462

Line 0 Link Here

(-)databases/postgresql-mysql_fdw/files/patch-mysql-fdw.c (+13 lines)
	1	See https://github.com/EnterpriseDB/mysql_fdw/pull/190/commits/043a77c9b4a600f0884b4e50ee05be68c3c731e7, add support for binary / varbinary
	2	--- ./mysql_fdw.c.ORIG 2019-09-28 08:02:16.000000000 +0200
	3	+++ ./mysql_fdw.c 2020-05-13 21:07:32.069351000 +0200
	4	@@ -1946,6 +1946,9 @@
	5	" WHEN c.DATA_TYPE = 'blob' THEN 'bytea'"
	6	" WHEN c.DATA_TYPE = 'mediumblob' THEN 'bytea'"
	7	" WHEN c.DATA_TYPE = 'longblob' THEN 'bytea'"
	8	+ " WHEN c.DATA_TYPE = 'tinyblob' THEN 'bytea'"
	9	+ " WHEN c.DATA_TYPE = 'binary' THEN 'bytea'"
	10	+ " WHEN c.DATA_TYPE = 'varbinary' THEN 'bytea'"
	11	" ELSE c.DATA_TYPE"
	12	" END,"
	13	" c.COLUMN_TYPE,"