[GitHub] [shardingsphere] FlyingZC commented on issue #24662: [New Feature] Implement MySQL/PostgreSQL/openGauss system database query

["FlyingZC (via GitHub)" <gi...@apache.org>]

FlyingZC commented on issue #24662:
URL: https://github.com/apache/shardingsphere/issues/24662#issuecomment-1498368420

   @QiangYuan0828 Welcome!You can refer to this pr https://github.com/apache/shardingsphere/pull/24860.You can add the assertion file of the query result in this file `[test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema.xml](https://github.com/apache/shardingsphere/pull/24860/files#diff-8b14961db9bf22300f55762714e97c500c7d49ccc81569c640914e8d576ea6e2)`.
   <img width="865" alt="image" src="https://user-images.githubusercontent.com/19788130/230248671-1c4583e0-2e81-4d60-901b-3dda655d38e1.png">
   And the assertion file under `test/resources/cases/dql/dataset/db/` like this:
   <img width="843" alt="image" src="https://user-images.githubusercontent.com/19788130/230248889-8217228b-38f3-4bf9-8a30-8ab6feac41fd.png">
   You can use this naming convention to name assertion files `select_${databaseType}_${schemaName}_${tableName}`, like `select_mysql_information_schema_innodb_sys_fields.xml`.
   (https://github.com/apache/shardingsphere/pull/24860/files#diff-c0b1417064b31dfc42ca469c528d7643aca243172cdf85d76637935ce22e3c91)`
   
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org