[
https://issues.apache.org/jira/browse/CASSANDRA-15194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16878040#comment-16878040
]
Benedict commented on CASSANDRA-15194:
--------------------------------------
> yet auto-uncapitalizes unquoted things
Wow, I did not know that. How awful. Perhaps we should separately at least
fix this for select queries so that, if a capitalised column exists, it selects
it. This seems strictly superior behaviour, though I guess you could have
weird schema where case determines the field. I'm sure we could have a safe
migration here, if we wanted, and it seems like a silly behaviour right now.
However, I'm not sure this is a huge problem here, since we're likely to mostly
be using "select *" I'd guess?
The problem is the other options are all even worse AFAICT, since {{mbs}} has
an ambiguous meaning, as a lowercase {{b}} can be interpreted either as bits or
bytes (and is I think non-standard for either). Though we have generally
interpreted it as bytes on this project, it's not great to continue the
ambiguity.
> Improve readability of Table metrics Virtual tables units
> ---------------------------------------------------------
>
> Key: CASSANDRA-15194
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15194
> Project: Cassandra
> Issue Type: Bug
> Components: Feature/Virtual Tables
> Reporter: Jon Haddad
> Assignee: Chris Lohfink
> Priority: Normal
>
> I just noticed this strange output in the coordinator_reads output::
> {code}
> cqlsh:system_views> select * from coordinator_reads ;
> count | keyspace_name | table_name | 99th | max |
> median | per_second
> -------+--------------------+--------------------------------+------+-----+--------+------------
> 7573 | tlp_stress | keyvalue | 0 | 0 |
> 0 | 2.2375e-16
> 6076 | tlp_stress | random_access | 0 | 0 |
> 0 | 7.4126e-12
> 390 | tlp_stress | sensor_data_udt | 0 | 0 |
> 0 | 1.7721e-64
> 30 | system | local | 0 | 0 |
> 0 | 0.006406
> 11 | system_schema | columns | 0 | 0 |
> 0 | 1.1192e-16
> 11 | system_schema | indexes | 0 | 0 |
> 0 | 1.1192e-16
> 11 | system_schema | tables | 0 | 0 |
> 0 | 1.1192e-16
> 11 | system_schema | views | 0 | 0 |
> 0 | 1.1192e-16
> {code}
> cc [~cnlwsu]
> btw I realize the output is technically correct, but it's not very readable.
> For practical purposes this should just say 0.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
