HyperSQL Database 2.7.4 · org.hsqldb.ExpressionLogical

Modifier and Type	Field and Description
pack-priv boolean	isQuantified
pack-priv boolean	isTerminal

Modifier and Type

Field and Description

pack-priv boolean

isQuantified

pack-priv boolean

isTerminal

Constructor Summary

Access	Constructor and Description
pack-priv	ExpressionLogical(int type) For LIKE
pack-priv	ExpressionLogical(boolean b) For boolean constants
pack-priv	ExpressionLogical(RangeVariable leftRangeVar, int colIndexLeft, RangeVariable rightRangeVar, int colIndexRight)
pack-priv	ExpressionLogical(Expression left, Expression right) Creates an equality expression
pack-priv	ExpressionLogical(int type, Expression left, Expression right) Creates a binary operation expression
pack-priv	ExpressionLogical(int type, Expression left, Expression right, Expression end) Creates a modified LIKE comparison
pack-priv	ExpressionLogical(int type, Expression e) Creates a unary operation expression
pack-priv	ExpressionLogical(ColumnSchema column) Creates a column not null expression for check constraints

Access

Constructor and Description

pack-priv

ExpressionLogical(int type)

For LIKE

pack-priv

ExpressionLogical(boolean b)

For boolean constants

pack-priv

ExpressionLogical(RangeVariable leftRangeVar, int colIndexLeft, RangeVariable rightRangeVar, int colIndexRight)

pack-priv

ExpressionLogical(Expression left, Expression right)

Creates an equality expression

pack-priv

ExpressionLogical(int type, Expression left, Expression right)

Creates a binary operation expression

pack-priv

ExpressionLogical(int type, Expression left, Expression right, Expression end)

Creates a modified LIKE comparison

pack-priv

ExpressionLogical(int type, Expression e)

Creates a unary operation expression

pack-priv

ExpressionLogical(ColumnSchema column)

Creates a column not null expression for check constraints

Modifier and Type	Method and Description
public void	addLeftColumnsForAllAny(RangeVariable range, OrderedIntHashSet set)
pack-priv static Expression	andExpressions(Expression e1, Expression e2)
private void	changeToRowExpression(int nodeIndex)
pack-priv void	checkRowComparison()
private Boolean	compareValues(Session session, Object left, Object right) For MATCH SIMPLE and FULL expressions, nulls in left are handled prior to calling this method
private Boolean	compareValues(Session session, Object[] leftData, Object[] rightData)
private boolean	convertDateTime(Session session) for compatibility, convert a datetime character string to a datetime value for comparison
pack-priv boolean	convertToSmaller()
pack-priv double	costFactor(Session session, RangeVariable rangeVar, int operation) Overrides org.hsqldb.Expression.costFactor.
pack-priv double	costFactorColumns(Session session, RangeVariable rangeVar)
pack-priv double	costFactorUnaryColumn(Session session, RangeVariable rangeVar)
protected String	describe(Session session, int blanks) Overrides org.hsqldb.Expression.describe.
pack-priv void	distributeOr() Converts an OR containing an AND to an AND
private Boolean	getAllAnyValue(Session session, Object[] data, TableDerived td)
pack-priv Expression	getIndexableExpression(RangeVariable rangeVar) Overrides org.hsqldb.Expression.getIndexableExpression.
pack-priv void	getJoinRangeVariables(RangeVariable[] ranges, List<RangeVariable> list) Overrides org.hsqldb.Expression.getJoinRangeVariables.
public String	getSQL() Overrides org.hsqldb.Expression.getSQL. For use with CHECK constraints.
public Object	getValue(Session session) Overrides org.hsqldb.Expression.getValue.
pack-priv boolean	isConditionRangeVariable(RangeVariable range) Overrides org.hsqldb.Expression.isConditionRangeVariable.
public boolean	isIndexable(RangeVariable rangeVar) Overrides org.hsqldb.Expression.isIndexable.
pack-priv boolean	isSimpleBound() Called only on comparison expressions after reordering which have a COLUMN left leaf
private Boolean	matchValues(Session session, Object[] leftData, Object[] rightData) For MATCH SIMPLE and FULL expressions, nulls in left are handled prior to calling this method
pack-priv static ExpressionLogical	newNotNullCondition(Expression e) Creates a NOT NULL condition
pack-priv static Expression	orExpressions(Expression e1, Expression e2)
pack-priv boolean	reorderComparison(Session session, Expression parent)
private void	resolveRowTypes()
public void	resolveTypes(Session session, Expression parent) Overrides org.hsqldb.Expression.resolveTypes.
pack-priv void	resolveTypesForAllAny(Session session)
private void	resolveTypesForComparison(Session session, Expression parent)
private void	resolveTypesForLogicalOp()
pack-priv void	resolveTypesForOverlaps()
pack-priv void	setEqualityMode()
public void	setNoOptimisation() Overrides org.hsqldb.Expression.setNoOptimisation.
public void	setSubType(int type) Overrides org.hsqldb.Expression.setSubType.
pack-priv void	swapCondition() Swap the condition with its complement
private Boolean	testAllAnyCondition(Session session)
private Boolean	testExistsCondition(Session session)
private Boolean	testInCondition(Session session) Returns the result of testing a VALUE_LIST expression
private Boolean	testMatchCondition(Session session)
private Boolean	testNotDistinctCondition(Session session)

Modifier and Type

Method and Description

public void

addLeftColumnsForAllAny(RangeVariable range, OrderedIntHashSet set)

pack-priv static Expression

andExpressions(Expression e1, Expression e2)

private void

changeToRowExpression(int nodeIndex)

pack-priv void

checkRowComparison()

private Boolean

compareValues(Session session, Object left, Object right)

For MATCH SIMPLE and FULL expressions, nulls in left are handled prior to calling this method

private Boolean

compareValues(Session session, Object[] leftData, Object[] rightData)

private boolean

convertDateTime(Session session)

for compatibility, convert a datetime character string to a datetime value for comparison

pack-priv boolean

convertToSmaller()

pack-priv double

costFactor(Session session, RangeVariable rangeVar, int operation)

Overrides org.hsqldb.Expression.costFactor.

pack-priv double

costFactorColumns(Session session, RangeVariable rangeVar)

pack-priv double

costFactorUnaryColumn(Session session, RangeVariable rangeVar)

protected String

describe(Session session, int blanks)

Overrides org.hsqldb.Expression.describe.

pack-priv void

distributeOr()

Converts an OR containing an AND to an AND

private Boolean

getAllAnyValue(Session session, Object[] data, TableDerived td)

pack-priv Expression

getIndexableExpression(RangeVariable rangeVar)

Overrides org.hsqldb.Expression.getIndexableExpression.

pack-priv void

getJoinRangeVariables(RangeVariable[] ranges, List<RangeVariable> list)

Overrides org.hsqldb.Expression.getJoinRangeVariables.

public String

getSQL()

Overrides org.hsqldb.Expression.getSQL.

For use with CHECK constraints.

public Object

getValue(Session session)

Overrides org.hsqldb.Expression.getValue.

pack-priv boolean

isConditionRangeVariable(RangeVariable range)

Overrides org.hsqldb.Expression.isConditionRangeVariable.

public boolean

isIndexable(RangeVariable rangeVar)

Overrides org.hsqldb.Expression.isIndexable.

pack-priv boolean

isSimpleBound()

Called only on comparison expressions after reordering which have a COLUMN left leaf

private Boolean

matchValues(Session session, Object[] leftData, Object[] rightData)

For MATCH SIMPLE and FULL expressions, nulls in left are handled prior to calling this method

pack-priv static ExpressionLogical

newNotNullCondition(Expression e)

Creates a NOT NULL condition

pack-priv static Expression

orExpressions(Expression e1, Expression e2)

pack-priv boolean

reorderComparison(Session session, Expression parent)

private void

resolveRowTypes()

public void

resolveTypes(Session session, Expression parent)

Overrides org.hsqldb.Expression.resolveTypes.

pack-priv void

resolveTypesForAllAny(Session session)

private void

resolveTypesForComparison(Session session, Expression parent)

private void

resolveTypesForLogicalOp()

pack-priv void

resolveTypesForOverlaps()

pack-priv void

setEqualityMode()

public void

setNoOptimisation()

Overrides org.hsqldb.Expression.setNoOptimisation.

public void

setSubType(int type)

Overrides org.hsqldb.Expression.setSubType.

pack-priv void

swapCondition()

Swap the condition with its complement

private Boolean

testAllAnyCondition(Session session)

private Boolean

testExistsCondition(Session session)

private Boolean

testInCondition(Session session)

Returns the result of testing a VALUE_LIST expression

private Boolean

testMatchCondition(Session session)

private Boolean

testNotDistinctCondition(Session session)

isQuantified	back to summary
pack-priv boolean isQuantified

isQuantified

back to summary

pack-priv boolean isQuantified

isTerminal	back to summary
pack-priv boolean isTerminal

isTerminal

back to summary

pack-priv boolean isTerminal

Constructor Detail

ExpressionLogical	back to summary
pack-priv ExpressionLogical(int type) For LIKE

ExpressionLogical	back to summary
pack-priv ExpressionLogical(boolean b) For boolean constants

ExpressionLogical	back to summary
pack-priv ExpressionLogical(RangeVariable leftRangeVar, int colIndexLeft, RangeVariable rightRangeVar, int colIndexRight)

ExpressionLogical	back to summary
pack-priv ExpressionLogical(Expression left, Expression right) Creates an equality expression

