You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "JiekerTime (via GitHub)" <gi...@apache.org> on 2023/03/15 03:33:44 UTC
[GitHub] [shardingsphere] JiekerTime opened a new issue, #24607: opengauss statement compatibility issues
JiekerTime opened a new issue, #24607:
URL: https://github.com/apache/shardingsphere/issues/24607
### Which version of ShardingSphere did you use?
master
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
proxy
<img width="404" alt="image" src="https://user-images.githubusercontent.com/76552510/225199243-232c1d8a-ba94-499e-a8ea-8f99fcd1d3d1.png">
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #24607: opengauss statement compatibility issues
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #24607:
URL: https://github.com/apache/shardingsphere/issues/24607#issuecomment-1475510012
These are different questions.
1. PostgreSQL/openGauss string is quoted by single quote.
2. `pg_catalog` is not fully supported.
--
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
[GitHub] [shardingsphere] JiekerTime commented on issue #24607: opengauss statement compatibility issues
Posted by "JiekerTime (via GitHub)" <gi...@apache.org>.
JiekerTime commented on issue #24607:
URL: https://github.com/apache/shardingsphere/issues/24607#issuecomment-1479325119
> These are different questions.
>
> 1. PostgreSQL/openGauss string is quoted by single quote.
> 2. `pg_catalog` is not fully supported.
Sorry for my poor familiarity with OpenGauss syntax, but doesn't this go against our [DATABASE GATEWAY](https://shardingsphere.apache.org/document/5.2.1/en/reference/gateway/) mindset? I think this might be a question worth discussing.
--
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
[GitHub] [shardingsphere] JiekerTime closed issue #24607: opengauss statement compatibility issues
Posted by "JiekerTime (via GitHub)" <gi...@apache.org>.
JiekerTime closed issue #24607: opengauss statement compatibility issues
URL: https://github.com/apache/shardingsphere/issues/24607
--
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
[GitHub] [shardingsphere] strongduanmu commented on issue #24607: opengauss statement compatibility issues
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #24607:
URL: https://github.com/apache/shardingsphere/issues/24607#issuecomment-1475520618
Hi @JiekerTime, currently, the system tables implemented by ShardingSphere are not real-time, and are executed every 30s. Also, `\d table` is not supported yet, are you interested in submitting a PR to support it?
--
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
[GitHub] [shardingsphere] JiekerTime commented on issue #24607: opengauss statement compatibility issues
Posted by "JiekerTime (via GitHub)" <gi...@apache.org>.
JiekerTime commented on issue #24607:
URL: https://github.com/apache/shardingsphere/issues/24607#issuecomment-1489835766
The context is understood, I will try to support \d tableName and try to support singleton mode
--
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
[GitHub] [shardingsphere] JiekerTime commented on issue #24607: opengauss statement compatibility issues
Posted by "JiekerTime (via GitHub)" <gi...@apache.org>.
JiekerTime commented on issue #24607:
URL: https://github.com/apache/shardingsphere/issues/24607#issuecomment-1479051582
> Hi @JiekerTime, currently, the system tables implemented by ShardingSphere are not real-time, and are executed every 30s. Also, `\d table` is not supported yet, are you interested in submitting a PR to support it?
I've been watching og's system-related syntax for a long time lately, and I'm speculating on the principles of its proper implementation. I have very little time, but if I work it out, I'll submit a PR. Besides, I'm more focused on this feature, and it would be best if a strong community could solve this problem.
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #24607: opengauss statement compatibility issues
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #24607:
URL: https://github.com/apache/shardingsphere/issues/24607#issuecomment-1480750731
> > These are different questions.
> >
> > 1. PostgreSQL/openGauss string is quoted by single quote.
> > 2. `pg_catalog` is not fully supported.
>
> Sorry for my poor familiarity with OpenGauss syntax, but doesn't this go against our [DATABASE GATEWAY](https://shardingsphere.apache.org/document/5.2.1/en/reference/gateway/) mindset? I think this might be a question worth discussing.
I think the Database gateway means you may send PostgreSQL dialect via PostgreSQL client, and the Proxy will convert dialect in backend to access MySQL database. It doesn't mean you can send MySQL dialect via PostgreSQL client.
--
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