[
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)
