search

pgspider / influxdb_fdw

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

GROUP BY does not work with duplicated targets. #15

Closed lamduongngoc closed 3 years ago

lamduongngoc commented 4 years ago

The actual result on Postgres 10.12, 11.7 and 12

select c2, c2 from ft1 where c2 > 6 group by 1, 2 order by sum(c1);
ERROR:  targetlist item has multiple sortgroupref labels

The actual result on Postgres 9.6.17

select c2, c2 from ft1 where c2 > 6 group by 1, 2 order by sum(c1);
 c2 | c2 
----+----
  7 |  7
  8 |  8
  9 |  9
(3 rows)
hrkuma commented 3 years ago

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