[jira] [Assigned] (CASSANDRA-3016) CQL: double and float types do not seem to work properly

["Jonathan Ellis (Assigned) (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-3016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis reassigned CASSANDRA-3016:
-----------------------------------------

    Assignee: paul cannon  (was: Tyler Hobbs)

Paul, is this still a problem w/ latest dbapi driver?  if so, can you create a ticket in that project?
                
> CQL: double and float types do not seem to work properly
> --------------------------------------------------------
>
>                 Key: CASSANDRA-3016
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3016
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Matt Hollingsworth
>            Assignee: paul cannon
>
> Was asked to make this from the mailing list by Jonathan Ellis.
> I'm just getting started with CQL, and decided to do a simple test create/insert/select thing to check that everything was working.  Most everything seems to work, but it appears that double/floats do not work properly.  Here's what I did:
> test.cql
> --------------------------
> CREATE KEYSPACE test with strategy_class = 'SimpleStrategy' and strategy_options:replication_factor=1;
> USE test;
> CREATE COLUMNFAMILY testvals (
>     key varchar PRIMARY KEY,
>     value float
>    );
> INSERT INTO testvals (key,value) VALUES ('k1',341.32355);
> SELECT key, value FROM testvals;
> --------------------------
> The output is this:
> cqlsh localhost < scripts/test.cql
>  key |    value |
>   k1 | @uU-B??? |
> Same thing happens when I do value double.  I also tried to do this from the python driver, gives the same weirdness:
> In [2]: import cql
> In [3]: con = cql.connect("localhost",keyspace="test")
> In [4]: cursor = con.cursor()
> In [5]: cursor.execute("SELECT * from testvals")
> Out[5]: True
> In [6]: for r in cursor: print r
>    ...: 
> [u'k1', '?\xf8\x00\x00\x00\x00\x00\x00']

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira