Mysql 8 on Debian, with Galera 4.
mysql> select capabilities,view_seqno from wsrep_cluster;
+--------------+------------+
| capabilities | view_seqno |
+--------------+------------+
| 184703 | 277 |
+--------------+------------+
1 row in set (0.00 sec)
Works fine, but when I want the vertical output...
mysql> select capabilities,view_seqno from wsrep_cluster \G;
*************************** 1. row ***************************
capabilities: 184703
view_seqno: 277
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
Why the error "no query specified" appear?
select capabilities,view_seqno from wsrep_cluster \G;
You have executed two queries. The first ends with the \G
. The second ends with the semicolon. The contents of the second query are the empty string.