Description:
See below
How to repeat:
[root@mysql4 ~]# mysqlsh
Welcome to MySQL Shell 1.0.5-labs Development Preview
Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type '\help', '\h' or '\?' for help, type '\quit' or '\q' to exit.
Currently in JavaScript mode. Use \sql to switch to SQL mode and execute queries.
mysql-js> \c root@mysql4:3306
Creating a Session to 'root@mysql4:3306'
Enter password:
Classic Session successfully established. No default schema selected.
mysql-js> \sql
Switching to SQL mode... Commands end with ;
mysql-sql> show slave status for channel 'group_replication_recovery';
+----------------+-------------+-------------------------------+-------------+---------------+-----------------+---------------------+----------------------------------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+-------------+-------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------+----------------------+----------------------------+--------------------+
| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master | Master_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error | Last_SQL_Errno | Last_SQL_Error | Replicate_Ignore_Server_Ids | Master_Server_Id | Master_UUID | Master_Info_File | SQL_Delay | SQL_Remaining_Delay | Slave_SQL_Running_State | Master_Retry_Count | Master_Bind | Last_IO_Error_Timestamp | Last_SQL_Error_Timestamp | Master_SSL_Crl | Master_SSL_Crlpath | Retrieved_Gtid_Set | Executed_Gtid_Set | Auto_Position | Replicate_Rewrite_DB | Channel_Name | Master_TLS_Version |
+----------------+-------------+-------------------------------+-------------+---------------+-----------------+---------------------+----------------------------------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+-------------+-------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------+----------------------+----------------------------+--------------------+
| | <NULL> | mysql_innodb_cluster_rpl_user | 0 | 60 | | 4 | mysql4-relay-bin-group_replication_recovery.000001 | 4 | | No | No | | | | | | | 0 | | 0 | 0 | 496 | None | | 0 | No | | | | | | null | No | 0 | | 0 | | | 0 | | mysql.slave_master_info | 0 | null | | 1 | | | | | | | 50c0c583-862a-11e6-9515-08002718d305:1-16910,
5cb528ba-864d-11e6-87ae-08002718d305:1-7,
9446dd3f-8652-11e6-85dc-08002718d305:1-5 | 1 | | group_replication_recovery | |
+----------------+-------------+-------------------------------+-------------+---------------+-----------------+---------------------+----------------------------------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+-------------+-------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------+----------------------+----------------------------+--------------------+
1 row in set (0.00 sec)
mysql-sql> show slave status for channel 'group_replication_recovery'\G
...
... :-(
...
mysql-sql> select typo from typo tabl
... \c
... ;
ERROR: 1046 (3D000): No database selected
Suggested fix:
I would like to have support for \c \G ... when in SQL mode through the mysqlshell to make it usable.
Description: See below How to repeat: [root@mysql4 ~]# mysqlsh Welcome to MySQL Shell 1.0.5-labs Development Preview Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help', '\h' or '\?' for help, type '\quit' or '\q' to exit. Currently in JavaScript mode. Use \sql to switch to SQL mode and execute queries. mysql-js> \c root@mysql4:3306 Creating a Session to 'root@mysql4:3306' Enter password: Classic Session successfully established. No default schema selected. mysql-js> \sql Switching to SQL mode... Commands end with ; mysql-sql> show slave status for channel 'group_replication_recovery'; +----------------+-------------+-------------------------------+-------------+---------------+-----------------+---------------------+----------------------------------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+-------------+-------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------+----------------------+----------------------------+--------------------+ | Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master | Master_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error | Last_SQL_Errno | Last_SQL_Error | Replicate_Ignore_Server_Ids | Master_Server_Id | Master_UUID | Master_Info_File | SQL_Delay | SQL_Remaining_Delay | Slave_SQL_Running_State | Master_Retry_Count | Master_Bind | Last_IO_Error_Timestamp | Last_SQL_Error_Timestamp | Master_SSL_Crl | Master_SSL_Crlpath | Retrieved_Gtid_Set | Executed_Gtid_Set | Auto_Position | Replicate_Rewrite_DB | Channel_Name | Master_TLS_Version | +----------------+-------------+-------------------------------+-------------+---------------+-----------------+---------------------+----------------------------------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+-------------+-------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------+----------------------+----------------------------+--------------------+ | | <NULL> | mysql_innodb_cluster_rpl_user | 0 | 60 | | 4 | mysql4-relay-bin-group_replication_recovery.000001 | 4 | | No | No | | | | | | | 0 | | 0 | 0 | 496 | None | | 0 | No | | | | | | null | No | 0 | | 0 | | | 0 | | mysql.slave_master_info | 0 | null | | 1 | | | | | | | 50c0c583-862a-11e6-9515-08002718d305:1-16910, 5cb528ba-864d-11e6-87ae-08002718d305:1-7, 9446dd3f-8652-11e6-85dc-08002718d305:1-5 | 1 | | group_replication_recovery | | +----------------+-------------+-------------------------------+-------------+---------------+-----------------+---------------------+----------------------------------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+-------------+-------------------------+-----------+---------------------+-------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------+----------------------+----------------------------+--------------------+ 1 row in set (0.00 sec) mysql-sql> show slave status for channel 'group_replication_recovery'\G ... ... :-( ... mysql-sql> select typo from typo tabl ... \c ... ; ERROR: 1046 (3D000): No database selected Suggested fix: I would like to have support for \c \G ... when in SQL mode through the mysqlshell to make it usable.