You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/30 04:20:36 UTC
[GitHub] [shardingsphere] TeslaCN opened a new issue, #22519: PostgreSQL SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
TeslaCN opened a new issue, #22519:
URL: https://github.com/apache/shardingsphere/issues/22519
## Bug Report
### Which version of ShardingSphere did you use?
master - 935a8108a6e411cab79c7861fe1d7315d27f941c
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy PostgreSQL
### Expected behavior
SQL could be parsed.
### Actual behavior
![image](https://user-images.githubusercontent.com/20503072/204706493-7afc1aa2-9d77-4b5c-adbd-6efa560e30f8.png)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
No rule configured.
```sql
SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
```
--
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 #22519: Failed to parse PostgreSQL SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22519:
URL: https://github.com/apache/shardingsphere/issues/22519#issuecomment-1364975812
This could be reproduced by `select int4 '1'`
--
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 #22519: Failed to parse PostgreSQL SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22519:
URL: https://github.com/apache/shardingsphere/issues/22519#issuecomment-1376672611
This blocked testing ShardingSphere-Proxy PostgreSQL by pg_regress.
--
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 #22519: Failed to parse PostgreSQL SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22519:
URL: https://github.com/apache/shardingsphere/issues/22519#issuecomment-1364977280
About type cast could be found here:
* https://www.postgresql.org/docs/15/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS
* https://www.postgresql.org/docs/15/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS-GENERIC
--
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 closed issue #22519: Failed to parse PostgreSQL SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #22519: Failed to parse PostgreSQL SELECT i.f1, i.f1 - int4 '2' AS x FROM INT2_TBL i
URL: https://github.com/apache/shardingsphere/issues/22519
--
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