public Interface ExpressionJSON

public String getSQL()

For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getValue	back to summary
public Object getValue(Session session) Overrides org.hsqldb.Expression.getValue.

resolveTypes	back to summary
public void resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

org.hsqldb back to summary

public Class ExpressionJSON.ExpressionJSONArrayFromQuery

Class Inheritance

extends Expression

java.lang.Object
org.hsqldb.Expression
org.hsqldb.ExpressionJSON.ExpressionJSONArrayFromQuery

Field Summary

Modifier and Type	Field and Description
pack-priv final Expression	exprQuery
pack-priv final boolean	nullOnNull

Constructor Summary

Access	Constructor and Description
public	ExpressionJSONArrayFromQuery(Expression expressionQuery, boolean nullOnNull, Type dataType)

Method Summary

Modifier and Type	Method and Description
public String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

Inherited from org.hsqldb.Expression:: checkValidCheckConstraint collectAllExpressions collectAllSubqueries collectObjectNames collectRangeVariables collectRangeVariables convertToType costFactor countNulls duplicate equals equals equals equals getAggregatedValue getAlias getCheckSelect getColumn getColumnIndex getColumnName getCondition getConstantValueNoCheck getContextSQL getDataType getDegree getIndexableExpression getJoinRangeVariables getLeftNode getNodeDataType getNodeDataTypes getNullability getRangeVariable getResult getRightNode getRowValue getSimpleName getSubqueries getSubType getTable getType getUnkeyedColumns getValue getValueClassName hasAggregate hasCondition hashCode hasNonDeterministicFunction hasReference hasReference insertValuesIntoSubqueryTable isComposedOf isComposedOf isConditionRangeVariable isCorrelated isDistinctAggregate isDynamicParam isFalse isIndexable isSelfAggregate isTrue isUnresolvedParam materialise prepareTable replaceAliasInOrderBy replaceColumnReferences replaceExpressions replaceNode replaceRangeVariables resetColumnReferences resolveCheckOrGenExpression resolveColumnReferences resolveColumnReferences resolveColumnSet resolveColumnSet resolveGrantFilter setAggregate setAlias setAsConstantValue setAsConstantValue setAttributesAsColumn setCollation setCondition setCorrelatedReferences setDataType setLeftNode setNoOptimisation setRightNode setSubType swapLeftAndRightNodes testCondition updateAggregatingValue updateAggregatingValue

Field Detail

exprQuery	back to summary
pack-priv final Expression exprQuery

nullOnNull	back to summary
pack-priv final boolean nullOnNull

Constructor Detail

ExpressionJSONArrayFromQuery	back to summary
public ExpressionJSONArrayFromQuery(Expression expressionQuery, boolean nullOnNull, Type dataType)

Method Detail

describe	back to summary
public String describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.

getSQL	back to summary
public String getSQL() Overrides org.hsqldb.Expression.getSQL. Doc from org.hsqldb.Expression.getSQL. For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getSQL

public String getSQL()

For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getValue	back to summary
public Object getValue(Session session) Overrides org.hsqldb.Expression.getValue.

resolveTypes	back to summary
public void resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

org.hsqldb back to summary

public Class ExpressionJSON.ExpressionJSONArrayFromValues

Class Inheritance

extends Expression

java.lang.Object
org.hsqldb.Expression
org.hsqldb.ExpressionJSON.ExpressionJSONArrayFromValues

Field Summary

Modifier and Type	Field and Description
pack-priv final HsqlArrayList<Expression>	exprList
pack-priv final boolean	nullOnNull

Constructor Summary

Access	Constructor and Description
public	ExpressionJSONArrayFromValues(HsqlArrayList<Expression> expressionList, boolean nullOnNull, Type dataType)

Method Summary

Modifier and Type	Method and Description
public String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

Inherited from org.hsqldb.Expression:: checkValidCheckConstraint collectAllExpressions collectAllSubqueries collectObjectNames collectRangeVariables collectRangeVariables convertToType costFactor countNulls duplicate equals equals equals equals getAggregatedValue getAlias getCheckSelect getColumn getColumnIndex getColumnName getCondition getConstantValueNoCheck getContextSQL getDataType getDegree getIndexableExpression getJoinRangeVariables getLeftNode getNodeDataType getNodeDataTypes getNullability getRangeVariable getResult getRightNode getRowValue getSimpleName getSubqueries getSubType getTable getType getUnkeyedColumns getValue getValueClassName hasAggregate hasCondition hashCode hasNonDeterministicFunction hasReference hasReference insertValuesIntoSubqueryTable isComposedOf isComposedOf isConditionRangeVariable isCorrelated isDistinctAggregate isDynamicParam isFalse isIndexable isSelfAggregate isTrue isUnresolvedParam materialise prepareTable replaceAliasInOrderBy replaceColumnReferences replaceExpressions replaceNode replaceRangeVariables resetColumnReferences resolveCheckOrGenExpression resolveColumnReferences resolveColumnReferences resolveColumnSet resolveColumnSet resolveGrantFilter setAggregate setAlias setAsConstantValue setAsConstantValue setAttributesAsColumn setCollation setCondition setCorrelatedReferences setDataType setLeftNode setNoOptimisation setRightNode setSubType swapLeftAndRightNodes testCondition updateAggregatingValue updateAggregatingValue

