[
https://issues.apache.org/jira/browse/CASSANDRA-11092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15189887#comment-15189887
]
Tyler Hobbs commented on CASSANDRA-11092:
-----------------------------------------
+1 with one nit that can be fixed when committing: you can just build
{{formatted_names}} before checking for empty rows and use it either way.
> EXPAND breaks when the result has 0 rows in cqlsh
> -------------------------------------------------
>
> Key: CASSANDRA-11092
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11092
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Reporter: Kishan Karunaratne
> Assignee: Yuki Morishita
> Priority: Trivial
> Labels: cqlsh
> Fix For: 2.2.x, 3.0.x, 3.x
>
>
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
