[CASSANDRA-9813] cqlsh column header can be incorrect when no rows are returned

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.5, 3.0.3, 3.2
• Labels: cqlsh
• Severity: Normal
• Assignee: Adam Holmberg
• Reporter: Aleksey Yeschenko

Authors

Adam Holmberg

Reviewers

Ariel Weisberg

• Created: 15/Jul/15 13:51
• Updated: 16/Apr/19 09:31
• Resolved: 18/Dec/15 23:32

Description

Upon migration, we internally create a pair of surrogate clustering/regular columns for compact static tables. These shouldn't be exposed to the user.

That is, for the table

CREATE TABLE bar (k int, c int, PRIMARY KEY (k)) WITH COMPACT STORAGE;

SELECT * FROM bar should not be returning this result set:

cqlsh:test> select * from bar;

 c | column1 | k | value
---+---------+---+-------

(0 rows)

Should only contain the defined c and k columns.

Issue Links

• depends upon: CASSANDRA-10513 Update cqlsh for new driver execution API
• is duplicated by: CASSANDRA-9907 Select from compact storage table with no data in cqlsh shows incorrect columns on trunk