0 ] ^ _` ab c d ef g h ij kl m n o p q rst u vw x y z { |} ~    i          v   v ` `  5  {    i       i O  F O v  O { | O Q        i  i    a]   r r g     a{   g h r v g y {   ~      ~           ]       i       h   hj         `{ ` h     `         i ia        ! " # $ %& '( ) i * i+ , i-./0123 4 5 i6 i7 8    9 i:;< INNERJOINI ConstantValue CROSSJOIN LEFTOUTERJOINRIGHTOUTERJOIN FULLOUTERJOIN UNIONJOIN naturalJoinZ optimizedleftPredicateList1Lorg/apache/derby/impl/sql/compile/PredicateList;rightPredicateListflattenableJoinaggregateVectorLjava/util/Vector; subqueryList0Lorg/apache/derby/impl/sql/compile/SubqueryList; joinClause-Lorg/apache/derby/impl/sql/compile/ValueNode;joinClauseNormalizedjoinPredicates usingClause4Lorg/apache/derby/impl/sql/compile/ResultColumnList;joinOrderStrategyPropertiesLjava/util/Properties;()VCodeinit(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)V Exceptions= 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;pushOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)ZmodifyAccessPathU(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/iapi/sql/compile/Optimizable;adjustNumberOfRowsReturned3(Lorg/apache/derby/iapi/sql/compile/CostEstimate;)VgetAllResultColumnsc(Lorg/apache/derby/impl/sql/compile/TableName;)Lorg/apache/derby/impl/sql/compile/ResultColumnList;getAllResultColumnsNoUsinggetMatchingColumne(Lorg/apache/derby/impl/sql/compile/ColumnReference;)Lorg/apache/derby/impl/sql/compile/ResultColumn;bindExpressions/(Lorg/apache/derby/impl/sql/compile/FromList;)VbindResultColumns(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;)VbuildRCLdeferredBindExpressionsgetCommonColumnsForNaturalJoin6()Lorg/apache/derby/impl/sql/compile/ResultColumnList;extractColumnNamesF(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)Ljava/util/List; preprocess(ILorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;projectResultColumnsnormExpressionspushExpressions4(Lorg/apache/derby/impl/sql/compile/PredicateList;)VpushExpressionsToLeftpushExpressionsToRightgrabJoinPredicatesflatten(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;)Lorg/apache/derby/impl/sql/compile/FromList;LOJ_reorderable(I)ZtransformOuterJoins](Lorg/apache/derby/impl/sql/compile/ValueNode;I)Lorg/apache/derby/impl/sql/compile/FromTable;generatet(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)V generateCoreu(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;I)V(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;ILorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/SubqueryList;)VgetJoinArguments(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;Lorg/apache/derby/impl/sql/compile/ValueNode;)IgetFinalCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate;oneRowRightSidegetNumJoinArguments()IaddOuterJoinArgumentst(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)IjoinTypeToString(I)Ljava/lang/String;getLeftPredicateList3()Lorg/apache/derby/impl/sql/compile/PredicateList;getRightPredicateListupdateTargetLockModenotFlattenableJoinisFlattenableJoinNode()Z isOrderedOnJ([Lorg/apache/derby/impl/sql/compile/ColumnReference;ZLjava/util/Vector;)Z printSubNodes(I)VsetSubqueryList3(Lorg/apache/derby/impl/sql/compile/SubqueryList;)VsetAggregateVector(Ljava/util/Vector;)VsetNaturalJoingetLogicalLeftResultSet3()Lorg/apache/derby/impl/sql/compile/ResultSetNode;getLogicalRightResultSetacceptChildren.(Lorg/apache/derby/iapi/sql/compile/Visitor;)VLOJgetReferencedTables'(I)Lorg/apache/derby/iapi/util/JBitSet;    >2org/apache/derby/impl/sql/compile/ResultColumnList ?+org/apache/derby/impl/sql/compile/ValueNode   java/util/Properties  @AB CD EF"org/apache/derby/iapi/util/JBitSet GH IA JK LM NOP QR/org/apache/derby/impl/sql/compile/PredicateList S TU VW FG XY ZA [\+org/apache/derby/impl/sql/compile/Predicate ]L ^P HG _` a> ab cde fg hg ij  klm no;org/apache/derby/iapi/sql/dictionary/ConglomerateDescriptorp qr st  uv wx y z{1org/apache/derby/impl/sql/compile/RemapCRsVisitor  | }~    VW       XW   3org/apache/derby/impl/sql/compile/HalfOuterJoinNode L |42X03   |.org/apache/derby/impl/sql/compile/ResultColumn 3org/apache/derby/impl/sql/compile/VirtualColumnNode   #$  ! "  $ $   P.org/apache/derby/impl/sql/compile/SubqueryListjava/util/Vector   Q*org/apache/derby/impl/sql/compile/FromList+org/apache/derby/impl/sql/compile/FromTable   PON 42Z07     Q1org/apache/derby/impl/sql/compile/ColumnReference>org/apache/derby/impl/sql/compile/BinaryComparisonOperatorNode  )org/apache/derby/impl/sql/compile/AndNode  L.org/apache/derby/iapi/types/DataTypeDescriptor      L   42Y12  W W %&   L Fjava/lang/String java/util/ArrayList  '( * '   )     -, +, ., /, D      45 8:    P-org/apache/derby/iapi/sql/compile/Optimizable l    ;<0org.apache.derby.iapi.sql.execute.NoPutResultSet  @A 67 P =>5org.apache.derby.iapi.services.loader.GeneratedMethod      BC ?7   java.lang.String d > L | L INNER JOIN CROSS JOINLEFT OUTER JOINRIGHT OUTER JOINFULL OUTER JOIN UNION JOIN J MN YZ  P [\*org/apache/derby/impl/sql/compile/JoinNode3org/apache/derby/impl/sql/compile/TableOperatorNode-org/apache/derby/iapi/error/StandardException9(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)V resultColumns leftResultSet1Lorg/apache/derby/impl/sql/compile/ResultSetNode;/org/apache/derby/impl/sql/compile/ResultSetNodegetReferencedTableMap&()Lorg/apache/derby/iapi/util/JBitSet;clone()Ljava/lang/Object;referencedTableMap$Lorg/apache/derby/iapi/util/JBitSet;rightResultSetor'(Lorg/apache/derby/iapi/util/JBitSet;)VgetNodeFactory1()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;+org/apache/derby/iapi/sql/compile/Optimizertrace(IIIDLjava/lang/Object;)VupdateBestPlanMap(SLjava/lang/Object;)VoptimizeSource(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;size elementAt4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; getPushableremoveElementAt addElement4(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;)VgetCostEstimate_(Lorg/apache/derby/iapi/sql/compile/Optimizer;)Lorg/apache/derby/iapi/sql/compile/CostEstimate; costEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;.org/apache/derby/iapi/sql/compile/CostEstimategetEstimatedCost()DrowCountsetCost(DDD)VgetCurrentAccessPath0()Lorg/apache/derby/iapi/sql/compile/AccessPath;,org/apache/derby/iapi/sql/compile/AccessPathgetJoinStrategy2()Lorg/apache/derby/iapi/sql/compile/JoinStrategy;.org/apache/derby/iapi/sql/compile/JoinStrategy estimateCost8(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;Lorg/apache/derby/iapi/sql/compile/CostEstimate;Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/CostEstimate;)V 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;)VgetDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;optimize9(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;D)VmodifyAccessPaths addPredicate0(Lorg/apache/derby/impl/sql/compile/Predicate;)V(Z)V getAndNode-()Lorg/apache/derby/impl/sql/compile/AndNode;acceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable;getJoinColumnsj(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)Lorg/apache/derby/impl/sql/compile/ResultColumnList;removeJoinColumns7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VresetVirtualColumnIdsdestructiveAppend:(Lorg/apache/derby/impl/sql/compile/QueryTreeNodeVector;)VnondestructiveAppendgetName()Ljava/lang/String;getResultColumnD(Ljava/lang/String;)Lorg/apache/derby/impl/sql/compile/ResultColumn;isRightOuterJoinsetRightOuterJoinUsingClausegetSQLColumnName newExceptionU(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;setNullability getExpression/()Lorg/apache/derby/impl/sql/compile/ValueNode;getSourceColumn2()Lorg/apache/derby/impl/sql/compile/ResultColumn;getResultColumnscopyListAndObjectssetResultColumnsgenVirtualColumnNodesi(Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Z)VadjustVirtualColumnIdsgetCompilerContext5()Lorg/apache/derby/iapi/sql/compile/CompilerContext;doJoinOrderOptimization()Ljava/lang/Boolean;}(ILjava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; 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;1org/apache/derby/iapi/sql/compile/CompilerContextsetReliability,org/apache/derby/impl/sql/compile/SelectNodecheckNoWindowFunctionsF(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;Ljava/lang/String;)VC(Ljava/lang/String;)Lorg/apache/derby/iapi/error/StandardException;java/lang/BooleanTRUELjava/lang/Boolean;insertElementAt5(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;I)V getTableName/()Lorg/apache/derby/impl/sql/compile/TableName;(ILjava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;bindComparisonOperator postBindFixuprequiresTypeFromContext"org/apache/derby/iapi/types/TypeId BOOLEAN_ID$Lorg/apache/derby/iapi/types/TypeId;((Lorg/apache/derby/iapi/types/TypeId;Z)VsetType3(Lorg/apache/derby/iapi/types/DataTypeDescriptor;)V getTypeId&()Lorg/apache/derby/iapi/types/TypeId;userTypegenSQLJavaSQLTreegetTypeServices2()Lorg/apache/derby/iapi/types/DataTypeDescriptor;equals(Ljava/lang/Object;)ZgetSQLTypeNamegetLeftResultSetgetRightResultSetjava/util/List retainAll(Ljava/util/Collection;)Ziterator()Ljava/util/Iterator;java/util/IteratorhasNextnextaddResultColumn3(Lorg/apache/derby/impl/sql/compile/ResultColumn;)Vadd(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;pullExpressions1(ILorg/apache/derby/impl/sql/compile/ValueNode;)V categorizepullVirtualIsReferenced eliminateNots0(Z)Lorg/apache/derby/impl/sql/compile/ValueNode; putAndsOnTop changeToCNFgetReferencedSetcontains'(Lorg/apache/derby/iapi/util/JBitSet;)Z setRedundant"remapColumnReferencesToExpressions-org/apache/derby/impl/sql/compile/GroupByListrestorePredicatesassignResultSetNumberresultSetNumbersetPointOfAttachmentgetTrulyTheBestAccessPath halfOuterJoinResultSetMethodNamejoinResultSetMethodName8org/apache/derby/impl/sql/compile/ActivationClassBuilder!pushGetResultSetFactoryExpression:(Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)V5org/apache/derby/iapi/services/compiler/MethodBuilder callMethod;(SLjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)IpushpushNull(Ljava/lang/String;)VnewUserExprFun9()Lorg/apache/derby/iapi/services/compiler/MethodBuilder; methodReturncompletepushMethodReferenceq(Lorg/apache/derby/iapi/services/compiler/MethodBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)V(D)V'org/apache/derby/iapi/util/PropertyUtilsortProperties*(Ljava/util/Properties;)Ljava/lang/String;finalCostEstimategetNewCostEstimateisOneRowResultSet isNotExists!1    **   u*+,**-** * *,* "** ** *** 0$+****+* *- *d64*:* *!"**+**!* #**+$%*%* #&*#&c*#'*#'(**%)**+*,,-+*%-+*,*%-.*/'*0 *0+1*%'2*03*/*% ."*+45Y6M+7,8W *+9W*  * *+:*;M,<* =N* +<:*+<: * > * >? ?-@-@-?- K?* +6* NO:+* s*>D* ht*uv:+*0*cwv:+x+*s*>D*ht*uv:+*0*cwv:+x*)*uy:z*'**u{:  |* '*_*}*~Y*N-****K#$ t*2********+, <0* hM*hN*+,**+-*!*+-, v* hM,N+d6^+:B:-2*45Y6:78W78W+ ., v*hM,N+d6^+:B:-2*!45Y6:78W78W+ /,  * hM*hN,:-:+d6p+:T::   2*45Y6: 7 8W7 8W+ 01 *%*e*fg:* hi*hi*+, W* ,**0*0 -*023 45 NB+* hW*hW*** h+ **h+*67  *+,89 *+,**08: **:** **+:*+:+,*+,6,W;< *6* +,,* M*+,,*M**µ%-,ù%+:-++,,**+,W*+,,*%',*%&* ,* ͹ ,Ϲ=> WK**а* L*M**ҵ*+&,&c,','(*а?7 ',*ӹ,*չ@A  BC  DE H<9'*-036ְװذٰڰ۰FG , *****ܰHG , *****ݰIA J  ** *ޱKL *MN  * +-߬OP QR *+0ST *+cU  *TVW * XW *YZ j^*+***+***+* ** + ***+[\ 2&YM* M,,*,