Field Detail

exprList	back to summary
pack-priv final HsqlArrayList<Expression> exprList

nullOnNull	back to summary
pack-priv final boolean nullOnNull

Constructor Detail

ExpressionJSONArrayFromValues	back to summary
public ExpressionJSONArrayFromValues(HsqlArrayList<Expression> expressionList, boolean nullOnNull, Type dataType)

Method Detail

describe	back to summary
public String describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.

getSQL	back to summary
public String getSQL() Overrides org.hsqldb.Expression.getSQL. Doc from org.hsqldb.Expression.getSQL. For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getSQL

public String getSQL()

For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getValue	back to summary
public Object getValue(Session session) Overrides org.hsqldb.Expression.getValue.

resolveTypes	back to summary
public void resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

org.hsqldb back to summary

public Class ExpressionJSON.ExpressionJSONObject

Class Inheritance

extends Expression

java.lang.Object
org.hsqldb.Expression
org.hsqldb.ExpressionJSON.ExpressionJSONObject

Field Summary

Modifier and Type	Field and Description
pack-priv final OrderedHashMap<Expression, Expression>	exprMap
pack-priv final boolean	nullOnNull
pack-priv final boolean	uniqueKeys

Constructor Summary

Access	Constructor and Description
public	ExpressionJSONObject(OrderedHashMap<Expression, Expression> exprMap, boolean nullOnNull, boolean uniqueKeys, Type dataType)

Method Summary

Modifier and Type	Method and Description
public String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

Inherited from org.hsqldb.Expression:: checkValidCheckConstraint collectAllExpressions collectAllSubqueries collectObjectNames collectRangeVariables collectRangeVariables convertToType costFactor countNulls duplicate equals equals equals equals getAggregatedValue getAlias getCheckSelect getColumn getColumnIndex getColumnName getCondition getConstantValueNoCheck getContextSQL getDataType getDegree getIndexableExpression getJoinRangeVariables getLeftNode getNodeDataType getNodeDataTypes getNullability getRangeVariable getResult getRightNode getRowValue getSimpleName getSubqueries getSubType getTable getType getUnkeyedColumns getValue getValueClassName hasAggregate hasCondition hashCode hasNonDeterministicFunction hasReference hasReference insertValuesIntoSubqueryTable isComposedOf isComposedOf isConditionRangeVariable isCorrelated isDistinctAggregate isDynamicParam isFalse isIndexable isSelfAggregate isTrue isUnresolvedParam materialise prepareTable replaceAliasInOrderBy replaceColumnReferences replaceExpressions replaceNode replaceRangeVariables resetColumnReferences resolveCheckOrGenExpression resolveColumnReferences resolveColumnReferences resolveColumnSet resolveColumnSet resolveGrantFilter setAggregate setAlias setAsConstantValue setAsConstantValue setAttributesAsColumn setCollation setCondition setCorrelatedReferences setDataType setLeftNode setNoOptimisation setRightNode setSubType swapLeftAndRightNodes testCondition updateAggregatingValue updateAggregatingValue

Field Detail

exprMap	back to summary
pack-priv final OrderedHashMap<Expression, Expression> exprMap

nullOnNull	back to summary
pack-priv final boolean nullOnNull

uniqueKeys	back to summary
pack-priv final boolean uniqueKeys

Constructor Detail

ExpressionJSONObject	back to summary
public ExpressionJSONObject(OrderedHashMap<Expression, Expression> exprMap, boolean nullOnNull, boolean uniqueKeys, Type dataType)

Method Detail

describe	back to summary
public String describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.

getSQL	back to summary
public String getSQL() Overrides org.hsqldb.Expression.getSQL. Doc from org.hsqldb.Expression.getSQL. For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getSQL

public String getSQL()

For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getValue	back to summary
public Object getValue(Session session) Overrides org.hsqldb.Expression.getValue.

resolveTypes	back to summary
public void resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

org.hsqldb back to summary

public Class ExpressionJSON.ExpressionJSONObjectAgg

Class Inheritance

extends Expression

java.lang.Object
org.hsqldb.Expression
org.hsqldb.ExpressionJSON.ExpressionJSONObjectAgg

Field Summary

Modifier and Type	Field and Description
pack-priv boolean	isValueJSON
pack-priv final ExpressionArrayAggregate	namesAgg
pack-priv final boolean	nullOnNull
pack-priv final boolean	uniqueKeys
pack-priv final ExpressionArrayAggregate	valuesAgg

Constructor Summary

Access	Constructor and Description
public	ExpressionJSONObjectAgg(ExpressionArrayAggregate namesAgg, ExpressionArrayAggregate valuesAgg, boolean nullOnNull, boolean uniqueKeys, Type dataType)

Method Summary

Modifier and Type	Method and Description
public String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

