Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.sql.compile.CreateViewNode

Modifier and Type	Field and Description
private int	checkOption
private ColumnInfo[]	colInfos
private ValueNode	fetchFirst
private boolean	hasJDBClimitClause
private ValueNode	offset
private OrderByList	orderByList
private ProviderInfo[]	providerInfos
private String	qeText
private ResultSetNode	queryExpression
private ResultColumnList	resultColumns

Access	Constructor and Description
pack-priv	CreateViewNode(TableName The name of the table to be created viewName, ResultColumnList The column list from the view definition, if specified resultColumns, ResultSetNode The query expression for the view queryExpression, int The type of WITH CHECK OPTION that was specified (NONE for now) checkOption, String The text for the queryExpression qeText, OrderByList ORDER BY list orderCols, ValueNode OFFSET if any, or null offset, ValueNode FETCH FIRST if any, or null fetchFirst, boolean True if the offset/fetchFirst clauses come from JDBC limit/offset escape syntax hasJDBClimitClause, ContextManager Context manager cm) Constructor for a CreateViewNode

Method Summary

Modifier and Type	Method and Description
pack-priv void	acceptChildren(Visitor the visitor v) Overrides org.apache.derby.impl.sql.compile.DDLStatementNode.acceptChildren. Accept the visitor for all visitable children of this node.
public void	bindStatement() Overrides org.apache.derby.impl.sql.compile.StatementNode.bindStatement. Bind this CreateViewNode.
private ProviderInfo[]	Returns: Array of providers that this view depends on. bindViewDefinition(DataDictionary The DataDictionary to use to look up columns, tables, etc. dataDictionary, CompilerContext compilerContext, LanguageConnectionContext lcc, OptimizerFactory optimizerFactory, ResultSetNode queryExpr, ContextManager cm) Bind the query expression for a view definition.
private void	genColumnInfos(ColumnInfo[] The ColumnInfo[] to be filled in. colInfos) Fill in the ColumnInfo[] for this create view.
public ValueNode	getFetchFirst()
public ValueNode	getOffset()
public OrderByList	getOrderByList()
pack-priv ResultSetNode	Returns: the parsed query expression. getParsedQueryExpression() Get the parsed query expression (the SELECT statement).
public boolean	hasJDBClimitClause()
public ConstantAction	makeConstantAction() Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.makeConstantAction. Create the Constant information that will drive the guts of Execution.
pack-priv void	printSubNodes(int The depth of this node in the tree depth) Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.printSubNodes. Prints the sub-nodes of this object.
public boolean	Returns: true if references SESSION schema tables, else false referencesSessionSchema() Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.referencesSessionSchema. Return true if the node references SESSION schema tables (temporary or permanent)
pack-priv String	statementToString() Implements abstract org.apache.derby.impl.sql.compile.StatementNode.statementToString.
public String	Returns: This object as a String toString() Overrides org.apache.derby.impl.sql.compile.DDLStatementNode.toString. Convert this object to a String.

Inherited from org.apache.derby.impl.sql.compile.DDLStatementNode:: activationKind generate getFullName getObjectName getRelativeName getSchemaDescriptor getSchemaDescriptor getTableDescriptor getTableDescriptor getTableDescriptor getTableDescriptor initAndCheck isAtomic makeFromList

Field Detail

checkOption	back to summary
private int checkOption

colInfos	back to summary
private ColumnInfo[] colInfos

fetchFirst	back to summary
private ValueNode fetchFirst

hasJDBClimitClause	back to summary
private boolean hasJDBClimitClause

offset	back to summary
private ValueNode offset

orderByList	back to summary
private OrderByList orderByList

providerInfos	back to summary
private ProviderInfo[] providerInfos

qeText	back to summary
private String qeText

queryExpression	back to summary
private ResultSetNode queryExpression

resultColumns	back to summary
private ResultColumnList resultColumns

Constructor Detail

