Attachment #214517 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




--- ./mysql_fdw.c.ORIG	2019-09-28 08:02:16.000000000 +0200
+++ ./mysql_fdw.c	2020-05-15 09:40:53.046859000 +0200
@@ -207,9 +207,9 @@
 bool
 mysql_load_library(void)
 {
-#if defined(__APPLE__) || defined(__FreeBSD__)
+#if defined(__APPLE__)
 	/*
-	 * Mac OS/BSD does not support RTLD_DEEPBIND, but it still
+	 * Mac OS does not support RTLD_DEEPBIND, but it still
 	 * works without the RTLD_DEEPBIND
 	 */
 	mysql_dll_handle = dlopen(_MYSQL_LIBNAME, RTLD_LAZY);
@@ -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

Lines 6-11 Link Here

(-)./databases/postgresql-mysql_fdw/pkg-descr (-1 / +1 lines)
6	Column push-down	6	Column push-down
7	Prepared Statment	7	Prepared Statment
8	Please note that this version of mysql_fdw works with PostgreSQL	8	Please note that this version of mysql_fdw works with PostgreSQL
9	9.3, 9.4, 9.5, 9.6, 10, and 11.	9	9.5, 9.6, 10, 11, and 12.
10		10
11	WWW: https://github.com/EnterpriseDB/mysql_fdw	11	WWW: https://github.com/EnterpriseDB/mysql_fdw

Return to bug 246462

Line 0 Link Here

(-)./databases/postgresql-mysql_fdw/files/patch-mysql-fdw.c (+24 lines)
	1	--- ./mysql_fdw.c.ORIG 2019-09-28 08:02:16.000000000 +0200
	2	+++ ./mysql_fdw.c 2020-05-15 09:40:53.046859000 +0200
	3	@@ -207,9 +207,9 @@
	4	bool
	5	mysql_load_library(void)
	6	{
	7	-#if defined(__APPLE__) \|\| defined(__FreeBSD__)
	8	+#if defined(__APPLE__)
	9	/*
	10	- * Mac OS/BSD does not support RTLD_DEEPBIND, but it still
	11	+ * Mac OS does not support RTLD_DEEPBIND, but it still
	12	* works without the RTLD_DEEPBIND
	13	*/
	14	mysql_dll_handle = dlopen(_MYSQL_LIBNAME, RTLD_LAZY);
	15	@@ -1946,6 +1946,9 @@
	16	" WHEN c.DATA_TYPE = 'blob' THEN 'bytea'"
	17	" WHEN c.DATA_TYPE = 'mediumblob' THEN 'bytea'"
	18	" WHEN c.DATA_TYPE = 'longblob' THEN 'bytea'"
	19	+ " WHEN c.DATA_TYPE = 'tinyblob' THEN 'bytea'"
	20	+ " WHEN c.DATA_TYPE = 'binary' THEN 'bytea'"
	21	+ " WHEN c.DATA_TYPE = 'varbinary' THEN 'bytea'"
	22	" ELSE c.DATA_TYPE"
	23	" END,"
	24	" c.COLUMN_TYPE,"