The type of the "coalesce(..., 0)" expression is Long? instead of Long

[Egorand]

SQLDelight Version

2.0.1

Operating System

macOS 14.2.1

Gradle Version

8.3

Kotlin Version

1.9.20

Dialect

SQLite

AGP Version

No response

Describe the Bug

In one of our VIEWs, we have a column calculated as follows:

coalesce(fee, (SELECT fee FROM someConfig), 0) AS fee

In SQLDelight 2.0.0, the type of this column was Long, and in 2.0.1 it changed to Long?. Long seems to make more sense here, given that the value is coalesced to 0, so it should never be null. By looking at the changelog for 2.0.1, it seems that #4517 might've introduced this regression.

Stacktrace

No response

Gradle Build Script

No response

[JakeWharton]

Fixed by #4882