Java Doc for OrderByList.java in  » Database-DBMS » db-derby-10.2 » org » apache » derby » impl » sql » compile » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.impl.sql.compile   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.apache.derby.impl.sql.compile.QueryTreeNode       org.apache.derby.impl.sql.compile.QueryTreeNodeVector          org.apache.derby.impl.sql.compile.OrderedColumnList             org.apache.derby.impl.sql.compile.OrderByList OrderByList public class OrderByList extends OrderedColumnList implements RequiredRowOrdering(Code) An OrderByList is an ordered list of columns in the ORDER BY clause. That is, the order of columns in this list is significant - the first column in the list is the most significant in the ordering, and the last column in the list is the least significant. author:    ames Method Summary public  void addOrderByColumn(OrderByColumn column)       boolean allAscending()      Are all columns in the list ascending. public  void bindOrderByColumns(ResultSetNode target)      Bind the update columns by their names to the target resultset of the cursor specification. public  void estimateCost(double estimatedInputRows, RowOrdering rowOrdering, CostEstimate resultCost)      public  void generate(ActivationClassBuilder acb, MethodBuilder mb, ResultSetNode child)      generate the sort result set operating over the source expression. public  OrderByColumn getOrderByColumn(int position)      public  boolean getSortNeeded()      Get whether or not a sort is needed.  boolean isInOrderPrefix(ResultColumnList sourceRCL)      Is this order by list an in order prefix of the specified RCL. This is useful when deciding if an order by list can be eliminated due to a sort from an underlying distinct or union. Parameters:   sourceRCL - The source RCL. public  void printSubNodes(int depth)      Print the list. public  void pullUpOrderByColumns(ResultSetNode target)      Pull up Order By columns by their names to the target resultset of the cursor specification.  void remapColumnReferencesToExpressions()      Remap all ColumnReferences in this tree to be clones of the underlying expression.  void removeConstantColumns(PredicateList whereClause)      Remove any constant columns from this order by list.  void removeDupColumns()      Remove any duplicate columns from this order by list.  ResultColumnList reorderRCL(ResultColumnList resultColumns)      Build a new RCL with the same RCs as the passed in RCL but in an order that matches the ordering columns.  void resetToSourceRCs()      Order by columns now point to the PRN above the node of interest. We need them to point to the RCL under that one. public  void sortNeeded()      public  void sortNotNeeded()      public  int sortRequired(RowOrdering rowOrdering)      public  int sortRequired(RowOrdering rowOrdering, JBitSet tableMap)      Method Detail addOrderByColumn public void addOrderByColumn(OrderByColumn column)(Code) Add a column to the list Parameters:   column - The column to add to the list allAscending boolean allAscending()(Code) Are all columns in the list ascending. Whether or not all columns in the list ascending. bindOrderByColumns public void bindOrderByColumns(ResultSetNode target) throws StandardException(Code) Bind the update columns by their names to the target resultset of the cursor specification. Parameters:   target - The underlying result set exception:   StandardException - Thrown on error estimateCost public void estimateCost(double estimatedInputRows, RowOrdering rowOrdering, CostEstimate resultCost) throws StandardException(Code) See Also:   RequiredRowOrdering.estimateCost exception:   StandardException - Thrown on error generate public void generate(ActivationClassBuilder acb, MethodBuilder mb, ResultSetNode child) throws StandardException(Code) generate the sort result set operating over the source expression. Parameters:   acb - the tool for building the class Parameters:   mb - the method the generated code is to go into exception:   StandardException - thrown on failure getOrderByColumn public OrderByColumn getOrderByColumn(int position)(Code) Get a column from the list Parameters:   position - The column to get from the list getSortNeeded public boolean getSortNeeded()(Code) Get whether or not a sort is needed. Whether or not a sort is needed. isInOrderPrefix boolean isInOrderPrefix(ResultColumnList sourceRCL)(Code) Is this order by list an in order prefix of the specified RCL. This is useful when deciding if an order by list can be eliminated due to a sort from an underlying distinct or union. Parameters:   sourceRCL - The source RCL. Whether or not this order by list an in order prefix of the specified RCL. printSubNodes public void printSubNodes(int depth)(Code) Print the list. Parameters:   depth - The depth at which to indent the sub-nodes pullUpOrderByColumns public void pullUpOrderByColumns(ResultSetNode target) throws StandardException(Code) Pull up Order By columns by their names to the target resultset of the cursor specification. Parameters:   target - The underlying result set remapColumnReferencesToExpressions void remapColumnReferencesToExpressions() throws StandardException(Code) Remap all ColumnReferences in this tree to be clones of the underlying expression. exception:   StandardException - Thrown on error removeConstantColumns void removeConstantColumns(PredicateList whereClause)(Code) Remove any constant columns from this order by list. Constant columns are ones where all of the column references are equal to constant expressions according to the given predicate list. removeDupColumns void removeDupColumns()(Code) Remove any duplicate columns from this order by list. For example, one may "ORDER BY 1, 1, 2" can be reduced to "ORDER BY 1, 2". Beetle 5401. reorderRCL ResultColumnList reorderRCL(ResultColumnList resultColumns) throws StandardException(Code) Build a new RCL with the same RCs as the passed in RCL but in an order that matches the ordering columns. Parameters:   resultColumns - The RCL to reorder. exception:   StandardException - Thrown on error resetToSourceRCs void resetToSourceRCs()(Code) Order by columns now point to the PRN above the node of interest. We need them to point to the RCL under that one. This is useful when combining sorts where we need to reorder the sorting columns. sortNeeded public void sortNeeded()(Code) See Also:   RequiredRowOrdering.sortNeeded See Also:    sortNotNeeded public void sortNotNeeded()(Code) See Also:   RequiredRowOrdering.sortNotNeeded See Also:    sortRequired public int sortRequired(RowOrdering rowOrdering) throws StandardException(Code) See Also:   RequiredRowOrdering.sortRequired exception:   StandardException - Thrown on error sortRequired public int sortRequired(RowOrdering rowOrdering, JBitSet tableMap) throws StandardException(Code) See Also:   RequiredRowOrdering.sortRequired exception:   StandardException - Thrown on error Methods inherited from org.apache.derby.impl.sql.compile.OrderedColumnList public IndexColumnOrder[] getColumnOrdering()(Code)(Java Doc) Methods inherited from org.apache.derby.impl.sql.compile.QueryTreeNodeVector public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc) final void addElement(QueryTreeNode qt)(Code)(Java Doc) void destructiveAppend(QueryTreeNodeVector qtnv)(Code)(Java Doc) QueryTreeNode elementAt(int index)(Code)(Java Doc) final int indexOf(QueryTreeNode qt)(Code)(Java Doc) final void insertElementAt(QueryTreeNode qt, int index)(Code)(Java Doc) void nondestructiveAppend(QueryTreeNodeVector qtnv)(Code)(Java Doc) final Object remove(int index)(Code)(Java Doc) final void removeAllElements()(Code)(Java Doc) final void removeElement(QueryTreeNode qt)(Code)(Java Doc) final void removeElementAt(int index)(Code)(Java Doc) final void setElementAt(QueryTreeNode qt, int index)(Code)(Java Doc) final public int size()(Code)(Java Doc) public String toString()(Code)(Java Doc) Fields inherited from org.apache.derby.impl.sql.compile.QueryTreeNode final public static int AUTOINCREMENT_CREATE_MODIFY(Code)(Java Doc) final public static int AUTOINCREMENT_INC_INDEX(Code)(Java Doc) final public static int AUTOINCREMENT_IS_AUTOINCREMENT_INDEX(Code)(Java Doc) final public static int AUTOINCREMENT_START_INDEX(Code)(Java Doc) boolean isPrivilegeCollectionRequired(Code)(Java Doc) Methods inherited from org.apache.derby.impl.sql.compile.QueryTreeNode public Visitable accept(Visitor v) throws StandardException(Code)(Java Doc) public QueryTreeNode bind() throws StandardException(Code)(Java Doc) public DataValueDescriptor convertDefaultNode(DataTypeDescriptor typeDescriptor) throws StandardException(Code)(Java Doc) protected static void debugFlush()(Code)(Java Doc) public static void debugPrint(String outputString)(Code)(Java Doc) public void disablePrivilegeCollection()(Code)(Java Doc) public String executeSchemaName()(Code)(Java Doc) public String executeStatementName()(Code)(Java Doc) public static String formatNodeString(String nodeString, int depth)(Code)(Java Doc) public boolean foundString(String[] list, String search)(Code)(Java Doc) public GeneratedClass generate(ByteArray ignored) throws StandardException(Code)(Java Doc) protected void generate(ActivationClassBuilder acb, MethodBuilder mb) throws StandardException(Code)(Java Doc) void generateAuthorizeCheck(ActivationClassBuilder acb, MethodBuilder mb, int sqlOperation)(Code)(Java Doc) public int getBeginOffset()(Code)(Java Doc) final protected ClassFactory getClassFactory()(Code)(Java Doc) final protected CompilerContext getCompilerContext()(Code)(Java Doc) final public ContextManager getContextManager()(Code)(Java Doc) public Object getCursorInfo() throws StandardException(Code)(Java Doc) final public DataDictionary getDataDictionary()(Code)(Java Doc) final public DependencyManager getDependencyManager()(Code)(Java Doc) public int getEndOffset()(Code)(Java Doc) final public ExecutionFactory getExecutionFactory()(Code)(Java Doc) final public GenericConstantActionFactory getGenericConstantActionFactory()(Code)(Java Doc) protected int getIntProperty(String value, String key) throws StandardException(Code)(Java Doc) final protected LanguageConnectionContext getLanguageConnectionContext()(Code)(Java Doc) final public NodeFactory getNodeFactory()(Code)(Java Doc) protected int getNodeType()(Code)(Java Doc) public ConstantNode getNullNode(TypeId typeId, ContextManager cm) throws StandardException(Code)(Java Doc) public DataTypeDescriptor[] getParameterTypes() throws StandardException(Code)(Java Doc) public long getRowEstimate()(Code)(Java Doc) public String getSPSName()(Code)(Java Doc) final SchemaDescriptor getSchemaDescriptor(String schemaName) throws StandardException(Code)(Java Doc) final SchemaDescriptor getSchemaDescriptor(String schemaName, boolean raiseError) throws StandardException(Code)(Java Doc) protected int getStatementType()(Code)(Java Doc) final protected TableDescriptor getTableDescriptor(String tableName, SchemaDescriptor schema) throws StandardException(Code)(Java Doc) final protected TypeCompiler getTypeCompiler(TypeId typeId)(Code)(Java Doc) public void init(Object arg1) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12, Object arg13) throws StandardException(Code)(Java Doc) public void init(Object arg1, Object arg2, Object arg3, Object arg4, Object arg5, Object arg6, Object arg7, Object arg8, Object arg9, Object arg10, Object arg11, Object arg12, Object arg13, Object arg14) throws StandardException(Code)(Java Doc) public boolean isAtomic() throws StandardException(Code)(Java Doc) protected boolean isInstanceOf(int nodeType)(Code)(Java Doc) public boolean isPrivilegeCollectionRequired()(Code)(Java Doc) final boolean isSessionSchema(SchemaDescriptor sd)(Code)(Java Doc) final boolean isSessionSchema(String schemaName)(Code)(Java Doc) public ConstantAction makeConstantAction() throws StandardException(Code)(Java Doc) public ResultDescription makeResultDescription() throws StandardException(Code)(Java Doc) public TableName makeTableName(String schemaName, String flatName) throws StandardException(Code)(Java Doc) public boolean needsSavepoint()(Code)(Java Doc) protected String nodeHeader()(Code)(Java Doc) public QueryTreeNode optimize() throws StandardException(Code)(Java Doc) public static QueryTreeNode parseQueryText(CompilerContext compilerContext, String queryText, Object[] paramDefaults, LanguageConnectionContext lcc) throws StandardException(Code)(Java Doc) public void printLabel(int depth, String label)(Code)(Java Doc) public void printSubNodes(int depth)(Code)(Java Doc) public boolean referencesSessionSchema() throws StandardException(Code)(Java Doc) public TableName resolveTableToSynonym(TableName tabName) throws StandardException(Code)(Java Doc) public void setBeginOffset(int beginOffset)(Code)(Java Doc) public void setContextManager(ContextManager cm)(Code)(Java Doc) public void setEndOffset(int endOffset)(Code)(Java Doc) public void setNodeType(int nodeType)(Code)(Java Doc) public void setRefActionInfo(long fkIndexConglomId, int[] fkColArray, String parentResultSetId, boolean dependentScan)(Code)(Java Doc) public String toString()(Code)(Java Doc) public void treePrint()(Code)(Java Doc) public void treePrint(int depth)(Code)(Java Doc) String verifyClassExist(String javaClassName, boolean convertCase) throws StandardException(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)