CreateViewNode	back to summary
pack-priv CreateViewNode(TableName viewName, ResultColumnList resultColumns, ResultSetNode queryExpression, int checkOption, String qeText, OrderByList orderCols, ValueNode offset, ValueNode fetchFirst, boolean hasJDBClimitClause, ContextManager cm) throws StandardException Constructor for a CreateViewNode Parameters viewName:TableName The name of the table to be created resultColumns:ResultColumnList The column list from the view definition, if specified queryExpression:ResultSetNode The query expression for the view checkOption:int The type of WITH CHECK OPTION that was specified (NONE for now) qeText:String The text for the queryExpression orderCols:OrderByList ORDER BY list offset:ValueNode OFFSET if any, or null fetchFirst:ValueNode FETCH FIRST if any, or null hasJDBClimitClause:boolean True if the offset/fetchFirst clauses come from JDBC limit/offset escape syntax cm:ContextManager Context manager Exceptions StandardException: Thrown on error

CreateViewNode

back to summary

pack-priv CreateViewNode(TableName viewName, ResultColumnList resultColumns, ResultSetNode queryExpression, int checkOption, String qeText, OrderByList orderCols, ValueNode offset, ValueNode fetchFirst, boolean hasJDBClimitClause, ContextManager cm) throws StandardException

Constructor for a CreateViewNode

Parameters

viewName:TableName: The name of the table to be created
resultColumns:ResultColumnList: The column list from the view definition, if specified
queryExpression:ResultSetNode: The query expression for the view
checkOption:int: The type of WITH CHECK OPTION that was specified (NONE for now)
qeText:String: The text for the queryExpression
orderCols:OrderByList: ORDER BY list
offset:ValueNode: OFFSET if any, or null
fetchFirst:ValueNode: FETCH FIRST if any, or null
hasJDBClimitClause:boolean: True if the offset/fetchFirst clauses come from JDBC limit/offset escape syntax
cm:ContextManager: Context manager

Exceptions

StandardException:: Thrown on error

Method Detail

acceptChildren	back to summary
pack-priv void acceptChildren(Visitor v) throws StandardException Overrides org.apache.derby.impl.sql.compile.DDLStatementNode.acceptChildren. Accept the visitor for all visitable children of this node. Parameters v:Visitor the visitor Annotations @Override Exceptions StandardException: on error

acceptChildren

back to summary

pack-priv void acceptChildren(Visitor v) throws StandardException

Overrides org.apache.derby.impl.sql.compile.DDLStatementNode.acceptChildren.

Accept the visitor for all visitable children of this node.

Parameters

v:Visitor: the visitor

Annotations

@Override

Exceptions

StandardException:: on error

bindStatement	back to summary
public void bindStatement() throws StandardException Overrides org.apache.derby.impl.sql.compile.StatementNode.bindStatement. Bind this CreateViewNode. This means doing any static error checking that can be done before actually creating the table. For example, verifying that the ResultColumnList does not contain any duplicate column names. Annotations @Override Exceptions StandardException: Thrown on error

bindStatement

back to summary

public void bindStatement() throws StandardException

Overrides org.apache.derby.impl.sql.compile.StatementNode.bindStatement.

Bind this CreateViewNode. This means doing any static error checking that can be done before actually creating the table. For example, verifying that the ResultColumnList does not contain any duplicate column names.

Annotations

@Override

Exceptions

StandardException:: Thrown on error

bindViewDefinition	back to summary
private ProviderInfo[] bindViewDefinition(DataDictionary dataDictionary, CompilerContext compilerContext, LanguageConnectionContext lcc, OptimizerFactory optimizerFactory, ResultSetNode queryExpr, ContextManager cm) throws StandardException Bind the query expression for a view definition. Parameters dataDictionary:DataDictionary The DataDictionary to use to look up columns, tables, etc. Returns:ProviderInfo[] Array of providers that this view depends on. Exceptions StandardException: Thrown on error

bindViewDefinition

back to summary

