[CASSANDRA-11092] EXPAND breaks when the result has 0 rows in cqlsh

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.6, 3.0.5, 3.5
• Component/s: Legacy/Tools
• Labels: cqlsh
• Severity: Low
• Assignee: Yuki Morishita
• Reporter: Kishan Karunaratne

Authors

Yuki Morishita

Reviewers

Tom Hobbs

• Created: 29/Jan/16 02:43
• Updated: 16/Apr/19 09:30
• Resolved: 11/Mar/16 23:19

Description

cqlsh> EXPAND ON;
Now Expanded output is enabled
cqlsh> select * from system.local;

@ Row 1
-------------------------+---------------------------------------------
 key                     | local
 bootstrapped            | COMPLETED
 broadcast_address       | 127.0.0.1
 cluster_name            | dse_50_graph
 cql_version             | 3.4.0
 data_center             | Graph
 dse_version             | 5.0.0
 gossip_generation       | 1454032824
 graph                   | True
 host_id                 | ad30ccb2-04a1-4511-98b6-a72e4ea182c0
 listen_address          | 127.0.0.1
 native_protocol_version | 4
 partitioner             | org.apache.cassandra.dht.Murmur3Partitioner
 rack                    | rack1
 release_version         | 3.0.1.816
 rpc_address             | 127.0.0.1
 schema_version          | 5667501a-4ac3-3f00-ab35-9040efb927ad
 server_id               | A0-CE-C8-01-CC-CA
 thrift_version          | 20.1.0
 tokens                  | {'-9223372036854775808'}
 truncated_at            | null
 workload                | Cassandra

(1 rows)
cqlsh> select * from system.peers;

max() arg is an empty sequence
cqlsh> EXPAND OFF;
Disabled Expanded output.
cqlsh> select * from system.peers;

 peer | data_center | dse_version | graph | host_id | preferred_ip | rack | release_version | rpc_address | schema_version | server_id | tokens | workload
------+-------------+-------------+-------+---------+--------------+------+-----------------+-------------+----------------+-----------+--------+----------

(0 rows)