search

pgspider / influxdb_fdw

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

Aggregate functions with arithmetic in parentheses are not supported. #14

Closed lamduongngoc closed 3 years ago

lamduongngoc commented 4 years ago

The following query works well on Postgres 9.6.17. Not OK on Postgres 12

Actual result on Postgres 12

select ten, count(four), sum(DISTINCT four) from onek
  group by ten order by ten;
ERROR:  influxdb_fdw : expected field argument in sum()

Actual result on Postgres 9.6.17

select ten, count(four), sum(DISTINCT four) from onek
group by ten order by ten;
 ten | count | sum 
-----+-------+-----
   0 |   100 |   2
   1 |   100 |   4
   2 |   100 |   2
   3 |   100 |   4
   4 |   100 |   2
   5 |   100 |   4
   6 |   100 |   2
   7 |   100 |   4
   8 |   100 |   2
   9 |   100 |   4
(10 rows)
hrkuma commented 3 years ago

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