0          !" # $ % &' 3( ) &* + , 3- <' . /0 12 !3 4 &5 6 7 8 9 : T/ T;< ,= ,> ? @ A BCD 3/ 31E 6F 3G 3H I BJKL =M BN 6O 6P 6Q R BSTU VW X GY =Z ![\ N] ^_ =/ =` 3ab T c d ae fg Yh Yi j kl km n o p qr s t u v wxy <z {| k} k~ q / ` u 6 6     6 u u  u u u u= 3  , T          & B B    & &  &     &   3 3       u u  5           InnerClassesExpressionSorter groupingList/Lorg/apache/derby/impl/sql/compile/GroupByList;aggregateVectorLjava/util/Vector;aggInfo6Lorg/apache/derby/impl/sql/execute/AggregatorInfoList;parent-Lorg/apache/derby/impl/sql/compile/FromTable;addDistinctAggregateZsingleInputRowOptimizationaddDistinctAggregateColumnNumIisInSortedOrder havingClause-Lorg/apache/derby/impl/sql/compile/ValueNode;havingSubquerys0Lorg/apache/derby/impl/sql/compile/SubqueryList;5class$org$apache$derby$impl$sql$compile$AggregateNodeLjava/lang/Class; Synthetic7class$org$apache$derby$impl$sql$compile$ColumnReference5class$org$apache$derby$impl$sql$compile$ResultSetNode()VCodeinit(Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;)V ExceptionsgetIsInSortedOrder()Z addAggregatesaddDistinctAggregatesToOrderBy addNewPRNodeaddUnAggColumns()Ljava/util/ArrayList;addNewColumnsForAggregationaddAggregateColumns getParent/()Lorg/apache/derby/impl/sql/compile/FromTable; 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; estimateCost7(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/RowOrdering;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;pushOptPredicate;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)ZtoString()Ljava/lang/String; printSubNodes(I)VflattenableInFromSubquery/(Lorg/apache/derby/impl/sql/compile/FromList;)Zoptimize(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/impl/sql/compile/PredicateList;D)Lorg/apache/derby/impl/sql/compile/ResultSetNode;makeResultDescriptors5()[Lorg/apache/derby/iapi/sql/ResultColumnDescriptor;isOneRowResultSetgeneratet(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VgenScalarAggregateResultSetgenGroupedAggregateResultSetgetColumnReference(Lorg/apache/derby/impl/sql/compile/ResultColumn;Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)Lorg/apache/derby/impl/sql/compile/ResultColumn;!considerPostOptimizeOptimizations(Z)Vclass$%(Ljava/lang/String;)Ljava/lang/Class;  java/lang/ClassNotFoundExceptionjava/lang/NoClassDefFoundError  java/lang/Integer  +org/apache/derby/impl/sql/compile/ValueNode .org/apache/derby/impl/sql/compile/SubqueryList -org/apache/derby/impl/sql/compile/GroupByList java/util/Vector        1org/apache/derby/impl/sql/compile/ColumnReference /org/apache/derby/impl/sql/compile/GroupByColumn    0org/apache/derby/impl/sql/execute/AggregatorInfo     2org/apache/derby/impl/sql/compile/ResultColumnList.org/apache/derby/impl/sql/compile/ResultColumn     +org/apache/derby/impl/sql/compile/FromTablejava/util/ArrayList ##UnaggColumn        3org/apache/derby/impl/sql/compile/VirtualColumnNode=org/apache/derby/impl/sql/compile/SubstituteExpressionVisitor /org.apache.derby.impl.sql.compile.AggregateNode    >org/apache/derby/impl/sql/compile/GroupByNode$ExpressionSorter    4org/apache/derby/impl/sql/execute/AggregatorInfoList 5org/apache/derby/impl/sql/compile/CollectNodesVisitor 1org.apache.derby.impl.sql.compile.ColumnReference      ! " # $42X24 % &' () *+, -.@org/apache/derby/impl/sql/compile/ReplaceAggregatesWithCRVisitor / /org.apache.derby.impl.sql.compile.ResultSetNode 0 15org/apache/derby/impl/sql/compile/ProjectRestrictNode 23/org/apache/derby/impl/sql/compile/AggregateNode##aggregate result 4 5 6 78 9 : ; < => ?@   A@ B C SELECTD EF G H-org/apache/derby/iapi/sql/compile/Optimizable IJK LM NM OM PQ  RS T*org/apache/derby/impl/sql/compile/FromList5org/apache/derby/iapi/sql/compile/RequiredRowOrdering UVW XY Z[ IY \ ]Y^ _` ab cd ef  g h h ij k l     #getDistinctScalarAggregateResultSetgetScalarAggregateResultSet hmjava/lang/String0org.apache.derby.iapi.sql.execute.NoPutResultSet no$getDistinctGroupedAggregateResultSetgetGroupedAggregateResultSet pq;org/apache/derby/impl/sql/compile/MaxMinAggregateDefinition r s tuv wxy z{| }~   /org/apache/derby/impl/sql/compile/FromBaseTable   .org/apache/derby/impl/sql/compile/ConstantNode-org/apache/derby/impl/sql/compile/GroupByNode:org/apache/derby/impl/sql/compile/SingleChildResultSetNode/org/apache/derby/impl/sql/compile/GroupByNode$1-org/apache/derby/iapi/error/StandardExceptionjava/lang/ClassforName initCause,(Ljava/lang/Throwable;)Ljava/lang/Throwable;'(Ljava/lang/Object;Ljava/lang/Object;)VintValue()IsetLevel childResult1Lorg/apache/derby/impl/sql/compile/ResultSetNode;/org/apache/derby/impl/sql/compile/ResultSetNodegetResultColumns6()Lorg/apache/derby/impl/sql/compile/ResultColumnList;copyListAndObjects resultColumns4Lorg/apache/derby/impl/sql/compile/ResultColumnList;setResultColumns7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VisRollupsetNullabilitysize elementAt4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;getColumnExpression/()Lorg/apache/derby/impl/sql/compile/ValueNode; isOrderedOnJ([Lorg/apache/derby/impl/sql/compile/ColumnReference;ZLjava/util/Vector;)ZnumDistinctAggregates(Ljava/util/Vector;)I(I)Ljava/lang/Object; isDistinctgetInputColNumgetNodeFactory1()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; isGenerated addElement4(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;)VcopyOrderBySelecttablePropertiesLjava/util/Properties;(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;(ILjava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; markGeneratedbindResultColumnToExpressionsetVirtualColumnId(ILjava/lang/Object;Ljava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;n(Lorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/ValueNode;Ljava/lang/Class;)Vadd(Ljava/lang/Object;)ZsetColumnPosition4(Lorg/apache/derby/impl/sql/compile/GroupByNode$1;)Vjava/util/Collectionssort)(Ljava/util/List;Ljava/util/Comparator;)VgetacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable;%(Ljava/lang/Class;Ljava/lang/Class;)VgetList()Ljava/util/Vector;iterator()Ljava/util/Iterator;java/util/IteratorhasNextnext()Ljava/lang/Object;getGeneratedToReplaceAggregate'getGeneratedToReplaceWindowFunctionCallgetSourceLevellevelgetSQLColumnName newExceptionU(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException;getDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;getLanguageConnectionContext<()Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;8org/apache/derby/iapi/sql/conn/LanguageConnectionContextgetLanguageFactory-()Lorg/apache/derby/iapi/sql/LanguageFactory;getTableNumberI(Lorg/apache/derby/impl/sql/compile/ResultColumnList;ILjava/lang/Class;)V8(Lorg/apache/derby/impl/sql/compile/ResultColumnList;I)VsetRestriction0(Lorg/apache/derby/impl/sql/compile/ValueNode;)VgetNewNullResultExpressiongetVirtualColumnIdgetName setSource3(Lorg/apache/derby/impl/sql/compile/ResultColumn;)VgetLevelsetNestingLevelsetSourceLevel getColumnNamegetGeneratedRef5()Lorg/apache/derby/impl/sql/compile/ColumnReference;getNewExpressionResultColumng(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)Lorg/apache/derby/impl/sql/compile/ResultColumn;getNewAggregatorResultColumngetAggregateNamegetAggregatorClassName)org/apache/derby/iapi/sql/LanguageFactorygetResultDescriptiont([Lorg/apache/derby/iapi/sql/ResultColumnDescriptor;Ljava/lang/String;)Lorg/apache/derby/iapi/sql/ResultDescription;X(Ljava/lang/String;Ljava/lang/String;IIIZLorg/apache/derby/iapi/sql/ResultDescription;)V(Ljava/lang/Object;)VgetCostEstimate_(Lorg/apache/derby/iapi/sql/compile/Optimizer;)Lorg/apache/derby/iapi/sql/compile/CostEstimate;.org/apache/derby/iapi/sql/compile/CostEstimategetEstimatedCost()DrowCountsingleScanRowCountsetCost(DDD)VdoJoinOrderOptimization()Ljava/lang/Boolean;}(ILjava/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;+org/apache/derby/iapi/sql/compile/OptimizernewCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate; costEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;assignResultSetNumbergetFinalCostEstimate8org/apache/derby/impl/sql/compile/ActivationClassBuildergetColumnOrderingp(Lorg/apache/derby/impl/sql/compile/OrderedColumnList;)Lorg/apache/derby/iapi/services/io/FormatableArrayHolder;addColumnToOrderingu(Lorg/apache/derby/iapi/services/io/FormatableArrayHolder;I)Lorg/apache/derby/iapi/services/io/FormatableArrayHolder;addItem(Ljava/lang/Object;)I!pushGetResultSetFactoryExpression:(Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)V5org/apache/derby/iapi/services/compiler/MethodBuilderpushgenerateHoldert(Lorg/apache/derby/impl/sql/compile/ExpressionClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VgetTotalColumnSizeresultSetNumber(D)V callMethod;(SLjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)IgetAggregateDefinition9()Lorg/apache/derby/impl/sql/compile/AggregateDefinition; getOperandgetColumnNumbergetTrulyTheBestAccessPath0()Lorg/apache/derby/iapi/sql/compile/AccessPath;,org/apache/derby/iapi/sql/compile/AccessPathgetConglomerateDescriptor?()Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;;org/apache/derby/iapi/sql/dictionary/ConglomerateDescriptorgetIndexDescriptor:()Lorg/apache/derby/iapi/sql/dictionary/IndexRowGenerator;(org/apache/derby/catalog/IndexDescriptorbaseColumnPositions()[I isAscending()[Z firstElementisMaxdisableBulkFetchdoSpecialMaxScan! *  *+* * * *,*-***:***** ****v,r*: *6 6   :* !:  "   "S *#   ** $#*# *%*&*'VJ*(<@M*)*>6 *)+,M,- **,./ *0 *123L*4=>$*56:7 +8+*9**0*+**:*1;<**0 *123**0 *123zn*L*M=Y>N:* =Y>:*66* !:*0P?"*1@6:+8AB+4C*0P?"*1@6: , 8 A B ,4C*0k* Y,4D*1EF: ": GY  HIJYHHK: - LW* GY  K:  LW+4MNYO:-P6-Q*-RGSW P*TYU)L**VL*W* +#=+Q* +RGXWYYZ[JYZZHIJYHH\M* ,XW,]^N-_8-`:a"bc*defgű[ O*hLM*:*:*ij: kY*0 *123*<lmnJYmmo:*SW* BkY*0 *123*<lp:* XW*q:* r*s66*tuM*0Pv,w*1@6:AB84Cx6 *0>y*1@N-z-*{|-*{}*0P~-*1@6:AB84C,N-z,+:AB84Cx6 :*+:84C,+:AB84Cx6 *+:84C*0 *123:  8*),Y,, d d d,  m*-!*+,-:*+,-:H<*+,-:*:*+ zn**+,)<**0%*0*1,+:*******#* * >6***+*:*+*/:+>+*)6+,*+,,*#,,*+,,*,** * *+, *+,  WK*N,*,*,*,- W  ZN*N,*,*,*,- W  [O*0>+y*1@N-+z-*{|-*{}*0P+~-*1@6:ABWK*F*s;*tuM,N-#, :,SY:*6626*:     :  :  : 6   !  .  36 : -:Ěę *0,ęĚ  *,Ǚ*&*LY+N