Defined read query with CAST ie.
select columname, CAST (columname2 as INT) from tablename
returns NULL for the column with CAST, the same query in DB Browser return proper values
Defined read query with CAST ie.
select columname, CAST (columname2 as INT) from tablename
returns NULL for the column with CAST, the same query in DB Browser return proper values
Queries without cast work ok, but when SQLite returns REAL without comma - 50.0 (REAL) Flutter takes this value as INT 50