Repository navigation
[BUG] JSQLParser Version : 4.6 : If there is a '.' in JdbcNamedParameter, parsing will fail! #1768
Description
If there is a '.' in JdbcNamedParameter, parsing will fail：
- SELECT 1 FROM dual WHERE a = :paramMap.aValue
SQL Example:
-- If there is a '.' sign in JdbcNamedParameter, parsing will fail
String sql = "SELECT 1 FROM dual WHERE a = :paramMap.aValue";
Statement statement = CCJSqlParserUtil.parse(sql);
-- This situation occurs when using the foreach tag of mybatis:
-- ... where line_no in ( :__frch_item_0.receipt_line_no, :__frch_item_1.receipt_line_no, :__frch_item_2.receipt_line_no)Error Info:
net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "." "."
at line 1, column 39.
Was expecting one of:
"&"
"::"
"<<"
">>"
"CONNECT"
"EMIT"
"GROUP"
"HAVING"
"START"
"WINDOW"
"["
"^"
"|"
<EOF>
<ST_SEMICOLON>
Activity
manticore-projects commentedon Apr 19, 2023
Yes, and I do not really understand why you would like to change that.
The correct SQL should look like this:
I have the feeling, that you would need to report this upstream to
myBatisinstead toJSQLParser.Lzw2016 commentedon Apr 19, 2023
Okay, I have my own solution。
I just think it's best not to restrict the naming of JdbcNamedParameter as spring jdbc's JdbcTemplate also supports the form of "a=: paramMap. aValue"
feat: Multi-Part Names for Variables and Parameters
JSQLParser 5.0 (#1778)
Assorted Fixes #8 (#1807)
Backslash Quotation of Single-Quote `'\\''` (#1813)