wrs1226 opened a new issue, #16841: URL: https://github.com/apache/shardingsphere/issues/16841
问题明细： 1、 hibernate‘s Session.get(cls,id)生成的SQL： 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、 经oracle‘s parser后进入parser engine 解析出现exception 后第二次parser  在OracleStatementParser’s selectSubquery() 大概line 4446 ’s code : getInterpreter().adaptivePredict(_input,54,_ctx)解析不出SQL属于哪个case  3、 ParserATNSimulator's adaptivePredict(_input,54,_ctx)解析不符合case，里面大概line 393 int alt = execATN(dfa, s0, input, index, outerContext); 抛NoViableAltException e = noViableAlt(input, outerContext, previousD.configs, startIndex);   4、最后抛错：  -- 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]
