Hi there.
I am evaluating JSQLParser for a project where I would like to have access to the actual parsetrees.

A simple test is to parse the two queries
String s_and = "SELECT director FROM movie WHERE YEAR = 1999 AND YEAR = 2000";
String s_or = "SELECT director FROM movie WHERE YEAR = 1999 OR YEAR = 2000";

and see the difference in the data structures.

I am dumping out ID + value if present as follows

 void MyDump(SimpleNode n, int level) {
 for ( int i = 0; i < level; ++i)
 System.out.print(' ');
 if (n.jjtGetValue() != null)
 System.out.println(n.getId() + n.jjtGetValue().toString()); 
 else 
 System.out.println();
 for (int i = 0; i < n.jjtGetNumChildren(); ++i) {
 MyDump((SimpleNode)n.jjtGetChild(i), level + 1);
 }
 }

My problem:
Except for the first line there is no difference in the inspectable parse trees:

 6 SELECT director FROM movie WHERE YEAR = 1999 OR YEAR = 2000
 9 director
 19 
 4 director
 5 movie
 13 
 14 YEAR = 1999
 19 
 4 YEAR
 19 
 14 YEAR = 2000
 19 
 4 YEAR
 19 
(Side question: Are these IDs defined in CCJQLParserConstants?)

From the tree alone it is not possible to distinguish what kind of expression is performed.
(AND/OR)

Is it possible that this type of information is in the actual instances uses to construct the expression
(meaning there are some dynamic instance of expression) but not present in the traversable tree?

Ideally the data that one can traverse in the AST tree would differentiate between both cases.
Any suggestions how to figure out this info?

Thanks.