sqldelight icon indicating copy to clipboard operation
sqldelight copied to clipboard

Aliases don't work in WHERE predicates

Open slipdef opened this issue 2 years ago • 2 comments

SQLDelight Version

1.5.3

Operating System

Windows 10

Gradle Version

7.2.0

Kotlin Version

1.6

Dialect

SQLite

AGP Version

No response

Describe the Bug

SELECT datetime('now') AS date WHERE date IS NOT NULL should work

Currently compiler says "NO column found with name date"

Stacktrace

No response

Gradle Build Script

No response

slipdef avatar Aug 22 '22 17:08 slipdef

That's probably fixed in 2.0.0-alpha03, have you tried it?

vanniktech avatar Aug 22 '22 18:08 vanniktech

Nope, migrating to a new major version is not something that we could do now.

slipdef avatar Aug 22 '22 18:08 slipdef

I can confirm this is fixed in the 2.0.0 release

Nek-12 avatar Apr 18 '23 10:04 Nek-12