Simple distinct query don't supported

[Angel-Ponce]

Simple distinct query don't supported

[griffio]

1. How to access to the snapshot with the solution?

change build config to https://cashapp.github.io/sqldelight/2.0.2/#snapshots using 2.1.0-SNAPSHOT

2. Excuse me, my wrong, my type column it's timestamptz so, it's still working with DATE_TRUNC func.

Works with 2.1.0-SNAPSHOT

CREATE TABLE ProductUpdateDb(
    issue_close_date_iso TIMESTAMPTZ
);

selectDistinctLocalDate:
SELECT DISTINCT DATE_TRUNC('month', issue_close_date_iso)  AS local_date
FROM ProductUpdateDb
ORDER BY local_date DESC;

3. This si the reason of why I currently casting the convertion to the Date type

I will create a PR to fix DATE_TRUNC as it should allow the Date type

[griffio]

🤔 There are two issues here, I think.

1. SELECT DISTINCT was broken in 2.0.2 and is fixed in current snapshot #5172 - or go back to use version 2.0.0 for SELECT DISTINCT
2. Using DATE_TRUNC with DATE breaks and currently only works for TIMESTAMP_TIMEZONE, TIMESTAMP types - this is incorrect the docs says that DATE is automatically cast https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

So 2. needs an issue to fix this (unless you can use a TIMESTAMP)

sqldelight/dialects/postgresql/src/main/kotlin/app/cash/sqldelight/dialects/postgresql/PostgreSqlTypeResolver.kt

Line 137 in 50551cc

"date_trunc" -> encapsulatingType(exprList, TIMESTAMP_TIMEZONE, TIMESTAMP)

[Angel-Ponce]

🤔 There are two issues here, I think.

1. SELECT DISTINCT was broken in 2.0.2 and is fixed in current snapshot SELECT DISTINCT syntax no longer works #5172 - or go back to use version 2.0.0 for SELECT DISTINCT
2. Using DATE_TRUNC with DATE breaks and currently only works for TIMESTAMP_TIMEZONE, TIMESTAMP types - this is incorrect the docs says that DATE is automatically cast https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

So 2. needs an issue to fix this (unless you can use a TIMESTAMP)

sqldelight/dialects/postgresql/src/main/kotlin/app/cash/sqldelight/dialects/postgresql/PostgreSqlTypeResolver.kt

Line 137 in 50551cc

"date_trunc" -> encapsulatingType(exprList, TIMESTAMP_TIMEZONE, TIMESTAMP)

1. How to access to the snapshot with the solution?

2. Excuse me, my wrong, my type column it's timestamptz so, it's still working with DATE_TRUNC func.

3. This si the reason of why I currently casting the convertion to the Date type

[Angel-Ponce]

🤔 I will try with the snapshot recommended, thank you so much for the quickly answers.