private ProviderInfo[] bindViewDefinition(DataDictionary dataDictionary, CompilerContext compilerContext, LanguageConnectionContext lcc, OptimizerFactory optimizerFactory, ResultSetNode queryExpr, ContextManager cm) throws StandardException

Bind the query expression for a view definition.

Parameters

dataDictionary:DataDictionary: The DataDictionary to use to look up columns, tables, etc.

Returns:ProviderInfo[]

Array of providers that this view depends on.

Exceptions

StandardException:: Thrown on error

genColumnInfos	back to summary
private void genColumnInfos(ColumnInfo[] colInfos) Fill in the ColumnInfo[] for this create view. Parameters colInfos:ColumnInfo[] The ColumnInfo[] to be filled in.

genColumnInfos

back to summary

private void genColumnInfos(ColumnInfo[] colInfos)

Fill in the ColumnInfo[] for this create view.

Parameters

colInfos:ColumnInfo[]: The ColumnInfo[] to be filled in.

getFetchFirst	back to summary
public ValueNode getFetchFirst()

getOffset	back to summary
public ValueNode getOffset()

getOrderByList	back to summary
public OrderByList getOrderByList()

getParsedQueryExpression	back to summary
pack-priv ResultSetNode getParsedQueryExpression() Get the parsed query expression (the SELECT statement). Returns:ResultSetNode the parsed query expression.

getParsedQueryExpression

back to summary

pack-priv ResultSetNode getParsedQueryExpression()

Get the parsed query expression (the SELECT statement).

Returns:ResultSetNode: the parsed query expression.

hasJDBClimitClause	back to summary
public boolean hasJDBClimitClause()

makeConstantAction	back to summary
public ConstantAction makeConstantAction() throws StandardException Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.makeConstantAction. Create the Constant information that will drive the guts of Execution. Annotations @Override Exceptions StandardException: Thrown on failure

makeConstantAction

back to summary

public ConstantAction makeConstantAction() throws StandardException

Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.makeConstantAction.

Create the Constant information that will drive the guts of Execution.

Annotations

@Override

Exceptions

StandardException:: Thrown on failure

printSubNodes	back to summary
pack-priv void printSubNodes(int depth) Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.printSubNodes. Prints the sub-nodes of this object. See QueryTreeNode.java for how tree printing is supposed to work. Parameters depth:int The depth of this node in the tree Annotations @Override

printSubNodes

back to summary

pack-priv void printSubNodes(int depth)

Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.printSubNodes.

Prints the sub-nodes of this object. See QueryTreeNode.java for how tree printing is supposed to work.

Parameters

depth:int: The depth of this node in the tree

Annotations

@Override

referencesSessionSchema	back to summary
public boolean referencesSessionSchema() throws StandardException Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.referencesSessionSchema. Return true if the node references SESSION schema tables (temporary or permanent) Returns:boolean true if references SESSION schema tables, else false Annotations @Override Exceptions StandardException: Thrown on error

referencesSessionSchema

back to summary

public boolean referencesSessionSchema() throws StandardException

Overrides org.apache.derby.impl.sql.compile.QueryTreeNode.referencesSessionSchema.

Return true if the node references SESSION schema tables (temporary or permanent)

Returns:boolean

true if references SESSION schema tables, else false

Annotations

@Override

Exceptions

StandardException:: Thrown on error

statementToString	back to summary
pack-priv String statementToString() Implements abstract org.apache.derby.impl.sql.compile.StatementNode.statementToString.

toString	back to summary
public String toString() Overrides org.apache.derby.impl.sql.compile.DDLStatementNode.toString. Convert this object to a String. See comments in QueryTreeNode.java for how this should be done for tree printing. Returns:String This object as a String Annotations @Override

toString

back to summary

public String toString()

Overrides org.apache.derby.impl.sql.compile.DDLStatementNode.toString.

Convert this object to a String. See comments in QueryTreeNode.java for how this should be done for tree printing.

Returns:String

This object as a String

Annotations

@Override

pack-priv Class CreateViewNode

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail