davidjanmercado / sqlite-jdbc

Automatically exported from code.google.com/p/sqlite-jdbc
Apache License 2.0
0 stars 0 forks source link

Sorting using Big Decimal columns in Sqlite #24

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
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.

Original issue reported on code.google.com by jkanthr...@gmail.com on 19 Mar 2012 at 7:39