0 \? @ \AB CD EF GH I JK L MN M O P \P \Q Q R S \R T \U U V W X Y Z[ Z\ Z] Z^ _ `a Tb TW c `de +f g \g h \h i \i j \j k \l l m \m n \n o p qrs t ?uv Bw ?x yz { | } ~  T  Q   R U  T  l U \k T  x a      T  T  z   q  \   \ U  T x  U  } } }  +  q q  ` Tc  T c      T T          |   |                   T T   x   q  T T ?     T T \ z T T T restriction-Lorg/apache/derby/impl/sql/compile/ValueNode;constantRestrictionrestrictionList1Lorg/apache/derby/impl/sql/compile/PredicateList;projectSubquerys0Lorg/apache/derby/impl/sql/compile/SubqueryList;restrictSubquerysaccessPathModifiedZaccessPathConsideredchildResultOptimized materializegetTableNumberHere()VCodeinit(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)VnextAccessPath(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)Z ExceptionsrememberAsBest1(ILorg/apache/derby/iapi/sql/compile/Optimizer;)VprintRememberingBestAccessPath2(ILorg/apache/derby/iapi/sql/compile/AccessPath;)VstartOptimizing_(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)VgetTableNumber()I optimizeIt(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;feasibleJoinStrategyl(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/Optimizer;)ZgetCurrentAccessPath0()Lorg/apache/derby/iapi/sql/compile/AccessPath;getBestAccessPathgetBestSortAvoidancePathgetTrulyTheBestAccessPathrememberSortAvoidancePathconsiderSortAvoidancePath()ZpushOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)ZpullOptPredicates?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)VmodifyAccessPathU(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/iapi/sql/compile/Optimizable;replaceWithHashTableNode1()Lorg/apache/derby/iapi/sql/compile/Optimizable;verifyProperties8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)VlegalJoinOrder'(Lorg/apache/derby/iapi/util/JBitSet;)Z uniqueJoin?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)DgetRestrictionList3()Lorg/apache/derby/impl/sql/compile/PredicateList;getUserSpecifiedJoinStrategy()Ljava/lang/String; printSubNodes(I)V preprocess(ILorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;pushExpressions4(Lorg/apache/derby/impl/sql/compile/PredicateList;)VaddNewPredicate`(Lorg/apache/derby/impl/sql/compile/Predicate;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;flattenableInFromSubquery/(Lorg/apache/derby/impl/sql/compile/FromList;)ZensurePredicateList4(I)Lorg/apache/derby/impl/sql/compile/ResultSetNode;optimize(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/PredicateList;D)Lorg/apache/derby/impl/sql/compile/ResultSetNode;getCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate;getFinalCostEstimategeneratet(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VgenerateResultSett(Lorg/apache/derby/impl/sql/compile/ExpressionClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VgenerateMinionu(Lorg/apache/derby/impl/sql/compile/ExpressionClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;Z)VnopProjectRestrictgenerateNOPProjectRestrictconsiderMaterializationW(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;getFromTableByNameT(Ljava/lang/String;Ljava/lang/String;Z)Lorg/apache/derby/impl/sql/compile/FromTable;updateTargetLockModeisPossibleDistinctScan(Ljava/util/Set;)ZmarkForDistinctScanacceptChildren.(Lorg/apache/derby/iapi/sql/compile/Visitor;)VsetRefActionInfo(J[ILjava/lang/String;Z)VsetRestriction0(Lorg/apache/derby/impl/sql/compile/ValueNode;)VpushOrderByList2(Lorg/apache/derby/impl/sql/compile/OrderByList;)VpushOffsetFetchFirst](Lorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/ValueNode;)V 2org/apache/derby/impl/sql/compile/ResultColumnList +org/apache/derby/impl/sql/compile/ValueNode /org/apache/derby/impl/sql/compile/PredicateList .org/apache/derby/impl/sql/compile/SubqueryList -org/apache/derby/iapi/sql/compile/Optimizable  java/util/Properties  "             ! "# +org/apache/derby/impl/sql/compile/UnionNode       !+org/apache/derby/impl/sql/compile/Predicate "# $1org/apache/derby/impl/sql/compile/RemapCRsVisitor % &'( )* + , -./ 01 2 34 56 789 : -./org/apache/derby/impl/sql/compile/FromBaseTable0org/apache/derby/impl/sql/compile/AccessPathImpl1org/apache/derby/impl/sql/compile/SetOperatorNode ;/org/apache/derby/impl/sql/compile/ResultSetNode+org/apache/derby/impl/sql/compile/FromTable  <= >?  :org/apache/derby/impl/sql/compile/SingleChildResultSetNode @A BC D EF GH 21 IJ K LM NM OP QR ST UV  W       XY  Z["org/apache/derby/iapi/util/JBitSet \]*org/apache/derby/impl/sql/compile/JoinNode  ^_,org/apache/derby/impl/sql/compile/SelectNode ` a b cd ef gh  i*org/apache/derby/impl/sql/compile/FromList5org/apache/derby/iapi/sql/compile/RequiredRowOrdering jk l# m $#n)org/apache/derby/impl/sql/compile/FromVTI o )* p + , '(8org/apache/derby/impl/sql/compile/ActivationClassBuilder %& qr s tr uxy z{ |}>org/apache/derby/catalog/types/ReferencedColumnsDescriptorImpl ~     C 5org.apache.derby.iapi.services.loader.GeneratedMethod   (    *   % java/lang/StringgetProjectRestrictResultSet0org.apache.derby.iapi.sql.execute.NoPutResultSet     9org/apache/derby/impl/sql/compile/ReferencedTablesVisitor  A  Q  :org/apache/derby/impl/sql/compile/MaterializeResultSetNode  /0 1java/util/HashSet.org/apache/derby/impl/sql/compile/ResultColumn    23 4 56 78 ;< =>5org/apache/derby/impl/sql/compile/ProjectRestrictNode-org/apache/derby/iapi/error/StandardException'(Ljava/lang/Object;Ljava/lang/Object;)V resultColumns4Lorg/apache/derby/impl/sql/compile/ResultColumnList; getProperties()Ljava/util/Properties; setProperties(Ljava/util/Properties;)V childResult1Lorg/apache/derby/impl/sql/compile/ResultSetNode;_(Lorg/apache/derby/iapi/sql/compile/Optimizer;)Lorg/apache/derby/iapi/sql/compile/CostEstimate; costEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;updateBestPlanMap(SLjava/lang/Object;)V.org/apache/derby/iapi/sql/compile/CostEstimategetEstimatedCost()DrowCountsingleScanRowCountsetCost(DDD)V+org/apache/derby/iapi/sql/compile/OptimizergetDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary; considerCost(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VhasTrulyTheBestAccessPathgetNodeFactory1()Lorg/apache/derby/iapi/sql/compile/NodeFactory;getContextManager9()Lorg/apache/derby/iapi/services/context/ContextManager;-org/apache/derby/iapi/sql/compile/NodeFactorygetNodek(ILorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; addPredicate0(Lorg/apache/derby/impl/sql/compile/Predicate;)VremapScopedPred(Z)V getAndNode-()Lorg/apache/derby/impl/sql/compile/AndNode;)org/apache/derby/impl/sql/compile/AndNodeacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable; isNotExistssizegetOptPredicate;(I)Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;:org/apache/derby/iapi/sql/compile/OptimizablePredicateListaddOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)VremoveOptPredicatemodifyAccessPathsd(Lorg/apache/derby/impl/sql/compile/PredicateList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;trulyTheBestAccessPath2Lorg/apache/derby/impl/sql/compile/AccessPathImpl;getJoinStrategy2()Lorg/apache/derby/iapi/sql/compile/JoinStrategy;.org/apache/derby/iapi/sql/compile/JoinStrategy isHashJoin(Lorg/apache/derby/iapi/util/JBitSet;Lorg/apache/derby/impl/sql/compile/PredicateList;)Lorg/apache/derby/iapi/sql/compile/Optimizable;pushUsefulPredicates2(Lorg/apache/derby/iapi/sql/compile/Optimizable;)VchangeAccessPath3()Lorg/apache/derby/impl/sql/compile/ResultSetNode;getReferencedTableMap&()Lorg/apache/derby/iapi/util/JBitSet; tableNumberIsetdivideUpPredicateListsW(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)V elementAt4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;transferNonQualifiersc(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/impl/sql/compile/PredicateList;)VcopyPredicatesToOtherListgetResultColumns6()Lorg/apache/derby/impl/sql/compile/ResultColumnList;copyListAndObjectssetResultColumns7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VgenVirtualColumnNodesi(Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Z)VtablePropertiesLjava/util/Properties;hashKeyColumns()[I(ILjava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/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;userSpecifiedJoinStrategyLjava/lang/String;clone()Ljava/lang/Object;referencedTableMap$Lorg/apache/derby/iapi/util/JBitSet;getPushablePredicatesW(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/impl/sql/compile/PredicateList; hasWindows fetchFirstoffsetpushExpressionsIntoSelect2(Lorg/apache/derby/impl/sql/compile/SelectNode;Z)VdestructiveAppend:(Lorg/apache/derby/impl/sql/compile/QueryTreeNodeVector;)VdoJoinOrderOptimization()Ljava/lang/Boolean;(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;newCostEstimatefinalCostEstimate,org/apache/derby/iapi/sql/compile/AccessPathcomputeProjectionAndRestriction"eliminateBooleanTrueAndBooleanTruerestoreConstantPredicates/()Lorg/apache/derby/impl/sql/compile/ValueNode;removeRedundantPredicatesrestorePredicatesmapSourceColumns ColumnMapping InnerClassesD()Lorg/apache/derby/impl/sql/compile/ResultColumnList$ColumnMapping;@org/apache/derby/impl/sql/compile/ResultColumnList$ColumnMappingmapArray[IcloneMap[Z([I)V8org/apache/derby/impl/sql/compile/ExpressionClassBuilderaddItem(Ljava/lang/Object;)IreflectionNeededForProjection!pushGetResultSetFactoryExpression:(Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VassignResultSetNumberresultSetNumbersetPointOfAttachment5org/apache/derby/iapi/services/compiler/MethodBuilderpushNull(Ljava/lang/String;)VnewUserExprFun9()Lorg/apache/derby/iapi/services/compiler/MethodBuilder;generateExpression methodReturncompletepushMethodReferenceq(Lorg/apache/derby/iapi/services/compiler/MethodBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)V generateCorepushreusableResult(D)V callMethod;(SLjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)I nopProjection7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)Z setRedundantperformMaterialization'(Lorg/apache/derby/iapi/util/JBitSet;)V getTableMapcontainsh(Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/ResultColumnList;)V(ILjava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;setReferencedTableMapgetBaseColumnNode4()Lorg/apache/derby/impl/sql/compile/BaseColumnNode;add(Ljava/lang/Object;)Zequals!\ 0 **`T*+*,*-* * * + + **1%* * +* -*+,-+*,* * , 3'* * +,**+,4(*** * ***+*** :* +* - :*!"#$\*%U**+&* -"'*(:*!"#$+** *)-**J>* -*+*+* ,* * ,-** ,.(* * /*0(* * 1*2(* * 3*44(*5*6* * 7*6** * 8*9(* * :*;RF* **<*=> * +?@+?M,ABYCN,D-EWwk* f*F_*+*+* ,BYCM* Gd>0* H:?D,EW+I* Jұ7+=*%*>* 9=*** K*5*LMN *j*+O *PW*LM** 7QL*R**R+* ST>**U+VT*5 *LM*LMN6* * * W**X*%*LM*LMN*Y*+O  fZ*5:*U*ZQ[*\*\*5]*^*_`*<*=>L*<*=>M*<*=>N*LM** +,-*ab**<*=> 6+G-+c?d6,G-,c?d,** e-* f*g:*hi**gjBYC:+kW**<**l+,*L*)* * *m*=nT*  , * * +o*+p  &* * +q** * +r*+s* &*U*Ut*u -!**,-v**^wxy*M*z*U+{+*y|M,9*}/*}N-~ --,*},*+*+,* *, ,,G * ,1%* **<*=> * +@** !{o**+* )'**<%*<**=,+:***!*"*#$*"# * **$#B6*** ****Z*%&, *** *+,'(*+,)*I =* * G * */**+,*+,*** %** * ** * *:::+Y6+66 *C>*g.6   . `  6 +,*+,*+,** * * ** * * ****,(+: *+   +, **+, ,,**,(+: *+   +, ,,,*, ,*",*!, W+F:*** * G*gL*M,+,*-.**+*+Y*^wx:* * G6 * kW*^J*N**h-***<y*-*l*=M*y,*ywx,*gN*-hi-**g*<y*-*l*=M*^,*^wx*,*/0 *+,ư1%* **Ǭ23|p** * GYM>*+*::,W,+Ι*+ϙ4*б56>2*+***+* ** +k 78*-ӱ9:*+;< *+Ա=> *+,ձw v