I took a look into the grammar file and it does not seem to me that this is supported. SOME is not even a reserved word. Is this by reason or could it be implemented? Would be very helpful. Or am I making a mistake?
I'm looking forward to you answer.
Regards, Claas
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello!
I need an SQL parser for my diploma thesis and found this one. It seems to work well except one issue:
When I try to parse a statement containing ALL, ANY or SOME I get an error. Example:
"SELECT * FROM table1 WHERE column1 > ALL (SELECT column2 FROM table1)"
This - to my understanding - should be valid SQL-92. But the parser says:
net.sf.jsqlparser.parser.ParseException: Encountered "ALL" at line 1, column 38.
Was expecting one of:
"NULL" ...
"CASE" ...
"REPLACE" ...
<S_DOUBLE> ...
<S_INTEGER> ...
<S_IDENTIFIER> ...
<S_CHAR_LITERAL> ...
<S_QUOTED_IDENTIFIER> ...
"(" ...
"?" ...
"+" ...
"-" ...
"{d" ...
"{t" ...
"{ts" ...
"{fn" ...
I took a look into the grammar file and it does not seem to me that this is supported. SOME is not even a reserved word. Is this by reason or could it be implemented? Would be very helpful. Or am I making a mistake?
I'm looking forward to you answer.
Regards, Claas
please have a look at 0.4.2
Great! :)
Thank you very much for your fast response. I just tried the new code and it seems to work fine.
Regards, Claas