Database Read and Write fail under iSO 18+ and macOS 15+

[hansengj]

v0.14.1 worked with previous versions of iOS and macOS. With app code base unchanged, running app under Xcode 16+, get database error trying to read from app's existing database or write to a created database. Upgraded to v0.15.3; same issues.

Failures on macMini M4 (macOS 15.3.2) and iPad Pro M2 (iOS 18.2).

NOTE: GRDB broke when iOS 18 was released. Authors said nothing could do until Apple fixed the issue. Under iOS 18.1, GRDB worked again. SQLite may have the same or a similar issue, namely, it is broken under the latest macOS and iOS versions.

v0.15.3 is a year old. Suggest compiling it under the latest Xcode, Swift 5 and test if still functional.

[hansengj]

The underlying issue is reported in Issue #1311, namely,
let id = Expression("id")
results in the id expression having the type String instead of Int.
Thus
t.column(id, primaryKey: true)
is translated to the query clause
"id" TEXT PRIMARY KEY NOT NULL
instead of
"id" INTEGER PRIMARY KEY NOT NULL

To correct this, changed let id to Expression(0), which resulted in a syntactially incorrect clause to be generated, thereby preventing a table from being created. This in turn caused the database read to fail.

Consider this issue closed and refer to Issue #1311 instead.