0i /0 -1 -2 -3 -4 56 -7 <8 <9 <:; < _= > _? -@A -B -C DE _F GH DIJ K > ? L <M DNO <PQ "R <S <T <U VW <X <Y <Z <[ D\] -^ <_ <` -a <b <c d ef g -h <i jk -l Dmn <o jp jq jr -s <t u v wx yz y{| y} y~ - H - - _ _> y 5  -   Y z Y? Y Y  - b/ b b  5  j -W  -_ -  - < -   -      -  5     <   b  - P9 P    resultSetNumberIreferencedTableMap$Lorg/apache/derby/iapi/util/JBitSet; resultColumns4Lorg/apache/derby/impl/sql/compile/ResultColumnList;statementResultSetZcursorTargetTable insertSource costEstimate0Lorg/apache/derby/iapi/sql/compile/CostEstimate;scratchCostEstimate optimizer-Lorg/apache/derby/iapi/sql/compile/Optimizer;finalCostEstimate()VCodetoString()Ljava/lang/String; printSubNodes(I)VgetResultSetNumber()IgetCostEstimate2()Lorg/apache/derby/iapi/sql/compile/CostEstimate;getFinalCostEstimate ExceptionsassignResultSetNumberbindNonVTITables(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;)VbindExpressionsWithTablesbindTargetExpressionssetTableConstructorTypes7(Lorg/apache/derby/impl/sql/compile/ResultColumnList;)VsetInsertSourceverifySelectStarSubquery0(Lorg/apache/derby/impl/sql/compile/FromList;I)VgetAllResultColumnsc(Lorg/apache/derby/impl/sql/compile/TableName;)Lorg/apache/derby/impl/sql/compile/ResultColumnList;getMatchingColumne(Lorg/apache/derby/impl/sql/compile/ColumnReference;)Lorg/apache/derby/impl/sql/compile/ResultColumn;setResultToBooleanTrueNode4(Z)Lorg/apache/derby/impl/sql/compile/ResultSetNode; getFromList.()Lorg/apache/derby/impl/sql/compile/FromList;bindResultColumns(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;)VbindUntypedNullsToResultColumns preprocess(ILorg/apache/derby/impl/sql/compile/GroupByList;Lorg/apache/derby/impl/sql/compile/FromList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;projectResultColumnsensurePredicateList4(I)Lorg/apache/derby/impl/sql/compile/ResultSetNode;addNewPredicate`(Lorg/apache/derby/impl/sql/compile/Predicate;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;flattenableInFromSubquery/(Lorg/apache/derby/impl/sql/compile/FromList;)ZgenProjectRestrictForReordering3()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;modifyAccessPathsd(Lorg/apache/derby/impl/sql/compile/PredicateList;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;makeResultDescriptors5()[Lorg/apache/derby/iapi/sql/ResultColumnDescriptor;columnTypesAndLengthsMatch()ZsetResultColumnsgetResultColumns6()Lorg/apache/derby/impl/sql/compile/ResultColumnList;setReferencedTableMap'(Lorg/apache/derby/iapi/util/JBitSet;)VgetReferencedTableMap&()Lorg/apache/derby/iapi/util/JBitSet;fillInReferencedTableMaprejectParametersrejectXMLValuesrenameGeneratedResultNamesmarkStatementResultSetenhanceRCLForInsertd(Lorg/apache/derby/impl/sql/compile/InsertNode;Z[I)Lorg/apache/derby/impl/sql/compile/ResultSetNode;getRCLForInsertf(Lorg/apache/derby/impl/sql/compile/InsertNode;[I)Lorg/apache/derby/impl/sql/compile/ResultColumnList;genNewRCForInsert(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/impl/sql/compile/FromVTI;ILorg/apache/derby/iapi/sql/dictionary/DataDictionary;)Lorg/apache/derby/impl/sql/compile/ResultColumn; generateProjectRestrictForInsertc(Lorg/apache/derby/impl/sql/compile/InsertNode;[I)Lorg/apache/derby/impl/sql/compile/ResultSetNode;createGeneratedColumn(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/iapi/sql/dictionary/ColumnDescriptor;)Lorg/apache/derby/impl/sql/compile/ResultColumn; parseDefaultA(Ljava/lang/String;)Lorg/apache/derby/impl/sql/compile/ValueNode;makeResultDescription/()Lorg/apache/derby/iapi/sql/ResultDescription;isUpdatableCursor8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)ZgetCursorTargetTable/()Lorg/apache/derby/impl/sql/compile/FromTable;markAsCursorTargetTablenotCursorTargetTablegenProjectRestrictgenerateNormalizationResultSet(Lorg/apache/derby/impl/sql/compile/ActivationClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;ILorg/apache/derby/iapi/sql/ResultDescription;)VchangeAccessPathreferencesTarget(Ljava/lang/String;Z)ZsubqueryReferencesTargetisOneRowResultSet isNotExists 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;getOptimizerImpl3()Lorg/apache/derby/impl/sql/compile/OptimizerImpl;getNewCostEstimateacceptChildren.(Lorg/apache/derby/iapi/sql/compile/Visitor;)VconsiderMaterializationW(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/impl/sql/compile/ResultSetNode;performMaterialization'(Lorg/apache/derby/iapi/util/JBitSet;)ZgetFromTableByNameT(Ljava/lang/String;Ljava/lang/String;Z)Lorg/apache/derby/impl/sql/compile/FromTable;decrementLevelpushOrderByList2(Lorg/apache/derby/impl/sql/compile/OrderByList;)VpushOffsetFetchFirst](Lorg/apache/derby/impl/sql/compile/ValueNode;Lorg/apache/derby/impl/sql/compile/ValueNode;)VgenerateResultSett(Lorg/apache/derby/impl/sql/compile/ExpressionClassBuilder;Lorg/apache/derby/iapi/services/compiler/MethodBuilder;)VupdateTargetLockModenotFlattenableJoin isOrderedOnJ([Lorg/apache/derby/impl/sql/compile/ColumnReference;ZLjava/util/Vector;)ZreturnsAtMostOneRowreplaceOrForbidDefaultsn(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Z)VisPossibleDistinctScan(Ljava/util/Set;)ZmarkForDistinctScanadjustForSortElimination:(Lorg/apache/derby/iapi/sql/compile/RequiredRowOrdering;)VnumDistinctAggregates(Ljava/util/Vector;)ILOJgetReferencedTables'(I)Lorg/apache/derby/iapi/util/JBitSet;      .org/apache/derby/impl/sql/compile/ResultColumn     1org/apache/derby/impl/sql/compile/AllResultColumn      5org/apache/derby/impl/sql/compile/BooleanConstantNode    *org/apache/derby/impl/sql/compile/FromList ,org/apache/derby/impl/sql/compile/SelectNode         /org/apache/derby/impl/sql/compile/ResultSetNode       2org/apache/derby/impl/sql/compile/ResultColumnList            .org/apache/derby/catalog/types/DefaultInfoImpl    .org/apache/derby/impl/sql/compile/SubqueryListjava/util/Vector !" #$ %& ' () * +1org/apache/derby/impl/sql/compile/ColumnReference , - .+org/apache/derby/impl/sql/compile/ValueNode /0 12java/lang/StringBufferVALUES 34 5 6 789 :;,org/apache/derby/impl/sql/compile/CursorNode < => ?@A BC D E FGH I J KL IM NL IOjava/lang/StringgetNormalizeResultSet0org.apache.derby.iapi.sql.execute.NoPutResultSet PQ RS TU  VW X/org/apache/derby/impl/sql/compile/OptimizerImpl  YZ[ \]I am a ^ _` 3ab c ) de/org/apache/derby/impl/sql/compile/AggregateNode f+org/apache/derby/impl/sql/compile/FromTable g"org/apache/derby/iapi/util/JBitSet h/org/apache/derby/impl/sql/compile/QueryTreeNode-org/apache/derby/iapi/error/StandardExceptiongetCompilerContext5()Lorg/apache/derby/iapi/sql/compile/CompilerContext;1org/apache/derby/iapi/sql/compile/CompilerContextgetNextResultSetNumbersetResultSetNumbersize elementAt4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; getExpression/()Lorg/apache/derby/impl/sql/compile/ValueNode;requiresTypeFromContextgetTypeServices2()Lorg/apache/derby/iapi/types/DataTypeDescriptor;setType3(Lorg/apache/derby/iapi/types/DataTypeDescriptor;)VgetNodeFactory1()Lorg/apache/derby/iapi/sql/compile/NodeFactory;getContextManager9()Lorg/apache/derby/iapi/services/context/ContextManager;-org/apache/derby/iapi/sql/compile/NodeFactorygetNode(ILjava/lang/Object;Ljava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; isBooleanTruejava/lang/BooleanTRUELjava/lang/Boolean;}(ILjava/lang/Object;Lorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; setExpression0(Lorg/apache/derby/impl/sql/compile/ValueNode;)VsetVirtualColumnId setElementAt5(Lorg/apache/derby/impl/sql/compile/QueryTreeNode;I)VdoJoinOrderOptimization()Ljava/lang/Boolean;bindResultColumnsToExpressionsfromList,Lorg/apache/derby/impl/sql/compile/FromList;expandAllsAndNameColumnscopyResultColumnNamesbindResultColumnsByName(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/impl/sql/compile/DMLStatementNode;)Lorg/apache/derby/iapi/services/io/FormatableBitSet;)org/apache/derby/impl/sql/compile/FromVTI(Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/FromVTI;Lorg/apache/derby/impl/sql/compile/DMLStatementNode;)VbindResultColumnsByPosition9(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;)VcopyListAndObjectsgenVirtualColumnNodesi(Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Z)V(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;isNameGeneratedjava/lang/Integer(I)Ljava/lang/String;setName(Ljava/lang/String;)V visibleSize,org/apache/derby/impl/sql/compile/InsertNoderesultColumnListk(ILorg/apache/derby/iapi/services/context/ContextManager;)Lorg/apache/derby/impl/sql/compile/QueryTreeNode;getResultColumn3(I)Lorg/apache/derby/impl/sql/compile/ResultColumn;targetTableDescriptor6Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor; targetVTI+Lorg/apache/derby/impl/sql/compile/FromVTI;getDataDictionary7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;addResultColumn3(Lorg/apache/derby/impl/sql/compile/ResultColumn;)VcloneMe2()Lorg/apache/derby/impl/sql/compile/ResultColumn;setExpressionToNullNode4org/apache/derby/iapi/sql/dictionary/TableDescriptorgetColumnDescriptor:(I)Lorg/apache/derby/iapi/sql/dictionary/ColumnDescriptor;5org/apache/derby/iapi/sql/dictionary/ColumnDescriptorgetTypegetDefaultInfo(()Lorg/apache/derby/catalog/DefaultInfo;isAutoincrementhasGenerationClausegetDefaultTextbindExpression(Lorg/apache/derby/impl/sql/compile/FromList;Lorg/apache/derby/impl/sql/compile/SubqueryList;Ljava/util/Vector;)Lorg/apache/derby/impl/sql/compile/ValueNode;getDefaultDescriptoro(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)Lorg/apache/derby/iapi/sql/dictionary/DefaultDescriptor;createDependency.(Lorg/apache/derby/iapi/sql/depend/Provider;)VsetAutoincrementGenerated getNullNodeb(Lorg/apache/derby/iapi/types/DataTypeDescriptor;)Lorg/apache/derby/impl/sql/compile/ConstantNode;'markGeneratedForUnmatchedColumnInInsertgetName setSourcesetNestingLevelsetSourceLevelsetColumnDescriptorp(Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;Lorg/apache/derby/iapi/sql/dictionary/ColumnDescriptor;)VgetLanguageConnectionContext<()Lorg/apache/derby/iapi/sql/conn/LanguageConnectionContext;append,(Ljava/lang/String;)Ljava/lang/StringBuffer;8org/apache/derby/iapi/sql/conn/LanguageConnectionContextpushCompilerContext getParser,()Lorg/apache/derby/iapi/sql/compile/Parser;(org/apache/derby/iapi/sql/compile/ParserparseStatementE(Ljava/lang/String;)Lorg/apache/derby/impl/sql/compile/StatementNode;getResultSetNodepopCompilerContext6(Lorg/apache/derby/iapi/sql/compile/CompilerContext;)VgetExecutionFactory6()Lorg/apache/derby/iapi/sql/execute/ExecutionFactory;2org/apache/derby/iapi/sql/execute/ExecutionFactorygetResultDescriptiont([Lorg/apache/derby/iapi/sql/ResultColumnDescriptor;Ljava/lang/String;)Lorg/apache/derby/iapi/sql/ResultDescription;h(Lorg/apache/derby/impl/sql/compile/ResultSetNode;Lorg/apache/derby/impl/sql/compile/ResultColumnList;)V8org/apache/derby/impl/sql/compile/ActivationClassBuilderaddItem(Ljava/lang/Object;)I5org/apache/derby/iapi/services/compiler/MethodBuilderpush.org/apache/derby/iapi/sql/compile/CostEstimaterowCount()D(D)VgetEstimatedCost(Z)V callMethod;(SLjava/lang/String;Ljava/lang/String;Ljava/lang/String;I)IgetOptimizerFactory6()Lorg/apache/derby/iapi/sql/compile/OptimizerFactory; 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;+org/apache/derby/iapi/sql/compile/OptimizerprepForNextRoundacceptZ(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable;java/lang/SystemoutLjava/io/PrintStream;java/lang/ObjectgetClass()Ljava/lang/Class;,(Ljava/lang/Object;)Ljava/lang/StringBuffer;java/io/PrintStreamprintlnget(I)Ljava/lang/Object; isDistinct tableNumberset!- S* ***%**** **   SG=* <* N- :+ :* t* *P* N!** N- **&*M-,-,-*-*$*%** *!]Q*"**"#$- *-%-&+*+&W*,',( *+)  ? 3*L***+**+**+*,-**.*/*0*+**+1*1 * *2* *3=1<* &* M,4 ,`56ձ*7**8+9 *+-:*qe* *;+?`+@A:-B- :,,'=:C:D+E:F:GH:qIiJ*+K:>L: * M:  *NOPQ: *P R * :S: * TBI *P* :U*P*V* :W * *;X*Y:Z[\]^*P[* :*+>+?`+@A:-Br**-*,->2* *;_N*P,F-* :+,`i ]*a:*:bYcde+ef:g:hM,i:jkl Nm-*nL*o+p*q> 2*L***+**r**+*,-*s]Q+t6,u,u,*vwx,*vyx,z,{|}~W*    I=*+*a:*+,-**a** **aL+(*+***+<*  )bYce*f  !"#$% &'( ) )**+,9-<*=> *`<-.6**$*YM,*,