JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

validate not support 'not rlike'

Open guandatawangjialin opened this issue 3 years ago • 0 comments

    String sql = "select * from test where id  not rlike '111'";

ValidationError [ statement=select * from test where id not rlike '111' capability=parsing errors=[ParseException: Cannot parse statement: Encountered unexpected token: "not" "NOT" at line 1, column 30.

Was expecting one of:

"&"
"&&"
"::"
";"
"<<"
">>"
"AND"
"AT"
"COLLATE"
"CONNECT"
"FOR"
"GROUP"
"HAVING"
"OR"
"START"
"XOR"
"["
"^"
"|"
<EOF>

] ]

guandatawangjialin avatar Jun 06 '22 02:06 guandatawangjialin