congzhou2603 commented on issue #25104:
URL: 
https://github.com/apache/shardingsphere/issues/25104#issuecomment-1514418755

   > > Hi, @strongduanmu , I check again about this question. This is the 
official description about the parameter in GaussDB. 
![image](https://user-images.githubusercontent.com/47752565/232693017-5dd8baa6-007b-4682-9d10-f643a28aeed7.png)
 
[https://support.huaweicloud.com/intl/zh-cn/distributed-devg-v2-opengauss/devg_02_0507.html](url)
   > > Here are some test cases for createForeignTable statement from 
`openGauss-server-master` - source code. 
![image](https://user-images.githubusercontent.com/47752565/232694339-bde7b76d-fe0c-404d-baf4-fbcb50889c81.png)
   > > If we input `create foreign table`sql without the parameter, the parse 
tree is generated like this. 
![image](https://user-images.githubusercontent.com/47752565/232695092-a941eca2-da84-40ad-a923-483b7104a80a.png)
 So I don't think `SERVER server_name` is an optional parameter.
   > 
   > Hi @congzhou2603, can you help check whether `server name` is an optional 
segement or not?
   
   Hi @strongduanmu @Netter99 I test this syntax by openGauss 5.0.0, `server 
name` is optional segment,here is the test result.
   
![image](https://user-images.githubusercontent.com/27768675/233031311-f13abbe3-e105-4792-a60a-a8dce94fc86e.png)
   And Here is the developer guide of creating foreign table.
   
![image](https://user-images.githubusercontent.com/27768675/233031910-1568d8c6-a4c5-477b-a9ef-63458069fe94.png)
   
   
https://docs.opengauss.org/zh/docs/5.0.0/docs/SQLReference/CREATE-FOREIGN-TABLE.html
   


-- 
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