Skip to content

Sorting using Big Decimal columns in Sqlite #24

@GoogleCodeExporter

Description

@GoogleCodeExporter
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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions