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