GROUP BY does not support FIELD KEY having arithmetic

pgspider / influxdb_fdw

InfluxDB Foreign Data Wrapper for PostgreSQL.

Other

58 stars 14 forks source link

GROUP BY does not support FIELD KEY having arithmetic #17

Closed lamduongngoc closed 3 years ago

lamduongngoc commented 4 years ago

The following query is failed on Postgres 10.12, 11.7, 12

select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
ERROR:  influxdb_fdw : error parsing query: found FROM, expected identifier, string, number, bool at line 1, char 9

InfluxDB does not support the arithmetic field (c2/2) in GROUP BY. InfluxDB FDW should execute on local.

hrkuma commented 3 years ago

We have fixed in Release v0.3.0. So we'd like to close this issue.