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

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>

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.

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)

Navigation Menu

Repository navigation

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

If there is a '.' in JdbcNamedParameter, parsing will fail：

SQL Example:

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[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：

SQL Example:

Activity

manticore-projects commented on Apr 19, 2023

Lzw2016 commented on Apr 19, 2023

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions