cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Hollingsworth (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-3016) CQL: double and float types do not seem to work properly
Date Thu, 11 Aug 2011 03:45:28 GMT
CQL: double and float types do not seem to work properly

                 Key: CASSANDRA-3016
             Project: Cassandra
          Issue Type: Bug
            Reporter: Matt Hollingsworth

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:

CREATE KEYSPACE test with strategy_class = 'SimpleStrategy' and strategy_options:replication_factor=1;

USE test;
    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.
For more information on JIRA, see:


View raw message