After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 759792 - int64 (aka bigint) is not supported
int64 (aka bigint) is not supported
Status: RESOLVED OBSOLETE
Product: libgda
Classification: Other
Component: SQLite provider
unspecified
Other Linux
: Normal normal
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks:
 
 
Reported: 2015-12-23 01:52 UTC by Lucas Baudin
Modified: 2018-09-21 13:50 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
patch to expose the problem (4.79 KB, patch)
2015-12-23 14:09 UTC, Lucas Baudin 		none Details | Review
patch that oddly fix the bug (1.21 KB, patch)
2015-12-23 14:13 UTC, Lucas Baudin 		none Details | Review

Description Lucas Baudin 2015-12-23 01:52:24 UTC 
libgda does not seem to be able to understand values bigger than 2^31. Using the vala example [1] with a database containing a BIGINT column, it only displays
### instead of actual numbers (numbres < 2^31 work fine). With the gda browser, I get some 0 (which is wrong). It works fine with sqlite3 directly, or with sqliteman.

[1] https://wiki.gnome.org/Projects/Vala/GDA
Comment 1 Lucas Baudin 2015-12-23 14:08:40 UTC 
Here is a patch that adds a unit test which shows the problem.
Comment 2 Lucas Baudin 2015-12-23 14:09:38 UTC 
Created attachment 317815 [details] [review]
patch to expose the problem
Comment 3 Lucas Baudin 2015-12-23 14:11:13 UTC 
And now a patch to solve the problem - however while it indeed fixes the issue here, it definitively looks wrong (as in it should not happen this way). As I'm not familiar with the code, someone more experienced with the internals of libgda should look at it/explain me why is going wrong here.
Comment 4 Lucas Baudin 2015-12-23 14:13:35 UTC 
Created attachment 317816 [details] [review]
patch that oddly fix the bug
Comment 5 GNOME Infrastructure Team 2018-09-21 13:50:43 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/libgda/issues/86.