Skip to content

Encountered unexpected token: "member" #1631

Closed
#1778
Closed
Encountered unexpected token: "member"#1631
#1778
Assignees
manticore-projects

Description

@lovlyhao
lovlyhao
opened on Sep 15, 2022

代码如下
`String sql= "SELECT \n" +
" id,cxr_employee_id,cxr_post_id,cxr_site_id,cxr_region_id,in_charge_start_time,in_charge_end_time,charge_status,create_by,create_time,update_by,update_time,revision,create_by_name,create_by_type,update_by_name,update_by_type,delete_by,delete_by_name,delete_by_type,delete_time,delete_status,sort_num,remark,sys_dept_id,spare_id \n" +
" FROM cxr_employee_post \n" +
" WHERE ( '106' member of (cxr_post_id->'$.value') )";

    Select stmt = (Select) CCJSqlParserUtil.parse(sql);`

报错如下：

Exception in thread "main" net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "member" <S_IDENTIFIER>
at line 4, column 18.

Was expecting one of:

"&"
")"
"::"
"<<"
">>"
"COLLATE"
"["
"^"
"|"

at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:263)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:81)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:47)
at com.example.demo3.controller.Main.main(Main.java:21)

Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "member" <S_IDENTIFIER>
at line 4, column 18.

Was expecting one of:

"&"
")"
"::"
"<<"
">>"
"COLLATE"
"["
"^"
"|"

at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:258)
... 3 more

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "member" <S_IDENTIFIER>
at line 4, column 18.

Was expecting one of:

"&"
")"
"::"
"<<"
">>"
"COLLATE"
"["
"^"
"|"

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:33398)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:33231)
at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:10313)
at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:10259)
at net.sf.jsqlparser.parser.CCJSqlParser.XorExpression(CCJSqlParser.java:10241)
at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:10212)
at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:9494)
at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:6205)
at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:6406)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:6054)
at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:6049)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:248)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:157)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:253)
at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:250)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Activity

  1. manticore-projects commented on Sep 15, 2022

    @manticore-projects
    manticore-projects
    on Sep 15, 2022
    Contributor

    Greetings,

    MySQL MEMBER OF Operator is not supported yet.

    Syntax is: value MEMBER OF(json_array)

    Example:

    SELECT 17 MEMBER OF('[23, "abc", 17, "ab", 10]');

    OP's Sample is:

    SELECT 
 id,cxr_employee_id,cxr_post_id,cxr_site_id,cxr_region_id,in_charge_start_time,in_charge_end_time,charge_status,create_by,create_time,update_by,update_time,revision,create_by_name,create_by_type,update_by_name,update_by_type,delete_by,delete_by_name,delete_by_type,delete_time,delete_status,sort_num,remark,sys_dept_id,spare_id 
 FROM cxr_employee_post 
 WHERE ( '106' member of (cxr_post_id->'$.value') );
  2. manticore-projects
    self-assigned this
    on Sep 15, 2022

  3. lovlyhao commented on Sep 15, 2022

    @lovlyhao
    lovlyhao
    on Sep 15, 2022
    Author

    @manticore-projects cxr_post_id is
    {"name": "主管", "scope": "1", "value": "106"} But the query is wrong

  4. manticore-projects commented on Sep 15, 2022

    @manticore-projects
    manticore-projects
    on Sep 15, 2022
    Contributor

    @manticore-projects cxr_post_id is {"name": "主管", "scope": "1", "value": "106"} But the query is wrong

    Thank you for the clarification.
    As I have stated, the MySQL specific MEMBER OF operator is not supported by JSQLParser.

  5. lovlyhao commented on Sep 15, 2022

    @lovlyhao
    lovlyhao
    on Sep 15, 2022
    Author

    @manticore-projects thank you very much.

  6. RekaDowney commented on Oct 27, 2022

    @RekaDowney
    RekaDowney
    on Oct 27, 2022

    @manticore-projects As I have stated, the MySQL specific MEMBER OF operator is not supported by JSQLParser.

    Is there any plan to support MEMBER OF operator

  7. manticore-projects
    added a commit that references this issue on May 11, 2023

    feat: `MEMBER OF` condition as shown at https://dev.mysql.com/doc/ref…

    6e7a78d
  8. manticore-projects
    closed this as completedin 41b6fceon Jun 1, 2023
  9. manticore-projects
    closed this as completedin #1778on Jun 1, 2023
  10. manticore-projects
    added a commit that references this issue on Jun 15, 2023

    Assorted Fixes #8 (#1807)

    a815f5f
  11. manticore-projects
    added a commit that references this issue on Jun 27, 2023

    Backslash Quotation of Single-Quote `'\\''` (#1813)

    c79dfff
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions