Amazon PIVOT bug? "column does not exist"

Question

I'm trying to use the Amazon PIVOT feature and am encountering what appears to be a bug.  See minimal query and output below:

```
> WITH t1 AS (select 1 as a) select 1 from t1 PIVOT (sum(a) for a in (1)) WHERE ('NaN'::FLOAT = 0);
ERROR:  Query unsupported due to an internal error.
DETAIL:  SQL reparse error.
CONTEXT:  column "nan" does not exist in unnamed_pivot1.
```

The literals in the where clause don't have anything to do with the pivot, so the error message does not seem accurate.  Is this indeed a bug?  Please let me know if I can provide any further information.  Thanks!

Answer

The literal in the where clause is the problem. The query can't be parsed because there isn't a column named "nan".

Are you trying to check for null with "nan"?

Amazon PIVOT bug? "column does not exist"

Relevant questions

Bug: Amazon Chime in germany with arabic as language

Exception in User Class: org.postgresql.util.PSQLException : ERROR: column "id" does not exist

Setting column width in pivot table - Quicksight

Adding the filename as a column in the output

Trying to use a single Amazon API Gateway endpoint to accept both HTTP and websocket requests