Skip to content

REGEXP in mysql #59

@skomlaebri

Description

@skomlaebri

Hi! Does JSQLParser support Regular Expression for Mysql database?
I tried with:
SELECT * FROM pet WHERE name REGEXP '^b'
and the parser returned the error:

Encountered " <S_IDENTIFIER> "name "" at line 1, column 25.
Was expecting one of:
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...
"(" ...

at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:9257)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:9130)
at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:2400)
at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:2068)
at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:939)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:850)
at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:837)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:74)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:54)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:49)
at it.unibz.krdb.sql.api.VisitedQuery.<init>(VisitedQuery.java:93)
at it.unibz.krdb.obda.parser.JSQLParserTest.parseUnquotedJSQL(JSQLParserTest.java:768)
at it.unibz.krdb.obda.parser.JSQLParserTest.testRegexMySQL(JSQLParserTest.java:690)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at junit.framework.TestCase.runTest(TestCase.java:168)
at junit.framework.TestCase.runBare(TestCase.java:134)
at junit.framework.TestResult$1.protect(TestResult.java:110)
at junit.framework.TestResult.runProtected(TestResult.java:128)
at junit.framework.TestResult.run(TestResult.java:113)
at junit.framework.TestCase.run(TestCase.java:124)
at junit.framework.TestSuite.runTest(TestSuite.java:243)
at junit.framework.TestSuite.run(TestSuite.java:238)

Thanks

Metadata

Metadata

Assignees

No one assigned

    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