SQL Error for Postgres Virtual Graph

[mgberg (Matt Goldberg)]

I'm trying to virtualize some data in Postgres, and the generated SQL queries can fail at times as they sometimes contain the following pattern:

CAST("table"."column" AS DOUBLE)

This is problematic because in Postgres the datatype is called DOUBLE PRECISION, not DOUBLE. Copying the failed query and executing it manually after adding PRECISION works. Has anyone encountered this before and is there a fix, or is this actually a bug?

[PaulJackson]

Hi Matt,

This sounds like a bug. I'll create a ticket for it.

Thanks,
-Paul

[PaulJackson]

@mgberg

I'm trying to virtualize some data in Postgres, and the generated SQL queries can fail at times as they sometimes contain the following pattern:

CAST("table"."column" AS DOUBLE)

This is problematic because in Postgres the datatype is called DOUBLE PRECISION, not DOUBLE. Copying the failed query and executing it manually after adding PRECISION works. Has anyone encountered this before and is there a fix, or is this actually a bug?

The ticket is [PLAT-5067]