test pushdown failed on Mac

[xuanskyer]

============== running regression test queries        ==============
test server_options               ... ok          178 ms
test connection_validation        ... ok         5174 ms
test dml                          ... ok          167 ms
test select                       ... ok          717 ms
test pushdown                     ... FAILED      233 ms
test join_pushdown                ... ok          275 ms
test aggregate_pushdown           ... ok          153 ms
test limit_offset_pushdown        ... ok           87 ms
test misc                         ... ok          143 ms

======================
 1 of 9 tests failed.
======================

diff -U3 /Users/admin/projects/github.com/mysql_fdw/expected/pushdown.out /Users/admin/projects/github.com/mysql_fdw/results/pushdown.out
--- /Users/admin/projects/github.com/mysql_fdw/expected/pushdown.out	2023-05-09 11:28:41.000000000 +0800
+++ /Users/admin/projects/github.com/mysql_fdw/results/pushdown.out	2023-05-09 13:05:09.000000000 +0800
@@ -565,20 +565,16 @@
 
 EXPLAIN (COSTS FALSE, VERBOSE)
 SELECT MIN(c1) FROM f_test_tbl1 ORDER BY 1 USING OPERATOR(public.<^);
-                                                                QUERY PLAN                                                                 
--------------------------------------------------------------------------------------------------------------------------------------------
+                                 QUERY PLAN                                  
+-----------------------------------------------------------------------------
  Sort
-   Output: ($0)
-   Sort Key: ($0) USING <^
-   InitPlan 1 (returns $0)
-     ->  Limit
-           Output: f_test_tbl1.c1
-           ->  Foreign Scan on public.f_test_tbl1
-                 Output: f_test_tbl1.c1
-                 Remote query: SELECT `c1` FROM `mysql_fdw_regress`.`test_tbl1` WHERE ((`c1` IS NOT NULL)) ORDER BY `c1` IS NULL, `c1` ASC
-   ->  Result
-         Output: $0
-(11 rows)
+   Output: (min(c1))
+   Sort Key: (min(f_test_tbl1.c1)) USING <^
+   ->  Foreign Scan
+         Output: (min(c1))
+         Relations: Aggregate on (mysql_fdw_regress.f_test_tbl1)
+         Remote query: SELECT min(`c1`) FROM `mysql_fdw_regress`.`test_tbl1`
+(7 rows)
 
 -- Cleanup
 DELETE FROM f_test_tbl1;

[surajkharage19]

Hi,

MacOS is not a supported platform for mysql_fdw. The supported platform list is provided in the documentation. https://www.enterprisedb.com/docs/mysql_data_adapter/latest/02_requirements_overview/

However, I have checked at my end on CentOS 7 and regression is clean.

If you are using a supported platform and still observing the above regression failure then please provide below additional information using which I can reproduce the issue at my end: 1: Postgres version 2: How you have installed mysql_fdw? using source code? or using RPM? 3: Platform details.

Thanks, Suraj