View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004968 | SymmetricDS Pro | Bug | public | 2021-04-26 18:23 | 2023-10-01 23:46 |
| Reporter | elong | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.15.0 | Fixed in Version | 3.15.0 | ||
| Summary | 0004968: Oracle log miner SQL parser exception from backslash value | ||||
| Description | Upstream bug in jsql parser: https://github.com/JSQLParser/JSqlParser/issues/1173 See below SQL statement to reproduce it on Oracle with log mining. | ||||
| Steps To Reproduce | update PARAM_TBL set PARA_DESC = null where PARA_DESC = '\' and DEFAULT_VALUE = '\' Exception in thread "main" net.sf.jsqlparser.JSQLParserException: Lexical error at line 1, column 82. Encountered: "\\" (92), after : "" at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:165) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:59) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:37) at SqlParse.main(SqlParse.java:7) Caused by: net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 1, column 82. Encountered: "\\" (92), after : "" at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:4759) at net.sf.jsqlparser.parser.CCJSqlParser.jj_scan_token(CCJSqlParser.java:26392) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_PrimaryExpression_3279_9_631(CCJSqlParser.java:24982) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_PrimaryExpression_3217_5_117(CCJSqlParser.java:25491) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_BitwiseXor_3187_5_184(CCJSqlParser.java:25612) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_MultiplicativeExpression_3157_5_179(CCJSqlParser.java:25743) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_AdditiveExpression_3133_5_360(CCJSqlParser.java:25826) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_BitwiseAndOr_3101_5_176(CCJSqlParser.java:26047) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_ConcatExpression_3078_5_258(CCJSqlParser.java:26100) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_SimpleExpression_3054_5_115(CCJSqlParser.java:18471) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_93(CCJSqlParser.java:18642) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_ComparisonItem_3008_3_158(CCJSqlParser.java:18744) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_RegularCondition_2665_9_334(CCJSqlParser.java:20825) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_RegularCondition_2633_5_157(CCJSqlParser.java:21160) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_Condition_2616_9_310(CCJSqlParser.java:21226) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_Condition_2614_5_154(CCJSqlParser.java:21260) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_70(CCJSqlParser.java:21352) at net.sf.jsqlparser.parser.CCJSqlParser.jj_2_70(CCJSqlParser.java:17723) at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:8424) at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:8400) at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:8371) at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:7284) at net.sf.jsqlparser.parser.CCJSqlParser.Update(CCJSqlParser.java:1408) at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:138) at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:163) ... 3 more | ||||
| Tags | dialect: oracle, log miner | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-04-26 18:23 | elong | New Issue | |
| 2021-04-26 18:23 | elong | Tag Attached: dialect: oracle | |
| 2021-04-26 18:23 | elong | Tag Attached: log-miner | |
| 2021-11-02 19:47 | elong | Target Version | 3.13.0 => 3.14.0 |
| 2022-07-25 16:47 | elong | Target Version | 3.14.0 => 3.14.1 |
| 2022-07-25 20:36 | elong | Target Version | 3.14.1 => |
| 2022-08-09 17:57 | admin | Tag Renamed | log-miner => log miner |
| 2023-08-25 16:18 | elong | Target Version | => 3.15.0 |
| 2023-08-25 19:18 | emiller | Assigned To | => emiller |
| 2023-08-25 19:18 | emiller | Status | new => resolved |
| 2023-08-25 19:18 | emiller | Resolution | open => fixed |
| 2023-08-25 19:18 | emiller | Fixed in Version | => 3.15.0 |
| 2023-10-01 23:46 | admin | Status | resolved => closed |