QGIS » QGIS Application

The attributes window truncates integral values to 32 bits and query tool only compares those 32 bits even though the underlying spatialite table contains 64 bit ones, the layer properties lists the columns as `qlonglong` (in the below example, it will show them as text, but when they are actually declared integer, it will do that) and the database manager shows full 64 bits. I have not tried whether other data providers have the same problem or not.

To reproduce, open the db manager and select something like

select (1<<63) as a, (1<<32) as b, (1<<32)-1 as c, GeomFromText('POINT(1 2)') as d

(it does not seem possible to import data-only layer from db manager). The db manager will show correct results of

-9223372036854775808 | 4294967296 | 4294967295

but when you load it as layer, the properties window will show it as

0 | 0 | -1