pgspider / influxdb_fdw

InfluxDB Foreign Data Wrapper for PostgreSQL.
Other
58 stars 14 forks source link

Error of push down with mathematical operations inside of agg function calls #10

Closed hrkuma closed 4 years ago

hrkuma commented 4 years ago

On InfluxDB the use of mathematical operations inside of function calls is not supported. ref.) https://docs.influxdata.com/influxdb/v1.7/query_language/math_operators/#issue-2-mathematical-operators-with-functions ex.) SELECT sum(x * x) FROM "table"

However PostgreSQL can support such calls. Currently InfluxDB FDW pushes down them without no cheking and such query results in error. We should check the push down condition by checking function arguments.