0                      @                    2                E 8  C  8 8            Z                E 8 8 p o Z     8         W W W  8 2                          !  2 2" E#$ % E & 8' ( )*+, - . /0 12 3 4 56 578 9 : p; < 5= 5> 5? 5@ A B C D 5E FG 5H FIJ 5KLMNOPQR 5STU 5V 5W X 5Y 5Z [ \ ]  ^  _  ` a bc resultSet1Lorg/apache/derby/impl/sql/compile/ResultSetNode; subqueryTypeIunderTopAndNodeZ preprocesseddistinctExpression whereSubquery leftOperand-Lorg/apache/derby/impl/sql/compile/ValueNode;pushedNewPredicatehavingSubqueryparentComparisonOperator@Lorg/apache/derby/impl/sql/compile/BinaryComparisonOperatorNode;trueNode7Lorg/apache/derby/impl/sql/compile/BooleanConstantNode;subqueryNumberpointOfAttachmentfoundCorrelationdoneCorrelationCheck foundVariantdoneInvariantCheck orderByList/Lorg/apache/derby/impl/sql/compile/OrderByList;offset fetchFirstNOTIMPLEMENTED_SUBQUERY ConstantValue FROM_SUBQUERY IN_SUBQUERYNOT_IN_SUBQUERYEQ_ANY_SUBQUERYEQ_ALL_SUBQUERYNE_ANY_SUBQUERYNE_ALL_SUBQUERYGT_ANY_SUBQUERYGT_ALL_SUBQUERYGE_ANY_SUBQUERY GE_ALL_SUBQUERY LT_ANY_SUBQUERY LT_ALL_SUBQUERY LE_ANY_SUBQUERY LE_ALL_SUBQUERYEXISTS_SUBQUERYNOT_EXISTS_SUBQUERYEXPRESSION_SUBQUERY()VCodeinito(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)VtoString()Ljava/lang/String; printSubNodes(I)V getResultSet3()Lorg/apache/derby/impl/sql/compile/ResultSetNode;getSubqueryType()IsetSubqueryTypesetPointOfAttachment ExceptionsdgetUnderTopAndNode()ZgetPointOfAttachmentgetPreprocessedsetParentComparisonOperatorC(Lorg/apache/derby/impl/sql/compile/BinaryComparisonOperatorNode;)V"remapColumnReferencesToExpressions/()Lorg/apache/derby/impl/sql/compile/ValueNode;bindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode; preprocess(ILorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Lorg/apache/derby/impl/sql/compile/PredicateList;)Lorg/apache/derby/impl/sql/compile/ValueNode;singleFromBaseTable_(Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/FromBaseTable;"rightOperandFlattenableToNotExists5(ILorg/apache/derby/impl/sql/compile/FromBaseTable;)ZcanAllBeFlattenedflattenToNormalJoinflattenToExistsJoin(ILorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Lorg/apache/derby/impl/sql/compile/PredicateList;Z)Lorg/apache/derby/impl/sql/compile/ValueNode;getRightOperand isInvarianthasCorrelatedCRspushNewPredicateB(I)Lorg/apache/derby/impl/sql/compile/UnaryComparisonOperatorNode;getNewJoinCondition(Lorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/ValueNode;)Lorg/apache/derby/impl/sql/compile/BinaryComparisonOperatorNode; eliminateNots0(Z)Lorg/apache/derby/impl/sql/compile/ValueNode; changeToCNF categorize((Lorg/apache/derby/iapi/util/JBitSet;Z)ZisMaterializableoptimize9(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;D)VmodifyAccessPathsgetOrderableVariantTypegenerateExpressiont(Lorg/apache/derby/impl/sql/compile/ExpressionClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VgenerateMaterialization(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;Ljava/lang/String;)Lorg/apache/derby/iapi/services/compiler/LocalField; getTrueNode9()Lorg/apache/derby/impl/sql/compile/BooleanConstantNode;acceptChildren.(Lorg/apache/derby/iapi/sql/compile/Visitor;)VisINisNOT_INisANYisALLisEXISTS isNOT_EXISTS#changeToCorrespondingExpressionTypesetDataTypeServices7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)V isEquivalent0(Lorg/apache/derby/impl/sql/compile/ValueNode;)ZisHavingSubquerysetHavingSubquery(Z)VisWhereSubquerysetWhereSubquery#isWhereExistsAnyInWithWhereSubquerygetOrderByList1()Lorg/apache/derby/impl/sql/compile/OrderByList; getOffset getFetchFirst 01 /org/apache/derby/impl/sql/compile/ResultSetNode java/lang/Integer e< -org/apache/derby/impl/sql/compile/OrderByList +org/apache/derby/impl/sql/compile/ValueNode    aB ,org/apache/derby/impl/sql/compile/SelectNode fg hi G1j42Z91 kl m<42X39 no pq rs tuv w8 xy z{ |} ~< 1  v IJ      B .org/apache/derby/impl/sql/compile/ResultColumn   uv  1*org/apache/derby/impl/sql/compile/FromList K KL B 1 nB pB B WB t12org/apache/derby/impl/sql/compile/RowResultSetNode ~B>org/apache/derby/impl/sql/compile/BinaryComparisonOperatorNode H   <   UH Z[ sB QB B rB B .org/apache/derby/impl/sql/compile/ConstantNode1org/apache/derby/impl/sql/compile/ColumnReference  RL"org/apache/derby/iapi/util/JBitSet 08 _` B  MN  OP ST 1   XY H VB +org/apache/derby/impl/sql/compile/FromTable/org/apache/derby/impl/sql/compile/FromBaseTable5org/apache/derby/impl/sql/compile/ProjectRestrictNode : <  oB qB B  8       < 8   H  82 **?@AB2*C<2*DB2*EF2*+GH25)* *L*M,N+-*?@IJ2SG* *: *+* * ** *!:"***#+$**+%**&*'* *+(*)** ***+,-** * *+*+,*+-* * *.* */*)*:* *0*1234*5,*67*?@KL2G ;****:**89***,-:*(*;*<* *=*> *?*@*A*B*C;*4*-* &* **D*E6S**F*C:8YG:-*HIJK,L-IM***NO*P *Q6*_*RR* K* D*=*6*/*D(*>*?*S *6*:TU*: *  * 6  %*V*W *06 *E**F X *,-Y*>*?*Sc**ZY[\F];*^_:  + `* a*,-b* * %* c * d** e* ** *f**g:*h* *i:* *jW*AW**k*?@MN2NBM+l9+mnN-o -oM!-p-pq:o oM,OP26*>*"ZY[:*N\W,rs>?@QB2>2<*t *u#*vw*Nvw<?@RL2 *:^:x:-*Hy,Lz-{M-|M**}&~* *N:W;W:  6 6  "  .  d **O?@ST21%*:^*,*,-Y?@UH2 *12L+VB2K?***YL*+W*+*?@WB2|****LM*h1*pqL+M,YN-,+-YN+-W*-*h,+,*?@XY29 -N:***::  ***}* * :12:: ** ON-: *t *u*vw6  vw6 *}&*:*}4-*::  =*}**:*}4 *:: ;*} *:*}4 *:: *}' **MZY[:,*}N,*:****** qH^H^H^H^H^H^H^*}**:*}**:?@Z[2 N* 6* l6**:6 6A 65  6'  6  6 666pFFFMMFiTb[[bTi)6&/6,6-6*6 +6*}+,*EN--?@\]2*M* cck|sZR*Mt* k* c* [* R* I* @* 7* /* '* * * * ,?@^]2**?@_`2 *?@aB2K?* *A*j<**M,^N-?@bc2**+(?@d12 **?@e<2)*j*A* ?@fg2*!N+:*  ::*:*::: : *: *h*A*pq: :  Y :  **p           *-6 * ** 3*= 6 *@ 6 6  6 6  ** W*4*h*A*p    W WW* W**: , !,,W?@hi2D8+:+-:,-Wjk2/#***}&~**?@lm2XL*++*+****+***+ ?@nB2* oB2* pB2PD* > <><><><><><qB2PD* ><><><><><><rB2* sB2* t12 L*  BB[t*})***L}*}/***Ld*},***LK*}-***L2*}****L*}+***L* **5*+E**?@uv26** +123M *M*,?@wx2yB2*z{2*|B2*}{2*~B2G;*5*S*? *> **L+?@2* H2* H2*