[CASSANDRA-11233] COPY TO Column of Type Double Precision gets Truncated to lesser precision

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Not A Problem
• Component/s: Legacy/CQL
• Labels: cqlsh

Environment

[cqlsh 5.0.1 | Cassandra 2.1.11.908 | DSE 4.8.2 | CQL spec 3.2.1 | Native protocol v3]

• Severity: Normal
• Assignee: Unassigned
• Reporter: Jason Walkowicz
• Created: 25/Feb/16 16:01
• Updated: 16/Apr/19 09:30
• Resolved: 25/Feb/16 17:05

Description

I am copying a table between two exact table configs but different names with the CQLSH COPY command.

Example:

COPY "my"."data"(number) TO 'export.csv';
COPY "my"."datacopy"(number) FROM 'export.csv';

The column i'm copying TO and FROM is of type double. The problem is it appears that the copy is truncating the precision of the column.

For example:

Original Data:
5.084936038014788E8

After Copy
5.0849E8