ExpressionLogical	back to summary
pack-priv ExpressionLogical(int type, Expression left, Expression right) Creates a binary operation expression

ExpressionLogical	back to summary
pack-priv ExpressionLogical(int type, Expression left, Expression right, Expression end) Creates a modified LIKE comparison

ExpressionLogical	back to summary
pack-priv ExpressionLogical(int type, Expression e) Creates a unary operation expression

ExpressionLogical	back to summary
pack-priv ExpressionLogical(ColumnSchema column) Creates a column not null expression for check constraints

Method Detail

addLeftColumnsForAllAny	back to summary
public void addLeftColumnsForAllAny(RangeVariable range, OrderedIntHashSet set)

andExpressions	back to summary
pack-priv static Expression andExpressions(Expression e1, Expression e2)

changeToRowExpression	back to summary
private void changeToRowExpression(int nodeIndex)

checkRowComparison	back to summary
pack-priv void checkRowComparison()

compareValues	back to summary
private Boolean compareValues(Session session, Object left, Object right) For MATCH SIMPLE and FULL expressions, nulls in left are handled prior to calling this method

compareValues	back to summary
private Boolean compareValues(Session session, Object[] leftData, Object[] rightData)

convertDateTime	back to summary
private boolean convertDateTime(Session session) for compatibility, convert a datetime character string to a datetime value for comparison

convertToSmaller	back to summary
pack-priv boolean convertToSmaller()

costFactor	back to summary
pack-priv double costFactor(Session session, RangeVariable rangeVar, int operation) Overrides org.hsqldb.Expression.costFactor.

costFactorColumns	back to summary
pack-priv double costFactorColumns(Session session, RangeVariable rangeVar)

costFactorUnaryColumn	back to summary
pack-priv double costFactorUnaryColumn(Session session, RangeVariable rangeVar)

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

distributeOr	back to summary
pack-priv void distributeOr() Converts an OR containing an AND to an AND

getAllAnyValue	back to summary
private Boolean getAllAnyValue(Session session, Object[] data, TableDerived td)

getIndexableExpression	back to summary
pack-priv Expression getIndexableExpression(RangeVariable rangeVar) Overrides org.hsqldb.Expression.getIndexableExpression.

getJoinRangeVariables	back to summary
pack-priv void getJoinRangeVariables(RangeVariable[] ranges, List<RangeVariable> list) Overrides org.hsqldb.Expression.getJoinRangeVariables.

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

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.

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

isConditionRangeVariable	back to summary
pack-priv boolean isConditionRangeVariable(RangeVariable range) Overrides org.hsqldb.Expression.isConditionRangeVariable.

isIndexable	back to summary
public boolean isIndexable(RangeVariable rangeVar) Overrides org.hsqldb.Expression.isIndexable.

isSimpleBound	back to summary
pack-priv boolean isSimpleBound() Called only on comparison expressions after reordering which have a COLUMN left leaf

matchValues	back to summary
private Boolean matchValues(Session session, Object[] leftData, Object[] rightData) For MATCH SIMPLE and FULL expressions, nulls in left are handled prior to calling this method

newNotNullCondition	back to summary
pack-priv static ExpressionLogical newNotNullCondition(Expression e) Creates a NOT NULL condition

orExpressions	back to summary
pack-priv static Expression orExpressions(Expression e1, Expression e2)

reorderComparison	back to summary
pack-priv boolean reorderComparison(Session session, Expression parent)

resolveRowTypes	back to summary
private void resolveRowTypes()

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

resolveTypesForAllAny	back to summary
pack-priv void resolveTypesForAllAny(Session session)

resolveTypesForComparison	back to summary
private void resolveTypesForComparison(Session session, Expression parent)

resolveTypesForLogicalOp	back to summary
private void resolveTypesForLogicalOp()

resolveTypesForOverlaps	back to summary
pack-priv void resolveTypesForOverlaps()

setEqualityMode	back to summary
pack-priv void setEqualityMode()

setNoOptimisation	back to summary
public void setNoOptimisation() Overrides org.hsqldb.Expression.setNoOptimisation.

setSubType	back to summary
public void setSubType(int type) Overrides org.hsqldb.Expression.setSubType.

swapCondition	back to summary
pack-priv void swapCondition() Swap the condition with its complement

testAllAnyCondition	back to summary
private Boolean testAllAnyCondition(Session session)

testExistsCondition	back to summary
private Boolean testExistsCondition(Session session)

testInCondition	back to summary
private Boolean testInCondition(Session session) Returns the result of testing a VALUE_LIST expression

testMatchCondition	back to summary
private Boolean testMatchCondition(Session session)

testNotDistinctCondition	back to summary
private Boolean testNotDistinctCondition(Session session)

public Class ExpressionLogical

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail