[BUG] JSQLParser Version : 4.7 parsed error

[tdelain]

SELECT ID FROM a6_ WHERE opIn & 0x1603ffff823 = 0x1603ffff820 AND date>='20131208_233900'

Cannot be parsed. It was working well with v1.1

net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "ND" <S_IDENTIFIER>
at line 1, column 64.

Was expecting one of:

"::"
"["
"^"
<EOF>
<ST_SEMICOLON>

at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:25)

With parentheses, it is OK :
SELECT ID FROM a6_ WHERE (opIn & 0x1603ffff823 = 0x1603ffff820) AND date>='20131208_233900'

Software Information:

• JSqlParser version 4.7
• Database : no database, just parse

[manticore-projects]

Greetings.

Thank you for reporting. If you add brackets, it will work:

SELECT id
FROM a6_
WHERE ( opin & 0x1603ffff823  = 0x1603ffff820 )
    AND date >= '20131208_233900'
;

You can try it online here.

There were many new Operators adopted since JSQLParser 1 and so the BitAnd may be misread.
Patches are welcome, I don't have much time to investigate this right now.

[manticore-projects]

I assume, the precedence of the expressions in the parser is incorrect, that's why the brackets help.

[manticore-projects]

Actually it works with JSQLParser 4.8 Snapshot.
Please try it here.

[manticore-projects]

Closing this since its working and no further question has been asked.