[CASSANDRA-9224] Figure out a better default float precision rule for cqlsh

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.6, 2.2.0 rc1
• Component/s: Legacy/Tools
• Labels: cqlsh
• Assignee: Stefania Alborghetti
• Reporter: Tom Hobbs

Authors

Stefania Alborghetti

Reviewers

Tom Hobbs

• Created: 21/Apr/15 20:56
• Updated: 16/Apr/19 09:31
• Resolved: 22/May/15 22:44

Description

We currently use a DEFAULT_FLOAT_PRECISION of 5 in cqlsh with formatting '%.*g' % (float_precision, val). In practice, this is way too low. For example, 12345.5 will show up as 123456. Since the float precision is used for cqlsh's COPY TO, it's particularly important that we maintain as much precision as is practical by default.

There are some other tricky considerations, though. If the precision is too high, python will do something like this:

> '%.25g' % (12345.5555555555555555,)
'12345.55555555555474711582'

That's not terrible, but it would be nice to avoid if we can.

Issue Links

• links to: 2.1 patch
• links to: dtests