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/10/10 06:41:25 UTC
[GitHub] [shardingsphere] wrs1226 opened a new issue, #16841: Parser engine‘s compatible issues with oracle
wrs1226 opened a new issue, #16841:
URL: https://github.com/apache/shardingsphere/issues/16841
Problem details：
1、 SQL generated by hibernate‘s Session.get(cls,id)：
select sysuser0_.id as id1_63_1_, sysuser0_.create_datetime as create_d2_63_1_, sysuser0_.creator as creator3_63_1_, sysuser0_.deleted as deleted4_63_1_, sysuser0_.remark as remark5_63_1_, sysuser0_.serial_number as serial_n6_63_1_, sysuser0_.update_datetime as update_d7_63_1_, sysuser0_.updater as updater8_63_1_, sysuser0_.AREA as AREA9_63_1_, sysuser0_.DEGREES as DEGREES10_63_1_, sysuser0_.department_id as departm11_63_1_, sysuser0_.ENDVALIDDATE as ENDVALI12_63_1_, sysuser0_.ESOP_ACCOUNT as ESOP_AC13_63_1_, sysuser0_.is_enabled as is_enab14_63_1_, sysuser0_.is_locked as is_lock15_63_1_, sysuser0_.MAIL as MAIL16_63_1_, sysuser0_.MOBILE as MOBILE17_63_1_, sysuser0_.POSITION as POSITIO18_63_1_, sysuser0_.SAVE_LEVEL as SAVE_LE19_63_1_, sysuser0_.SEC_LEVEL as SEC_LEV20_63_1_, sysuser0_.STVALIDDATE as STVALID21_63_1_, sysuser0_.userDetail_id as userDet30_63_1_, sysuser0_.TOTAL_SPACE as TOTAL_S22_63_1_, sysuser0_.TYPE as TYPE23_63_1_, sysuser0_.UNITID as UNITID24_63_1_, sysuser0_.user_
account as user_ac25_63_1_, sysuser0_.user_name as user_na26_63_1_, sysuser0_.user_password as user_pa27_63_1_, sysuser0_.USERTYPE as USERTYP28_63_1_, sysuser0_.WORKLIFES as WORKLIF29_63_1_, sysuserdet1_.id as id1_65_0_, sysuserdet1_.create_datetime as create_d2_65_0_, sysuserdet1_.creator as creator3_65_0_, sysuserdet1_.deleted as deleted4_65_0_, sysuserdet1_.remark as remark5_65_0_, sysuserdet1_.serial_number as serial_n6_65_0_, sysuserdet1_.update_datetime as update_d7_65_0_, sysuserdet1_.updater as updater8_65_0_, sysuserdet1_.address as address9_65_0_, sysuserdet1_.birthday as birthda10_65_0_, sysuserdet1_.department as departm11_65_0_, sysuserdet1_.email as email12_65_0_, sysuserdet1_.mobilePhone as mobileP13_65_0_, sysuserdet1_.telephone as telepho14_65_0_, sysuserdet1_.university as univers15_65_0_ from sys_user sysuser0_ left outer join sys_userdetail sysuserdet1_ on sysuser0_.userDetail_id=sysuserdet1_.id where sysuser0_.id=?
2、 In oracle‘s parser , parser engine‘‘s parser throw exception , It was parser for the second time
On line 10 of the OracleStatementParser’s selectSubquery() code：getInterpreter().adaptivePredict(_input,54,_ctx) It cannot get an explicit type
3、 On line 393 of the ParserATNSimulator's adaptivePredict(_input,54,_ctx) code：int alt = execATN(dfa, s0, input, index, outerContext); It cannot get an explicit type and throw NoViableAltException e = noViableAlt(input, outerContext, previousD.configs, startIndex);
4、The last of program's 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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1101231357
I'll check 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] wrs1226 commented on issue #16841: Parser engine 兼容oracle问题
Posted by GitBox <gi...@apache.org>.
wrs1226 commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1099804188
> Hi @wrs1226, thank you for your feedback, and can you translate this issue to english?
不好意思，英语不好
--
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] github-actions[bot] closed issue #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #16841: Parser engine‘s compatible issues with oracle
URL: https://github.com/apache/shardingsphere/issues/16841
--
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 #16841: Parser engine 兼容oracle问题
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1099806160
@wrs1226 You can try to translate this issue with some util, such as google translate.
--
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 #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1182739437
Is there anyone interested to solve this issue?
--
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
Re: [I] Parser engine‘s compatible issues with oracle [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-2026020682
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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 #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1182738315
It's because of the word `POSITION`.
You can use "POSITION" instead.
@wrs1226
--
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 #16841: Parser engine 兼容oracle问题
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1099795085
Hi @wrs1226, thank you for your feedback, and can you translate this issue to english?
--
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] sgunadhya commented on issue #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
sgunadhya commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1194509360
I am interested in solving this issue. I need guidance on how to solve 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] wrs1226 commented on issue #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
wrs1226 commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1099817112
> @wrs1226 You can try to translate this issue with some util, such as google translate.
嗯嗯 翻译了一下
--
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] AllyKaz commented on issue #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
AllyKaz commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1218061362
Having looked at this, I don't think there's an issue to solve. The double parsing is the consequence of an optimisation that first attempts to parse with a faster, but less powerful algorithm (SLL), that either returns a correct parse tree or throws an error which may, or may not, indicated that there's a actual syntax error or it requires the more powerful LL algorithm.
Consequently, given the use of POSITION is a syntax error, the double parsing is a necessary and unavoidable part of the optimisation. Maybe the optimisation could be improved on, but I don't see this behaviour as necessitating that, and that's probably a bit much for good first issue.
[https://tomassetti.me/improving-the-performance-of-an-antlr-parser/](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] github-actions[bot] commented on issue #16841: Parser engine‘s compatible issues with oracle
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #16841:
URL: https://github.com/apache/shardingsphere/issues/16841#issuecomment-1272350004
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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