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

[via GitHub]

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-unsubscr...@shardingsphere.apache.org

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