Inherited from org.hsqldb.Expression:: checkValidCheckConstraint collectAllExpressions collectAllSubqueries collectObjectNames collectRangeVariables collectRangeVariables convertToType costFactor countNulls duplicate equals equals equals equals getAggregatedValue getAlias getCheckSelect getColumn getColumnIndex getColumnName getCondition getConstantValueNoCheck getContextSQL getDataType getDegree getIndexableExpression getJoinRangeVariables getLeftNode getNodeDataType getNodeDataTypes getNullability getRangeVariable getResult getRightNode getRowValue getSimpleName getSubqueries getSubType getTable getType getUnkeyedColumns getValue getValueClassName hasAggregate hasCondition hashCode hasNonDeterministicFunction hasReference hasReference insertValuesIntoSubqueryTable isComposedOf isComposedOf isConditionRangeVariable isCorrelated isDistinctAggregate isDynamicParam isFalse isIndexable isSelfAggregate isTrue isUnresolvedParam materialise prepareTable replaceAliasInOrderBy replaceColumnReferences replaceExpressions replaceNode replaceRangeVariables resetColumnReferences resolveCheckOrGenExpression resolveColumnReferences resolveColumnReferences resolveColumnSet resolveColumnSet resolveGrantFilter setAggregate setAlias setAsConstantValue setAsConstantValue setAttributesAsColumn setCollation setCondition setCorrelatedReferences setDataType setLeftNode setNoOptimisation setRightNode setSubType swapLeftAndRightNodes testCondition updateAggregatingValue updateAggregatingValue

Field Detail

isValueJSON	back to summary
pack-priv boolean isValueJSON

namesAgg	back to summary
pack-priv final ExpressionArrayAggregate namesAgg

nullOnNull	back to summary
pack-priv final boolean nullOnNull

uniqueKeys	back to summary
pack-priv final boolean uniqueKeys

valuesAgg	back to summary
pack-priv final ExpressionArrayAggregate valuesAgg

Constructor Detail

ExpressionJSONObjectAgg	back to summary
public ExpressionJSONObjectAgg(ExpressionArrayAggregate namesAgg, ExpressionArrayAggregate valuesAgg, boolean nullOnNull, boolean uniqueKeys, Type dataType)

Method Detail

describe	back to summary
public String describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.

getSQL

public String getSQL()

For use with CHECK constraints. Under development. Currently supports a subset of expressions and is suitable for CHECK search conditions that refer only to the inserted/updated row. For full DDL reporting of VIEW select queries and CHECK search conditions, future improvements here are dependent upon improvements to SELECT query parsing, so that it is performed in a number of passes. An early pass should result in the query turned into an Expression tree that contains the information in the original SQL without any alterations, and with tables and columns all resolved. This Expression can then be preserved for future use. Table and column names that are not user-defined aliases should be kept as the HsqlName structures so that table or column renaming is reflected in the precompiled query.

getValue	back to summary
public Object getValue(Session session) Overrides org.hsqldb.Expression.getValue.

resolveTypes	back to summary
public void resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

org.hsqldb back to summary

public Class ExpressionJSON.ExpressionJSONWrapper

Class Inheritance

extends Expression

java.lang.Object
org.hsqldb.Expression
org.hsqldb.ExpressionJSON.ExpressionJSONWrapper

Field Summary

Constructor Summary

Access	Constructor and Description
public	ExpressionJSONWrapper(Expression expr)

Method Summary

Modifier and Type	Method and Description
public String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.

Inherited from org.hsqldb.Expression:: checkValidCheckConstraint collectAllExpressions collectAllSubqueries collectObjectNames collectRangeVariables collectRangeVariables convertToType costFactor countNulls duplicate equals equals equals equals getAggregatedValue getAlias getCheckSelect getColumn getColumnIndex getColumnName getCondition getConstantValueNoCheck getContextSQL getDataType getDegree getIndexableExpression getJoinRangeVariables getLeftNode getNodeDataType getNodeDataTypes getNullability getRangeVariable getResult getRightNode getRowValue getSimpleName getSubqueries getSubType getTable getType getUnkeyedColumns getValue getValueClassName hasAggregate hasCondition hashCode hasNonDeterministicFunction hasReference hasReference insertValuesIntoSubqueryTable isComposedOf isComposedOf isConditionRangeVariable isCorrelated isDistinctAggregate isDynamicParam isFalse isIndexable isSelfAggregate isTrue isUnresolvedParam materialise prepareTable replaceAliasInOrderBy replaceColumnReferences replaceExpressions replaceNode replaceRangeVariables resetColumnReferences resolveCheckOrGenExpression resolveColumnReferences resolveColumnReferences resolveColumnSet resolveColumnSet resolveGrantFilter setAggregate setAlias setAsConstantValue setAsConstantValue setAttributesAsColumn setCollation setCondition setCorrelatedReferences setDataType setLeftNode setNoOptimisation setRightNode setSubType swapLeftAndRightNodes testCondition updateAggregatingValue updateAggregatingValue

Constructor Detail

ExpressionJSONWrapper	back to summary
public ExpressionJSONWrapper(Expression expr)

Method Detail

describe	back to summary
public String describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.

getSQL

public String getSQL()