EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
521 stars 160 forks source link

[Feature Support] Support ANY ARRAY #252

Open khieuvm opened 2 years ago

khieuvm commented 2 years ago

We have already implemented this feature:

Support case:

Unsupported cases:

Example:

EXPLAIN (VERBOSE, COSTS OFF)
  SELECT * FROM ft1 t1 WHERE c1 <= ANY(ARRAY[1, 2, 3]);
                                                                        QUERY PLAN                                                                        
----------------------------------------------------------------------------------------------------------------------------------------------------------
 Foreign Scan on public.ft1 t1
   Output: c1, c2, c3, c4, c5, c6, c7, c8
   Local server startup cost: 10
   Remote query: SELECT `c1`, `c2`, `c3`, `c4`, `c5`, `c6`, `c7`, `c8` FROM `mysql_fdw_post`.`position_data1` WHERE (`c1` <= 1 OR `c1` <= 2 OR `c1` <= 3)
(4 rows)

I would like to contribute them to the repository and community. I will create a pull request to share this feature if you have any interest.