net.sf.saffron.oj.xlat
Class SubqueryFinder

java.lang.Object
  |
  +--openjava.ptree.util.ParseTreeVisitor
        |
        +--openjava.ptree.util.EvaluationShuttle
              |
              +--openjava.ptree.util.ScopeHandler
                    |
                    +--net.sf.saffron.oj.xlat.SubqueryFinder

class SubqueryFinder

extends ScopeHandler

Nested Class Summary

private static class

SubqueryFinder.RexExpression A Row-expression wrapped to look like a Openjava expression.

Field Summary

(package private) QueryInfo

queryInfo

Fields inherited from class openjava.ptree.util.ScopeHandler

Fields inherited from class openjava.ptree.util.EvaluationShuttle

Constructor Summary

(package private)

SubqueryFinder(QueryInfo queryInfo, Environment env)

Method Summary

void	visit(BinaryExpression p)
void	visit(UnaryExpression p) Replaces an exists expression.

Methods inherited from class openjava.ptree.util.ScopeHandler

evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, pop, push, pushClosedEnvironment

Methods inherited from class openjava.ptree.util.EvaluationShuttle

evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateDown, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, evaluateUp, getEnvironment, setEnvironment, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit

Methods inherited from class openjava.ptree.util.ParseTreeVisitor

visit, visit, visit, visit, visit, visit, visit, visit, visit

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

queryInfo

QueryInfo queryInfo

Constructor Detail

SubqueryFinder

SubqueryFinder(QueryInfo queryInfo,
               Environment env)

Method Detail

visit

public void visit(BinaryExpression p)
           throws ParseTreeException

Overrides:

visit in class EvaluationShuttle

ParseTreeException

visit

public void visit(UnaryExpression p)
           throws ParseTreeException

Replaces an exists expression. For example,

select from dept
 where dept.state.equals("CA") && exists (
  select from emp where emp.deptno == dept.deptno)

becomes

select from dept left join (
  select distinct true from (
 	select from emp where emp.deptno == dept.deptno)) as test
 where dept.state.equals("CA") && test

Overrides:

visit in class EvaluationShuttle

ParseTreeException