JSqlParser
JSqlParser copied to clipboard
validate not support 'not rlike'
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>
] ]