RaigorJiang opened a new issue #12168:
URL: https://github.com/apache/shardingsphere/issues/12168


   Hi community,
   
   I found that the column names of some response results from DIstSQL are not 
uniform, and some adjustments are needed, such as
   #### Case:
   `show databases`:  the column name `SCHEMA_NAME` is all uppercase
   ```sql
   mysql> show databases; 
   +-------------+
   | SCHEMA_NAME |
   +-------------+
   | sharding_db |
   +-------------+
   ```
   
   `show tables`: the column name `Tables_in_%s` is just like what in MySQL.
   mysql> show tables;
   +-----------------------+
   | Tables_in_sharding_db |
   +-----------------------+
   | t_order_item_0        |
   | t_order_item_1        |
   +-----------------------+
   
   
   #### Format:
   `preview SQL`: the  column name `datasource_name` is not standardized, 
`data` and  `source` should be two words
   ```sql
   mysql> preview select * from t_order;
   +-----------------+-----------------------+
   | datasource_name | sql                   |
   +-----------------+-----------------------+
   | ds_0            | select * from t_order |
   | ds_1            | select * from t_order |
   +-----------------+-----------------------+
   ```
   
   
   Therefore, it is necessary to check the results of all 
[RQL](https://shardingsphere.apache.org/document/current/en/features/dist-sql/syntax/rql/)
 and 
[RAL](https://shardingsphere.apache.org/document/current/en/features/dist-sql/syntax/ral/ral/)
 statements, If anyone is interested, please comment in this issue, thank you.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to