Bug 394913

Summary:	SQLite: Incorrect display of large unsigned int (>0x7FFFFFFF)
Product:	[Applications] KEXI	Reporter:	Adam Pigg <adam>
Component:	Tables	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED FIXED
Severity:	normal	CC:	adam, inksi, staniek
Priority:	HI
Version:	3.1.0
Target Milestone:	3.2
Platform:	Other
OS:	Linux
Latest Commit:	https://commits.kde.org/kdb/bc5a7bea6e12892930e2e02ae3cc1c6d2b27277f	Version Fixed In:
Attachments:	Test file

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