Crash when extracting Date type data from DB

stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.

MIT License

9.73k stars 1.57k forks source link

Crash when extracting Date type data from DB #1136

Open ankitagg-ms opened 2 years ago

ankitagg-ms commented 2 years ago

Top Statement from crash logs static (extension in SQLite):Foundation.Date.fromDatatypeValue(Swift.String) -> Foundation.Date

Build Information

version 0.13.3
Xcode used 13.2.1
Os version iOs 14+
How do do you integrate SQLite.swift in your project?
- CocoaPods

General guidelines

app Crashing for some user while extracting Date data from DB.
Start happening after upgrading to version 0.13.3

jberkel commented 2 years ago

Looks like there's an unexpected date format in the database. Could you get the value of the row using the debugger?

ankitagg-ms commented 2 years ago

This crash is happening for user in production app and hence can not check the value with debugger attach.

We have multiple date variable in our DB and they are coming from server and nothing has changed recently with our format. More ever, this is working for user on mac.

As per user, this started happening with latest update where we update sqlite version to 0.13.3.

Not sure if something was changed there for iOS framework.

jberkel commented 2 years ago

From which version did you update?

ankitagg-ms commented 2 years ago

from version 0.13.2

ankitagg-ms commented 2 years ago

And for reference. Date format we use is this 2022-03-24T00:00:00.000