0a                          #        ,  0  0 0              J   J                   leftResultSet1Lorg/apache/derby/impl/sql/compile/ResultSetNode;rightResultSet leftOptimizer-Lorg/apache/derby/iapi/sql/compile/Optimizer;rightOptimizerleftModifyAccessPathsDoneZrightModifyAccessPathsDone()VCodeinit9(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)V Exceptions bindUntypedNullsToResultColumns7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VmodifyAccessPathU(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/iapi/sql/compile/Optimizable;verifyProperties8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)VupdateBestPlanMap(SLjava/lang/Object;)VtoString()Ljava/lang/String; printSubNodes(I)VgetLeftResultSet3()Lorg/apache/derby/impl/sql/compile/ResultSetNode;getRightResultSetgetLeftmostResultSetsetLeftmostResultSet4(Lorg/apache/derby/impl/sql/compile/ResultSetNode;)VsetLevelgetExposedNamesetNestedInParens(Z)VbindNonVTITables(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode; bindVTITables_(Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;bindExpressions/(Lorg/apache/derby/impl/sql/compile/FromList;)VrejectParametersbindExpressionsWithTablesbindResultColumns(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;)VgetFromTableByNameT(Ljava/lang/String;Ljava/lang/String;Z)Lorg/apache/derby/impl/sql/compile/FromTable; preprocess(ILorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;projectResultColumnssetReferencedColumnsoptimize(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/PredicateList;D)Lorg/apache/derby/impl/sql/compile/ResultSetNode;modifyAccessPathsreferencesTarget(Ljava/lang/String;Z)ZreferencesSessionSchema()ZoptimizeSource(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/PredicateList;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;decrementLeveladjustForSortElimination:(Lorg/apache/derby/iapi/sql/compile/RequiredRowOrdering;)VacceptChildren.(Lorg/apache/derby/iapi/sql/compile/Visitor;)VneedsSpecialRCLBinding lm o/org/apache/derby/impl/sql/compile/ResultSetNode cd ed st+org/apache/derby/impl/sql/compile/FromTable fg m/org/apache/derby/impl/sql/compile/OptimizerImpl   uv ij hg kj -org/apache/derby/iapi/sql/compile/Optimizable wx yz  z3org/apache/derby/impl/sql/compile/TableOperatorNode ~    +org/apache/derby/impl/sql/compile/UnionNode  m .org/apache/derby/impl/sql/compile/FromSubquery  ! "# $%"org/apache/derby/iapi/util/JBitSet &' () *~ + m ,! -./ 0m 123 45 67 89*org/apache/derby/impl/sql/compile/FromList5org/apache/derby/iapi/sql/compile/RequiredRowOrdering :; <= >? @=A BC DC EC FG HI1org/apache/derby/impl/sql/compile/SetOperatorNode JK L MK 8N/org/apache/derby/impl/sql/compile/PredicateList OPQ RS TU VW :X Ym Z[ \ ] ^m ~ m _`-org/apache/derby/iapi/error/StandardException'(Ljava/lang/Object;Ljava/lang/Object;)V+org/apache/derby/iapi/sql/compile/OptimizeroptimizableList3Lorg/apache/derby/iapi/sql/compile/OptimizableList;1org/apache/derby/iapi/sql/compile/OptimizableListgetOptimizable2(I)Lorg/apache/derby/iapi/sql/compile/Optimizable;getOptimizerImpl3()Lorg/apache/derby/impl/sql/compile/OptimizerImpl;updateBestPlanMaps tableNumberIgetCompilerContext5()Lorg/apache/derby/iapi/sql/compile/CompilerContext;1org/apache/derby/iapi/sql/compile/CompilerContextgetNextTableNumber()ItableConstructorextractSubquery4(I)Lorg/apache/derby/impl/sql/compile/ResultSetNode;getReferencedTableMap&()Lorg/apache/derby/iapi/util/JBitSet;clone()Ljava/lang/Object;referencedTableMap$Lorg/apache/derby/iapi/util/JBitSet;or'(Lorg/apache/derby/iapi/util/JBitSet;)VsetisFlattenableJoinNodegenProjectRestrict resultColumns4Lorg/apache/derby/impl/sql/compile/ResultColumnList;2org/apache/derby/impl/sql/compile/ResultColumnList doProjectiongetNodeFactory1()Lorg/apache/derby/iapi/sql/compile/NodeFactory;-org/apache/derby/iapi/sql/compile/NodeFactorydoJoinOrderOptimization()Ljava/lang/Boolean;getContextManager9()Lorg/apache/derby/iapi/services/context/ContextManager;getNode(ILjava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; 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;newCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate; costEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;getCostEstimate.org/apache/derby/iapi/sql/compile/CostEstimategetEstimatedCost()DrowCountsingleScanRowCountsetCost(DDD)Vadd(Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;getLeftOptPredicateList3()Lorg/apache/derby/impl/sql/compile/PredicateList;d(Lorg/apache/derby/impl/sql/compile/PredicateList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;getRightOptPredicateListk(ILorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;getLanguageConnectionContext<()Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;8org/apache/derby/iapi/sql/conn/LanguageConnectionContextgetOptimizerFactory6()Lorg/apache/derby/iapi/sql/compile/OptimizerFactory;getDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary; getNumTables2org/apache/derby/iapi/sql/compile/OptimizerFactoryE(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;ILorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;)Lorg/apache/derby/iapi/sql/compile/Optimizer;prepForNextRound setOuterRows(D)VgetNextPermutationgetNextDecoratedPermutationcostPermutationacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable; cdedfghgijkj$lmn*opn#*-*+*,qrstn*+*+qruvn=*G*&* **  **+ *=*G*&* **  **+ *= **qrwxn@4**+**+*+qryznui*,**,**,**,**,qr{|n}~n n*n*n&***n***+*+~n<0*****|nn n=1**+,**+,*** !*qrn&**+"**+"*qrn<0*# *#$*%*%*+&*+&qrmn*%*%qrn<0*# *#$*%*%*+'*+'qrn*+(*+(qrn)*+,-)*+,-)qrn, *+,*:*+,*:qrn**,-+*,**,-**,-+*,**,-**./01*1*.2*1*3*4**5*6qrmn*78qrmn n **9%*9:**;<=,+>?:*@A**+,)B**+,)B*A*CD*CE*CF*CFcG*A*H*AIW*qrn*V*&* **  ,*J*JL**+KL**M*V*&* **  ,*J*JL**+NL**M*qrn**+O*+Oqrn&*P *Pqrn ,*9%*9:,*;<=:-*9*;QRN*S:T:-*U>* VWL+X,* *+,**++EY+Z+[+\,:,+]-EB:qr~n*^*^mn*_*_n*+`*+`qrn>2*+a***+b***+bqrn