cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lyuben Todorov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5274) Option to disable scientific notation in cqlsh
Date Wed, 13 Aug 2014 12:52:12 GMT

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

Lyuben Todorov commented on CASSANDRA-5274:
-------------------------------------------

AFAIK it only affects numbers with floating points (float and double cells). int / decimal
/ bigint / varint display the numbers fully. 
{noformat}
CREATE TABLE kz.cliffez
(
        run_id uuid PRIMARY KEY,
        check_points int,
        player_nick text,
        player_name ascii,
        run_lenght bigint,
        demo blob,
        pro15 boolean,
        record decimal,
        jump_count double,
        duck_count float,
        run_time timestamp,
        notes text,
        varintcol varint
);

INSERT INTO kz.cliffez (run_id, check_points,   notes,                             demo, 
                jump_count,           duck_count,             player_name,    player_nick,
 record,             run_time,       run_lenght,            varintcol) 
                VALUES (now(),  2147483647,     '41234124124312341234124123431242', textAsBlob('
  '),    24124213412.42134124, 2000199999999.99998,    'somename',     'somename2',  41234123412421421,
 1368438171000,  4334124312412343124,   312414123412341234123413241241234124123);

SELECT * FROM kz.cliffez ;  

 run_id                               | check_points | demo     | duck_count | jump_count
| notes                            | player_name | player_nick | pro15 | record          
 | run_lenght          | run_time                 | varintcol
--------------------------------------+--------------+----------+------------+------------+----------------------------------+-------------+-------------+-------+-------------------+---------------------+--------------------------+-----------------------------------------
 7f5089f0-22e4-11e4-a6ec-7711f872e20f |   2147483647 | 0x202020 | 2.0002e+12 | 2.4124e+10
| 41234124124312341234124123431242 |    somename |   somename2 |  null | 41234123412421421
| 4334124312412343124 | 2013-05-13 12:42:51+0300 | 312414123412341234123413241241234124123

(1 rows)
{noformat}

> Option to disable scientific notation in cqlsh
> ----------------------------------------------
>
>                 Key: CASSANDRA-5274
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5274
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.1.10, 1.2.1
>            Reporter: J.B. Langston
>            Assignee: Lyuben Todorov
>            Priority: Minor
>
> Currently cqlsh automatically displays large numbers using scientific notation. Customers
have requested the option to disable this.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message