Bug #87595 mysqlsh --json output shows "info" but default output not
Submitted: 30 Aug 2017 7:08 Modified: 11 May 2018 19:40
Reporter: Shahriyar Rzayev Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Document Store: MySQL Shell Severity:S3 (Non-critical)
Version:8.0.0 OS:CentOS (7)
Assigned to: CPU Architecture:Any

[30 Aug 2017 7:08] Shahriyar Rzayev
Description:
Hi,

The output differs like this:

$ mysqlsh root:@localhost/generated_columns_test --py --interactive --execute "db.get_collections()"
Creating a Session to 'root@localhost/generated_columns_test'
Your MySQL connection id is 74 (X protocol)
Server version: 5.7.19-17-debug MySQL Community Server (GPL)
Default schema `generated_columns_test` accessible through db.
[
    <Collection:test_coll>,
    <Collection:test_coll1>,
    <Collection:test_coll10>,
    <Collection:test_coll11>,
    <Collection:test_coll12>,
    <Collection:test_coll13>,
    <Collection:test_coll14>,
    <Collection:test_coll15>,
    <Collection:test_coll16>,
    <Collection:test_coll17>,
    <Collection:test_coll18>,
    <Collection:test_coll19>,
    <Collection:test_coll2>,
    <Collection:test_coll20>,
    <Collection:test_coll3>,
    <Collection:test_coll4>,
    <Collection:test_coll5>,
    <Collection:test_coll6>,
    <Collection:test_coll7>,
    <Collection:test_coll8>,
    <Collection:test_coll9>
]

$ mysqlsh root:@localhost/generated_columns_test --py --json --interactive --execute "db.get_collections()"
{
    "info": "Creating a Session to 'root@localhost/generated_columns_test'"
}
{
    "info": "Your MySQL connection id is 75 (X protocol) Server version: 5.7.19-17-debug MySQL Community Server (GPL) Default schema `generated_columns_test` accessible through db."
}
[
    {
        "class": "Collection",
        "name": "test_coll"
    },
    {
        "class": "Collection",
        "name": "test_coll1"
    },

According to json output the original output should be something like:

$ mysqlsh root:@localhost/generated_columns_test --py --interactive --execute "db.get_collections()"
INFO: Creating a Session to 'root@localhost/generated_columns_test'
INFO: Your MySQL connection id is 74 (X protocol)
INFO: Server version: 5.7.19-17-debug MySQL Community Server (GPL)
INFO: Default schema `generated_columns_test` accessible through db.

How to repeat:
See description
[30 Aug 2017 7:50] MySQL Verification Team
Hello Shahriyar,

Thank you for the report.

Thanks,
Umesh
[11 May 2018 19:41] Hema Sridharan
[Dev Team}
JSON requires a series of key/value pairs so we agreed on adding the "keys"
mentioned above to create the desired JSON.
 
Changing the shell output to match the JSON output is not an option