search

pgspider / influxdb_fdw

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

InfluxDB FDW fails GROUP BY time #19

Closed lamduongngoc closed 3 years ago

lamduongngoc commented 4 years ago

The following query is failed on Postgres 12. It is OK on Postgres 9.6.17

 SELECT sum(value1) FROM t4 GROUP BY time;                                         |  SELECT sum(value1) FROM t4 GROUP BY time;
   sum                                                                              |  ERROR:  influxdb_fdw : time() is a function and expects at least one argument
  -----                                                                             |  ---------------------------------------------------------------------------------
     2                                                                              |  ---------------------------------------------------------------------------------
    10                                                                              |  ---------------------------------------------------------------------------------
     1                                                                              |  ---------------------------------------------------------------------------------
    20                                                                              |  ---------------------------------------------------------------------------------
    30                                                                              |  ---------------------------------------------------------------------------------
     3                                                                              |  ---------------------------------------------------------------------------------
  (6 rows)
hrkuma commented 3 years ago

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