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 2021/11/22 01:57:21 UTC

[GitHub] [shardingsphere] fengaixue opened a new issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

fengaixue opened a new issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728


   5.0.0 oracle 普通的insert into 语句为什么不能解析通过??
   
   [https://gitee.com/Sharding-Sphere/sharding-sphere/issues/I4IPJQ](url)


-- 
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] tuichenchuxin commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-976102776


   Parser is an independent model. If it's a parse error, may the actual sql is not that simple.


-- 
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 #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-975003472


   @fengaixue Can you translate this issue to english? And provide more information?


-- 
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] fengaixue commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-975117478


   Debug info: OracleStatementParser.insertSingleTable()
   
   switch case not match !!!  throw  NoviableAltException...
   
   
   
   
   
   


-- 
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] fengaixue commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-975116499


   Debug info: OracleStatementParser.insertSingleTable()
   
   switch case not match !!!  throw  NoviableAltException...
   
   
   


-- 
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] fengaixue commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-976100707


   Don't use unit tests!Combining with the druid-spring-boot-starter(1.2.6)、ojdbc8(12.2.0.1) and mybatis-spring-boot-starter(1.3.2)
   
   
   
   
   ------------------&nbsp;原始邮件&nbsp;------------------
   发件人:                                                                                                                        "apache/shardingsphere"                                                                                    ***@***.***&gt;;
   发送时间:&nbsp;2021年11月23日(星期二) 上午9:49
   ***@***.***&gt;;
   ***@***.******@***.***&gt;;
   主题:&nbsp;Re: [apache/shardingsphere] ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错 (Issue #13728)
   
   
   
   
   
    
   I use the same sql, it can parsed. Can you show me a demo to try?
    
   —
   You are receiving this because you were mentioned.
   Reply to this email directly, view it on GitHub, or unsubscribe.
   Triage notifications on the go with GitHub Mobile for iOS or Android.


-- 
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] terrymanu commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-997429258


   For English only


-- 
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] fengaixue commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-976106799


   4.1.1&nbsp;it can parsed,5.0.0&nbsp;can`t&nbsp;
   
   
   
   ------------------&nbsp;原始邮件&nbsp;------------------
   发件人: ***@***.***&gt;; 
   发送时间: 2021年11月23日(星期二) 上午10:11
   收件人: ***@***.***&gt;; 
   抄送: ***@***.***&gt;; ***@***.***&gt;; 
   主题: Re: [apache/shardingsphere] ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错 (Issue #13728)
   
   
   
   
   
    
   Parser is an independent model. If it's a parse error, may the actual sql is not that simple.
    
   —


-- 
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] fengaixue commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-975178748


   Already&nbsp;provided,&nbsp;&nbsp;I think it's enough !!!
   
   
   
   
   ------------------&nbsp;原始邮件&nbsp;------------------
   发件人:                                                                                                                        "apache/shardingsphere"                                                                                    ***@***.***&gt;;
   发送时间:&nbsp;2021年11月22日(星期一) 上午10:02
   ***@***.***&gt;;
   ***@***.******@***.***&gt;;
   主题:&nbsp;Re: [apache/shardingsphere] ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错 (Issue #13728)
   
   
   
   
   
    
   @fengaixue Can you translate this issue to english? And provide more information?
    
   —
   You are receiving this because you were mentioned.
   Reply to this email directly, view it on GitHub, or unsubscribe.
   Triage notifications on the go with GitHub Mobile for iOS or Android.


-- 
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] terrymanu closed issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728


   


-- 
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] tuichenchuxin commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-976096174


   I use the same sql, it can parsed. Can you show me a demo to try?


-- 
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] fengaixue removed a comment on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue removed a comment on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-975117478


   Debug info: OracleStatementParser.insertSingleTable()
   
   switch case not match !!!  throw  NoviableAltException...
   
   
   
   
   
   


-- 
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] fengaixue commented on issue #13728: ShardingSphere-jdbc 5.0 连接oracle时,insert into语句 SQL解析会报错

Posted by GitBox <gi...@apache.org>.
fengaixue commented on issue #13728:
URL: https://github.com/apache/shardingsphere/issues/13728#issuecomment-975097614


   Executor SQL: insert into t_order(id,user_id) values(1,1)
   
   SQLParsingException : You hava an error in your SQL syntax


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