Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 6 Sep 2011 21:53:10 +0000 (UTC)
From: "Rick Shaw (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: 
 <1373813873.22488.1315345990652.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <503064357.4774.1310437740022.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (CASSANDRA-2883) Add Support for BigDecimal Java
 data type as the "DecimalType" AbstractType
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-2883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13098398#comment-13098398 ] 

Rick Shaw commented on CASSANDRA-2883:
--------------------------------------

I store a full 32 bit integer encoding for the scale part of the data into C*, which is what the Java class {{BigDecimal}} supports. but for a scale factor that is crazy huge. I could easily be talked into using just a byte to support 128 or 256 scale. that is still 256 digits after the decimal... The unscaled value is stored like {{IntegerType}}.

> Add Support for BigDecimal Java data type as the "DecimalType" AbstractType
> ---------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2883
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2883
>             Project: Cassandra
>          Issue Type: Sub-task
>          Components: Core
>    Affects Versions: 0.8.1
>            Reporter: Rick Shaw
>            Assignee: Rick Shaw
>            Priority: Trivial
>              Labels: CQL, JDBC,, lhf
>             Fix For: 0.8.6
>
>         Attachments: add-decimaltype-v1.txt
>
>
> The JDBC Driver suite needs support for {{BigDecimal}} to complete it's data type support for {{ResultSet}} and {{PreparedStatement}}. This datatype could also be used to represent numeric (non-integer) counter values. This is a very simple addition to the collection of data types supported by Cassandra. It is quite versatile like {{BigInteger}}. It can represent decimal numbers of virtually any precision and scale. It is represented in Java as an arbitrary precision integer unscaled value ( think {{IntegerType}} )and a 32-bit integer scale factor, which could be represented as a {{IntegerType}} as well. This could share much of the logic from the {{BigInteger}} ({{IntegerType}}) implementation. 
> CQL would need to add a datatype (decimal?). Decimal literal support is already provided in CQL.
> This is low hanging fruit.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira