0~                    Q     Q Q %     ' %     5   : <  <          4      Q          N  N          k           E  }  ! ! " # $ % & ' ( ) P* + ) P, - E . /0 / 1 2 3 4 5 /6 /7 8 /9 /: ; <= > 4? @ A B / QC ED E EF G H I EJ P K LM QNO >P Q R ST U V W X Y Z[ V U \]  ^ :_ C ` a bc d e f gh f /i ; j k l mn o p qr s Et u Ev Ew x Ey Ez { S| S} S~ S g g g P   S S P           7 7        P   P E <   P  E   fromList,Lorg/apache/derby/impl/sql/compile/FromList; targetTable-Lorg/apache/derby/impl/sql/compile/FromTable;selectAggregatesLjava/util/Vector;whereAggregateshavingAggregates whereClause-Lorg/apache/derby/impl/sql/compile/ValueNode;originalWhereClause groupByList/Lorg/apache/derby/impl/sql/compile/GroupByList;windows.Lorg/apache/derby/impl/sql/compile/WindowList;windowFuncCalls wasGroupByZ orderByList/Lorg/apache/derby/impl/sql/compile/OrderByList; orderByQueryoffset fetchFirstwherePredicates1Lorg/apache/derby/impl/sql/compile/PredicateList;selectSubquerys0Lorg/apache/derby/impl/sql/compile/SubqueryList;whereSubqueryshavingSubquerysbindTargetListOnly isDistinctorderByAndDistinctMerged originalWhereClauseHadSubqueries preJoinFL havingClause nestingLevelI4class$org$apache$derby$impl$sql$compile$SubqueryNodeLjava/lang/Class; Synthetic:class$org$apache$derby$impl$sql$compile$WindowFunctionNode4class$org$apache$derby$impl$sql$compile$FromSubquery()VCodeinit(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)V ExceptionsaddInlinedWindowDefinition(Lorg/apache/derby/impl/sql/compile/WindowList;Lorg/apache/derby/impl/sql/compile/WindowFunctionNode;)Lorg/apache/derby/impl/sql/compile/WindowList;toString()Ljava/lang/String;statementToString makeDistinct clearDistinct hasDistinct()Z printSubNodes(I)V getFromList.()Lorg/apache/derby/impl/sql/compile/FromList;findColumnReferenceInResultG(Ljava/lang/String;)Lorg/apache/derby/impl/sql/compile/ColumnReference;getWhereClause/()Lorg/apache/derby/impl/sql/compile/ValueNode;getWherePredicates3()Lorg/apache/derby/impl/sql/compile/PredicateList;getSelectSubquerys2()Lorg/apache/derby/impl/sql/compile/SubqueryList;getWhereSubquerysbindNonVTITables(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;bindExpressions/(Lorg/apache/derby/impl/sql/compile/FromList;)VbindExpressionsWithTablesbindTargetExpressionsbindResultColumns(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/impl/sql/compile/FromVTI;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/DMLStatementNode;Lorg/apache/derby/impl/sql/compile/FromList;)VpushExpressionsIntoSelect0(Lorg/apache/derby/impl/sql/compile/Predicate;)VverifySelectStarSubquery0(Lorg/apache/derby/impl/sql/compile/FromList;I)VgetFromTableByNameT(Ljava/lang/String;Ljava/lang/String;Z)Lorg/apache/derby/impl/sql/compile/FromTable;rejectParameterspushOrderByList2(Lorg/apache/derby/impl/sql/compile/OrderByList;)VpushOffsetFetchFirst](Lorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/ValueNode;)V preprocess(ILorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;performTransitiveClosurenormExpressions\(Lorg/apache/derby/impl/sql/compile/ValueNode;)Lorg/apache/derby/impl/sql/compile/ValueNode;addNewPredicate`(Lorg/apache/derby/impl/sql/compile/Predicate;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;flattenableInFromSubquery/(Lorg/apache/derby/impl/sql/compile/FromList;)ZgenProjectRestrict4(I)Lorg/apache/derby/impl/sql/compile/ResultSetNode;isOrderedResulti(Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/ResultSetNode;Z)ZensurePredicateListoptimize(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/PredicateList;D)Lorg/apache/derby/impl/sql/compile/ResultSetNode;modifyAccessPathsd(Lorg/apache/derby/impl/sql/compile/PredicateList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;3()Lorg/apache/derby/impl/sql/compile/ResultSetNode;getFinalCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate;isUpdatableCursor8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)ZgetCursorTargetTable/()Lorg/apache/derby/impl/sql/compile/FromTable;referencesTarget(Ljava/lang/String;Z)ZsubqueryReferencesTargetbindUntypedNullsToResultColumns7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VdecrementLeveluniqueSubquery(Z)ZupdateTargetLockMode()IreturnsAtMostOneRowreferencesSessionSchemaacceptChildren.(Lorg/apache/derby/iapi/sql/compile/Visitor;)VhasAggregatesInSelectList hasWindowscheckNoWindowFunctionsF(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;Ljava/lang/String;)VreplaceOrForbidDefaultsn(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Z)Vclass$%(Ljava/lang/String;)Ljava/lang/Class;  java/lang/ClassNotFoundExceptionjava/lang/NoClassDefFoundError HI 2org/apache/derby/impl/sql/compile/ResultColumnList  I*org/apache/derby/impl/sql/compile/FromList +org/apache/derby/impl/sql/compile/ValueNode &' ('-org/apache/derby/impl/sql/compile/GroupByList )* @',org/apache/derby/impl/sql/compile/WindowList +, ;/ >/5org/apache/derby/impl/sql/compile/CollectNodesVisitor CD.org.apache.derby.impl.sql.compile.SubqueryNode  H   W FD4org.apache.derby.impl.sql.compile.WindowFunctionNode H -#  4org/apache/derby/impl/sql/compile/WindowFunctionNode 6org/apache/derby/impl/sql/compile/WindowDefinitionNode OP     SELECT </ +org/apache/derby/impl/sql/compile/FromTable5org/apache/derby/impl/sql/compile/ProjectRestrictNode /org/apache/derby/impl/sql/compile/FromBaseTable.org/apache/derby/impl/sql/compile/ResultColumn _1org/apache/derby/impl/sql/compile/ColumnReference   _ 56 78 98  /org/apache/derby/impl/sql/compile/PredicateList   ? AB  Y   Y gh.org/apache/derby/impl/sql/compile/SubqueryListjava/util/Vector "#  g $#  Y   Y42903  W42X19 PARAMETER  _ IWHERE  %# :8HAVING GROUP BYCorg/apache/derby/impl/sql/compile/VerifyAggregateExpressionsVisitor H 42Z02 GD.org.apache.derby.impl.sql.compile.FromSubquery kh5400442X81 kl    1org/apache/derby/impl/sql/compile/AllResultColumn42X38 R qr42X10 sI 01 2/ 3' 4' {|  x x I x I  zY    I ./      W   I   =/"org/apache/derby/iapi/util/JBitSet HY       !" #W $% &' (_ )' *n +W ,/org/apache/derby/impl/sql/compile/ResultSetNode -.java/lang/Integer-org/apache/derby/impl/sql/compile/GroupByNode /0 123 4 56 7 8W42ZC1,org/apache/derby/impl/sql/compile/WindowNode 95org/apache/derby/impl/sql/compile/WindowResultSetNode :Ijava/util/HashSet ;< => ?@ AI java/lang/Boolean H0 B CDE F GW H I J KL.org/apache/derby/impl/sql/compile/RowCountNode M NI OP.org/apache/derby/impl/sql/compile/ConstantNode QR+org/apache/derby/impl/sql/compile/Predicate SW TY UV WW XY TY Z[ \] ^W _W `I ab c] de f/org/apache/derby/impl/sql/compile/OptimizerImpl g  I h iI jk lY mn*org/apache/derby/impl/sql/compile/JoinNode o   !)org/apache/derby/impl/sql/compile/FromVTI W pR qrs tR uv wxy z bc dc   Y p {W  W 0org/apache/derby/impl/sql/compile/HasNodeVisitor| }W42ZC2,org/apache/derby/impl/sql/compile/SelectNode-org/apache/derby/iapi/error/StandardExceptionjava/lang/ClassforName initCause,(Ljava/lang/Throwable;)Ljava/lang/Throwable; resultColumns4Lorg/apache/derby/impl/sql/compile/ResultColumnList;markInitialSize%(Ljava/lang/Class;Ljava/lang/Class;)VacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable;getList()Ljava/util/Vector;isEmpty(Ljava/lang/Class;)Vsize elementAt(I)Ljava/lang/Object; getWindow0()Lorg/apache/derby/impl/sql/compile/WindowNode;getContextManager9()Lorg/apache/derby/iapi/services/context/ContextManager;setContextManager:(Lorg/apache/derby/iapi/services/context/ContextManager;)VfindEquivalentWindowh(Lorg/apache/derby/impl/sql/compile/WindowList;)Lorg/apache/derby/impl/sql/compile/WindowDefinitionNode; setWindow;(Lorg/apache/derby/impl/sql/compile/WindowDefinitionNode;)V addWindow4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;getChildResult getExpression columnNameLjava/lang/String;java/lang/Stringequals(Ljava/lang/Object;)ZgetClonegetNodeFactory1()Lorg/apache/derby/iapi/sql/compile/NodeFactory;-org/apache/derby/iapi/sql/compile/NodeFactorygetNodek(ILorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;doJoinOrderOptimization()Ljava/lang/Boolean;}(ILjava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;getLevelsetLevelinsertElementAt5(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;I)V bindTablesd(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/FromList;)VremoveElementAt setWindows1(Lorg/apache/derby/impl/sql/compile/WindowList;)Vq(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)VgetCompilerContext5()Lorg/apache/derby/iapi/sql/compile/CompilerContext;1org/apache/derby/iapi/sql/compile/CompilerContextpushCurrentPrivType orReliability(I)IbindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode;setReliability newExceptionC(Ljava/lang/String;)Lorg/apache/derby/iapi/error/StandardException;isParameterNodeU(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;checkIsBooleanpopCurrentPrivTypebindGroupByColumnsC(Lorg/apache/derby/impl/sql/compile/SelectNode;Ljava/util/Vector;)V2(Lorg/apache/derby/impl/sql/compile/GroupByList;)VnumDistinctAggregates(Ljava/util/Vector;)IreferencedTableMap$Lorg/apache/derby/iapi/util/JBitSet; getAndNode-()Lorg/apache/derby/impl/sql/compile/AndNode;pullExpressions1(ILorg/apache/derby/impl/sql/compile/ValueNode;)VpushPredicates4(Lorg/apache/derby/impl/sql/compile/PredicateList;)VgetFullTableNameLOJ_reorderable(I)Z`(ILorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/ValueNode;)V(ILorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Lorg/apache/derby/impl/sql/compile/PredicateList;)VmarkWhereSubqueries(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;markHavingSubqueriesflattenFromTables(Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/PredicateList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Lorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/ValueNode;)V-org/apache/derby/impl/sql/compile/OrderByListremoveConstantColumnsremoveOrderByColumnsallTopCRsFromSameTablegetDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;returnsAtMostSingleRow(Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/PredicateList;Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)Z allAscendingisInOrderPrefix7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)ZgenProjectRestrictForReorderingresetToSourceRCs reorderRCLj(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)Lorg/apache/derby/impl/sql/compile/ResultColumnList;getResultColumns6()Lorg/apache/derby/impl/sql/compile/ResultColumnList;getReferencedTableMap&()Lorg/apache/derby/iapi/util/JBitSet;or'(Lorg/apache/derby/iapi/util/JBitSet;)Vclone()Ljava/lang/Object;setReferencedTableMapaddjoinClauseTransitiveClosurec(ILorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/iapi/sql/compile/CompilerContext;)VhashJoinSpecifiedsearchClauseTransitiveClosure(IZ)V eliminateNots0(Z)Lorg/apache/derby/impl/sql/compile/ValueNode; putAndsOnTop changeToCNF addPredicate isCloneable(ILjava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;addAll(Ljava/util/Collection;)Z!considerPostOptimizeOptimizations(Z)V optimizer-Lorg/apache/derby/iapi/sql/compile/Optimizer;+org/apache/derby/iapi/sql/compile/OptimizergetOptimizedCostassignCostEstimate3(Lorg/apache/derby/iapi/sql/compile/CostEstimate;)V getParentgetIsInSortedOrder(ILjava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;verifyAllOrderablegetResultColumn3(I)Lorg/apache/derby/impl/sql/compile/ResultColumn;getBaseColumnNode4()Lorg/apache/derby/impl/sql/compile/BaseColumnNode;isPossibleDistinctScan(Ljava/util/Set;)ZmarkForDistinctScan(ILjava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; costEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;.org/apache/derby/iapi/sql/compile/CostEstimatecloneMe getSortNeededgetOrderBySelectcopyListAndObjectssetResultColumnsgenVirtualColumnNodesh(Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VnumGeneratedColumnsForGroupByremoveGeneratedGroupingColumnsadjustForSortElimination:(Lorg/apache/derby/iapi/sql/compile/RequiredRowOrdering;)V isOrderedOnJ([Lorg/apache/derby/impl/sql/compile/ColumnReference;ZLjava/util/Vector;)ZisScopedForPushremoveOptPredicategetOptPredicate;(I)Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;isScopedToSourceResultSetaddOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)V getOptimizer (Lorg/apache/derby/iapi/sql/compile/OptimizableList;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/iapi/sql/compile/RequiredRowOrdering;)Lorg/apache/derby/iapi/sql/compile/Optimizer; setOuterRows(D)VgetNextPermutationgetNextDecoratedPermutationcostPermutationsetEstimatedRowCount(J)VsetSingleScanRowCountrowCount()D9(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;D)VaddScopedPredicatesToList getFinalCostremoveAllElementsnondestructiveAppend:(Lorg/apache/derby/impl/sql/compile/QueryTreeNodeVector;)VadjustVirtualColumnIds propertiesLjava/util/Properties; setElementAtgetBaseTableNamegetTableNameField/()Lorg/apache/derby/impl/sql/compile/TableName;+org/apache/derby/impl/sql/compile/TableName getSchemaNamegetSchemaDescriptorK(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;getTableDescriptor(Ljava/lang/String;Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor;)Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;4org/apache/derby/iapi/sql/dictionary/TableDescriptor getTableType getCorrelated/org/apache/derby/impl/sql/compile/QueryTreeNodehasNode! !"#$#%#&'(')*+,-#./012/3'4'567898:8;/</=/>/?@'ABCDEFDEGDE7HIJ*KLJ* *+* * *- * * ** **** PYYY:* W**pYY :*!W*"6  *"#0*" $%:  &'*** ( ʱMNOPJJ>,&'N+Y)L+**+-+,: ,-+,&'.+QRJ/SRJ0TIJ*1UIJ*1VWJ*1XYJ Z[J* \]J* 2* 34M,5,567 ,7*8>6C*9::;<;<:=+> ?<MN^_J* `aJ*@bcJ*AdcJ*BefJ* 2>**C**DE@**C%*CF**G H,2 *I*,34J`I* *IK6,* 3L* +,M6,N*MNghJ +2=* 2>* * +O**C **DPA*QYRS6+* 3L+*T*+*A*SU*6+N*QYRV**C **DPB*W:* pX*@Y6** +*B*VZ [*V# \]* ^ _`a** b *Wc* de*Y*@Y6*QYRf**C **DPg*+*g*fZW**b*he[6+N*QYR:**i*je* *S#kY*l:*!W*Sm6* n]MNihJ*+oMNjhJi]YpqYpppqYppM* ,rW, ***+o*MNkhJ=1* +s*+t*8 u]*8 v]MNklJ!* s*+,-wMNmnJ**@*xy+z{* *@|MNopJsg*9:} ~]*9}N-8* -++-!* -+- -aMNqrJ * +,MNsIJ ** MNtuJ *+*vwJ *+*,xyJ *:*** **** 6+*C%*CF**G :*o* s* ** ** *B*@* &*B *B* * *B*@W*** *B*@*"*g*** *g*@* *@* {* * **@*B***@O*@E* 2;* 2**$**@****-*&*S#*V#*1***1**6"* ** *@**1*1X*Q*G** *,*:******* *@|*Yx* 266*x* 34**x*tYY :*W:6  #8 $%: *" W &'*** ( MNzYJ, *@* *W*@* MN{|J#++L+L+L+MN}~J *@+*MNJ}*1* 2*A*A* ***S*S#*** *J} q=*C* 3** *@*A*B**:*S *S# **S:*f*f*f*SW*f:*C***gY*I**:***: =*\* ]*:*C*"Y*I**::**1*6g*`6Y:*86 6   ** ɶ:  6 W ̙ 6V***6*C|Y**:*ҹ=**ՙ+*C***:*ҹ*ֶ6B::*C**:* *@::*C****:*S*ܞI*B::*C**:* *՚ *= **ҹMNJ +86662+9::;< ;ߚ<:66/+9::  ;< ;