stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.57k stars 1.54k forks source link

NUMERIC type in sqlite and value is 2.0, but return Int64. #1186

Open swanfly opened 1 year ago

swanfly commented 1 year ago

The data type of a column in the database is NUMERIC, and there is a row with a value of 2.0. After querying for row in try db.prepare ("SELECT * FROM xxx"), through 【row?[num] as! Double】cannot get the real value, finally we find your library return the wrong type of Int64.