Export to GitHub

sqlite-jdbc - issue #24

Sorting using Big Decimal columns in Sqlite


Posted on Mar 19, 2012 by Happy Hippo

What steps will reproduce the problem? 1. Create the table in sqlite using create table test (v1,v2) without mentioning the data types. 2.Insert big decimal values in to the table using setObject or setBigDecimal. 3.Sort the table using the column which has Big Decimal values.

What is the expected output? What do you see instead? Expected output is to see the numeric sorting rather we see the data sorted using string sorting as bigdecimal data is stored internally as String.

What version of the product are you using? On what operating system? sqlite-jdbc-3.7.8-20111025.014814-1.jar both windows/Linux

Please provide any additional information below.

Status: New

Labels:
Type-Defect Priority-Medium AffectedVersion-3.7.x FixedVersion-NA