Edit C:\Program Files\Java\jdk1.7.0_45\db\lib\org\apache\derby\impl\sql\compile\FromTable.class
Êþº¾ 0j £P ¢Q¿? ¢R ¢S¿ð ¢TU ¢VW ¢X ¢Y ¢Z ¢[\ ¢] ¢^ ¢_ ¢` ¢abc ¢d ¢efg ¢h i Lj Lk ¢lmfn Lop ¢q ×r ¢s Lt Lu ¢v ¢w ¢x ¢y ¢z ¢{f| }~~? ?? ? ??? ¢?? ? ×?? ???????? ¢?? H? H? ¢?? HP H??? K? K? H? Khf? ¢? ¢ ¡ T¢£f¤ ¢¥ ¢¦f§fh ¢¨ïÿÿÿÿÿÿb© ¢ª«¬ ¢ ¢® ?? ?¯° f± f² ³´ µ¶· kP ¢¸ k¹ ¢º » ¢¼ ?½ ¾? ¾¿ fÀ ?Á ³Â à ¢Ä@( ¢Å ÆAßÿÿÿÀ ÿÿÿ ¢Ç ¢È ¢É Ê LË ¢ÌbÍ ÎÏ ¢Ð ÎÑ ¢Ò ¢Ó ÔÕÖ f× ÔØÙ ?Ú ¢Û ¢Ü ¢Ý ¢Þ ßà ?áâ?âãä ?å ?æçè éê«ë ¢ìíî tableProperties Ljava/util/Properties; correlationName Ljava/lang/String; corrTableName -Lorg/apache/derby/impl/sql/compile/TableName; tableNumber I level hashKeyColumns [I initialCapacity loadFactor F maxCapacity currentAccessPath 2Lorg/apache/derby/impl/sql/compile/AccessPathImpl; bestAccessPath bestSortAvoidancePath trulyTheBestAccessPath joinStrategyNumber userSpecifiedJoinStrategy bestCostEstimate 0Lorg/apache/derby/iapi/sql/compile/CostEstimate; refCols 4Lorg/apache/derby/iapi/services/io/FormatableBitSet; perRowUsage D considerSortAvoidancePath Z bestPlanMap Ljava/util/HashMap; REMOVE_PLAN S ConstantValue ADD_PLAN LOAD_PLAN origTableName <init> ()V Code init '(Ljava/lang/Object;Ljava/lang/Object;)V getCorrelationName ()Ljava/lang/String; 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; Exceptionsï nextAccessPath ?(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)Z canBeOrdered ()Z getCurrentAccessPath 0()Lorg/apache/derby/iapi/sql/compile/AccessPath; getBestAccessPath getBestSortAvoidancePath getTrulyTheBestAccessPath rememberSortAvoidancePath rememberJoinStrategyAsBest 1(Lorg/apache/derby/iapi/sql/compile/AccessPath;)V getTableDescriptor 8()Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor; pushOptPredicate ;(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate;)Z pullOptPredicates ?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)V modifyAccessPath U(Lorg/apache/derby/iapi/util/JBitSet;)Lorg/apache/derby/iapi/sql/compile/Optimizable; isCoveringIndex @(Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor;)Z getProperties ()Ljava/util/Properties; setProperties (Ljava/util/Properties;)V verifyProperties 8(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;)V getName getBaseTableName 'convertAbsoluteToRelativeColumnPosition (I)I updateBestPlanMap (SLjava/lang/Object;)V rememberAsBest 1(ILorg/apache/derby/iapi/sql/compile/Optimizer;)V startOptimizing _(Lorg/apache/derby/iapi/sql/compile/Optimizer;Lorg/apache/derby/iapi/sql/compile/RowOrdering;)V resetJoinStrategies 0(Lorg/apache/derby/iapi/sql/compile/Optimizer;)V 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; getFinalCostEstimate 2()Lorg/apache/derby/iapi/sql/compile/CostEstimate; isBaseTable hasLargeObjectColumns isMaterializable supportsMultipleInstantiations getTableNumber ()I hasTableNumber forUpdate ()F 4(Lorg/apache/derby/iapi/sql/compile/JoinStrategy;I)I getPerRowUsage ()D ()[I setHashKeyColumns ([I)V feasibleJoinStrategy l(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/Optimizer;)Z memoryUsageOK (DI)Z isJoinColumnForRightOuterJoin 3(Lorg/apache/derby/impl/sql/compile/ResultColumn;)V legalJoinOrder '(Lorg/apache/derby/iapi/util/JBitSet;)Z getNumColumnsReturned isTargetTable isOneRowScan initAccessPaths uniqueJoin ?(Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)D getRefCols 6()Lorg/apache/derby/iapi/services/io/FormatableBitSet; getUserSpecifiedJoinStrategy cursorTargetTable getCostEstimate _(Lorg/apache/derby/iapi/sql/compile/Optimizer;)Lorg/apache/derby/iapi/sql/compile/CostEstimate; getScratchCostEstimate setCostEstimate 3(Lorg/apache/derby/iapi/sql/compile/CostEstimate;)V assignCostEstimate toString getResultColumnsForList Ä(Lorg/apache/derby/impl/sql/compile/TableName;Lorg/apache/derby/impl/sql/compile/ResultColumnList;Lorg/apache/derby/impl/sql/compile/TableName;)Lorg/apache/derby/impl/sql/compile/ResultColumnList; pushExpressions 4(Lorg/apache/derby/impl/sql/compile/PredicateList;)V getExposedName setTableNumber (I)V getTableName /()Lorg/apache/derby/impl/sql/compile/TableName; setLevel getLevel decrementLevel getSchemaDescriptor 9()Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor; f(Lorg/apache/derby/impl/sql/compile/TableName;)Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor; getFromTableByName T(Ljava/lang/String;Ljava/lang/String;Z)Lorg/apache/derby/impl/sql/compile/FromTable; isFlattenableJoinNode LOJ_reorderable (I)Z transformOuterJoins ](Lorg/apache/derby/impl/sql/compile/ValueNode;I)Lorg/apache/derby/impl/sql/compile/FromTable; fillInReferencedTableMap '(Lorg/apache/derby/iapi/util/JBitSet;)V markUpdatableByCursor (Ljava/util/Vector;)V flatten(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; optimizeSubqueries 9(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;D)V #tellRowOrderingAboutConstantColumns n(Lorg/apache/derby/iapi/sql/compile/RowOrdering;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;)V needsSpecialRCLBinding setOrigTableName 0(Lorg/apache/derby/impl/sql/compile/TableName;)V getOrigTableName Í Î ¯ « ° ± ² « ¾ ¿ java/lang/String ¦ § java/util/Properties ¤ ¥ ª «  à ø ù ;org/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor %&()ðñò »óôHI Ü Ýõö÷% øùúû ¹ § .org/apache/derby/iapi/sql/compile/JoinStrategyüýöþ 42Y56 õ Óÿ ¸ «öJK ³ ´ µ ´ ¶ ´ · ´ À Á Û joinStrategy hashInitialCapacity 42Y59ÿ hashLoadFactor java/lang/NumberFormatException 42Y58 42Y60 hashMaxCapacity 42Y61 42Y440 Ó à Ý java/util/HashMap 0org/apache/derby/impl/sql/compile/AccessPathImpl +org/apache/derby/iapi/sql/compile/Optimizer Í ÿ ã Þ Ý ß Ý 5org/apache/derby/impl/sql/compile/ProjectRestrictNode ! -org/apache/derby/iapi/sql/compile/Optimizable"# Û ä å$% þ ÿ&' Ú Û()*+ »,-./ .org/apache/derby/impl/sql/compile/ResultColumn0 Û1234567 Û 9org/apache/derby/impl/sql/compile/HasCorrelatedCRsVisitor89: Û ²;$ Û<=>??@AB2CD Û ì í ®EF ² G Û ¼ ½HIJ »&)KL ÓMNOPQRSTUV 2org/apache/derby/impl/sql/compile/ResultColumnList ô ÓUW +org/apache/derby/impl/sql/compile/ValueNodeX ¨ © ¬ «8:8YZ[2DE\]^ +org/apache/derby/impl/sql/compile/Predicate_`abcdefg hi Ì © +org/apache/derby/impl/sql/compile/FromTable /org/apache/derby/impl/sql/compile/ResultSetNode -org/apache/derby/iapi/error/StandardException getDataDictionary 7()Lorg/apache/derby/iapi/sql/dictionary/DataDictionary; costEstimate .org/apache/derby/iapi/sql/compile/CostEstimate rowCount ,org/apache/derby/iapi/sql/compile/AccessPath getJoinStrategy 2()Lorg/apache/derby/iapi/sql/compile/JoinStrategy;8(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;)V getNumberOfJoinStrategies setJoinStrategy 3(Lorg/apache/derby/iapi/sql/compile/JoinStrategy;)V D(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/compile/JoinStrategy; newException g(Ljava/lang/String;Ljava/lang/Object;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException; 3(I)Lorg/apache/derby/iapi/sql/compile/JoinStrategy; trace (IIIDLjava/lang/Object;)V getOptimizer /()Lorg/apache/derby/iapi/sql/compile/Optimizer; keys ()Ljava/util/Enumeration; java/util/Enumeration hasMoreElements nextElement ()Ljava/lang/Object; get &(Ljava/lang/Object;)Ljava/lang/Object; equals (Ljava/lang/Object;)Z %org/apache/derby/iapi/util/StringUtil SQLToUpperCase &(Ljava/lang/String;)Ljava/lang/String; getIntProperty '(Ljava/lang/String;Ljava/lang/String;)I valueOf (I)Ljava/lang/String; U(Ljava/lang/String;Ljava/lang/Object;)Lorg/apache/derby/iapi/error/StandardException; java/lang/Float parseFloat (Ljava/lang/String;)F remove size copy put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; getChildResult 3()Lorg/apache/derby/impl/sql/compile/ResultSetNode; getConglomerateDescriptor ?()Lorg/apache/derby/iapi/sql/dictionary/ConglomerateDescriptor; initializeAccessPathName n(Lorg/apache/derby/iapi/sql/dictionary/DataDictionary;Lorg/apache/derby/iapi/sql/dictionary/TableDescriptor;)V setCost (DDD)V -org/apache/derby/iapi/sql/compile/RowOrdering addUnorderedOptimizable 2(Lorg/apache/derby/iapi/sql/compile/Optimizable;)V finalCostEstimate resultColumns 4Lorg/apache/derby/impl/sql/compile/ResultColumnList; elementAt 4(I)Lorg/apache/derby/impl/sql/compile/QueryTreeNode; isReferenced getType 2()Lorg/apache/derby/iapi/types/DataTypeDescriptor; .org/apache/derby/iapi/types/DataTypeDescriptor getTypeId &()Lorg/apache/derby/iapi/types/TypeId; "org/apache/derby/iapi/types/TypeId isLOBTypeId accept Z(Lorg/apache/derby/iapi/sql/compile/Visitor;)Lorg/apache/derby/iapi/sql/compile/Visitable; hasCorrelatedCRs (IID)I getReferencedFormatableBitSet 9(ZZZ)Lorg/apache/derby/iapi/services/io/FormatableBitSet; 2org/apache/derby/iapi/services/io/FormatableBitSet isSet getExpression /()Lorg/apache/derby/impl/sql/compile/ValueNode; getTypeServices estimatedMemoryUsage isIndex feasible ?(Lorg/apache/derby/iapi/sql/compile/Optimizable;Lorg/apache/derby/iapi/sql/compile/OptimizablePredicateList;Lorg/apache/derby/iapi/sql/compile/Optimizer;)Z isOneRowResultSet getProperty newCostEstimate scratchCostEstimate +org/apache/derby/impl/sql/compile/TableName getSchemaName makeTableName S(Ljava/lang/String;Ljava/lang/String;)Lorg/apache/derby/impl/sql/compile/TableName; 0(Lorg/apache/derby/impl/sql/compile/TableName;)Z getNodeFactory 1()Lorg/apache/derby/iapi/sql/compile/NodeFactory; getContextManager 9()Lorg/apache/derby/iapi/services/context/ContextManager; -org/apache/derby/iapi/sql/compile/NodeFactory getNode k(ILorg/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; addResultColumn K(Ljava/lang/String;)Lorg/apache/derby/iapi/sql/dictionary/SchemaDescriptor; "org/apache/derby/iapi/util/JBitSet set :org/apache/derby/iapi/sql/compile/OptimizablePredicateList getOptPredicate ;(I)Lorg/apache/derby/iapi/sql/compile/OptimizablePredicate; &equalsComparisonWithConstantExpression 2(Lorg/apache/derby/iapi/sql/compile/Optimizable;)Z getRelop 8()Lorg/apache/derby/impl/sql/compile/RelationalOperator; 4org/apache/derby/impl/sql/compile/RelationalOperator getColumnOperand d(Lorg/apache/derby/iapi/sql/compile/Optimizable;)Lorg/apache/derby/impl/sql/compile/ColumnReference; 1org/apache/derby/impl/sql/compile/ColumnReference getColumnNumber columnAlwaysOrdered 3(Lorg/apache/derby/iapi/sql/compile/Optimizable;I)V ¢ £ V ¤ ¥ ¦ § ¨ © ª « ¬ « ® ¯ « ° ± ² « ³ ´ µ ´ ¶ ´ · ´ ¸ « ¹ § º » ¼ ½ ¾ ¿ À Á Â Ã Ä Å Æ Ç È Å Æ É Ê Å Æ Ë Ì © R Í Î Ï ( *· *µ *µ *µ * µ ± Ð Ñ Ï ' *+À µ *,À µ *µ *µ ± Ò Ó Ï *´ ° Ô Õ Ï j ^**¶ *,À -+¶ :*+¶ W*¶ **¶ *´ ¹ ¶ *¶ ¹ *,À -+*¶ ¹ +*,*¶ -¹ *¶ ° Ö × Ø Ù Ï ³ §+¹ 66*¶ :*´ Æ M¹ Æ À ¹ 6§ n+*´ ¹ ! ¹ ¹ Ç "*´ *¶ #¸ $¿6§ ?*´ %¢ 6+*´ %¹ & ¹ *Y´ %`µ %6+*´ ¹ ¹ ' *-,¶ (¬ Ö × Ú Û Ï ¬ Ü Ý Ï *´ )° Þ Ý Ï *´ *° ß Ý Ï *´ +° à Ý Ï *´ ,° á Î Ï *µ -± À Û Ï *´ -¬ â ã Ï } q+¹ . M+*¶ ¹ ¹ ,1*´ *¶ ¹ ¹ ' +*´ *¦ ,2*´ +¹ ' § ,+*´ +¦ ,3*´ +¹ ' § ,4*´ +¹ ' ± ä å Ï ° æ ç Ï ¬ Ö × è é Ï ± Ö × ê ë Ï *° Ö × ì í Ï ¬ Ö × î ï Ï *´ ° ð ñ Ï *+µ ± ò ó Ï þ ê*´ Ç ±=*´ ¶ /N-¹ 0 ? Ñ-¹ 1 À :*´ ¶ 2À :3¶ 4? *¸ 5µ § ?6¶ 4? #**¶ 7µ *´ ? ?8*´ ¸ 9¸ :¿;¶ 4? 7*¸ <µ § :>¸ $¿*´ ??? *´ ??? ??¸ :¿@¶ 4? #**¶ 7µ *´ ? A*´ ¸ 9¸ :¿B3¸ $¿§ÿ,± ~ ? ? = Ö × ô Ó Ï *¶ C° Ö × õ Ó Ï D° ö ÷ Ï ¬ ø ù Ï Ë ¿? #*´ Æ *´ ,¶ EW*´ ¶ F? *µ ±*¶ GN: e-Ç ±*´ Ç *» HY· Iµ § *´ ,¶ JÀ K:Ç ',Á L? » KY,À L· M:§ » KYÀ L· M:-¶ N*´ ,¶ OW±*´ Ç ±*´ ,¶ JÀ K:Æ ¶ PÇ ±-¹ Q ± Ö × ú û Ï ° ¤N« ) !*¶ RN§ *¶ SN§ *¶ G-¹ Q *Á T? *,¶ § *À T:¶ UÁ V? *,¶ -¹ W :*¶ X? *¶ :*¶ Y:*¶ G¹ Z *-¹ [ ¶ -¹ . *´ -¹ ' ± Ö × ü ý Ï _ S*+¶ \*µ -*¶ R¹ [ N-Æ - ] ] ]¹ _ *¶ S¹ [ N-Æ - ] ] ]¹ _ *¶ `? ,*¹ a ± þ ÿ Ï *µ %*¶ À ¹ ± Ï ° Ö × Ï <