[BUG] JSQLParser Version : 4.6 : If there is a '.' in JdbcNamedParameter, parsing will fail!

[Lzw2016]

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>

[manticore-projects]

Yes, and I do not really understand why you would like to change that.
The correct SQL should look like this:

SELECT 1 FROM dual WHERE a = :aValue

I have the feeling, that you would need to report this upstream to myBatis instead toJSQLParser.

[Lzw2016]

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"