Bug 394913 - SQLite: Incorrect display of large unsigned int (>0x7FFFFFFF)
Summary: SQLite: Incorrect display of large unsigned int (>0x7FFFFFFF)
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 3.1.0
Platform: Other Linux
: HI normal
Target Milestone: 3.2
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-06-01 06:54 UTC by Adam Pigg
Modified: 2018-12-15 22:58 UTC (History)
3 users (show)

See Also:
Latest Commit: https://commits.kde.org/kdb/bc5a7bea6e12892930e2e02ae3cc1c6d2b27277f
Version Fixed In:
Sentry Crash Report:

Attachments
Test file (11.00 KB, application/x-kexiproject-sqlite2)
2018-06-09 20:51 UTC, Jarosław Staniek 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Adam Pigg 2018-06-01 06:54:17 UTC 
for a field type of unsigned int, KEXI table view incorrectly displays large values as a nagative integer.  example, 3464731077 displays as a nagative value.
Comment 1 Jarosław Staniek 2018-06-09 20:51:30 UTC 
Created attachment 113178 [details]
Test file

Test db:
1. Bug reproduces by showing incorrect values:
-2147483648 instead of 2147483648 (0x80000000)
-830236219 instead of 3464731077

2147483647 shows OK (0x7FFFFFFF)

2. After fixing (as expected):

2147483648 shows OK
3464731077 shows OK
Comment 2 Jarosław Staniek 2018-06-09 22:01:47 UTC 
Git commit bc5a7bea6e12892930e2e02ae3cc1c6d2b27277f by Jaroslaw Staniek.
Committed on 09/06/2018 at 22:01.
Pushed by staniek into branch '3.1'.

SQLite Fix loading value Incorrect display of large unsigned int (>0x7FFFFFFF)

Summary: BUG:394913

Test Plan: Follow test case: https://bugs.kde.org/show_bug.cgi?id=394913#c

Reviewers: piggz

Reviewed By: piggz

Subscribers: Kexi-Devel-list

Tags: #kdb

Differential Revision: https://phabricator.kde.org/D13448

M  +4    -2    src/drivers/sqlite/SqliteCursor.cpp

https://commits.kde.org/kdb/bc5a7bea6e12892930e2e02ae3cc1c6d2b27277f