test pushdown FAILED

[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;