com.triactive.jdo.store.sql.expr
Class BooleanExpression

java.lang.Object
  com.triactive.jdo.store.sql.expr.AbstractSqlExpression
      com.triactive.jdo.store.sql.expr.BooleanExpression

All Implemented Interfaces:

SqlExpression, StatementTextGenerator

Direct Known Subclasses:

AlternativesExpression, BooleanLiteral, com.triactive.jdo.store.sql.expr.ComparisonExpression

public class BooleanExpression

extends AbstractSqlExpression

Nested Class Summary

Nested classes inherited from class com.triactive.jdo.store.sql.expr.AbstractSqlExpression

AbstractSqlExpression.Body, AbstractSqlExpression.CompoundExpression, AbstractSqlExpression.SimpleColumnReference, AbstractSqlExpression.SubqueryExpression

Field Summary

Fields inherited from class com.triactive.jdo.store.sql.expr.AbstractSqlExpression

body, qs

Constructor Summary

BooleanExpression(AbstractSqlExpression.Body body)

BooleanExpression(QueryStatement.QueryColumn qsc)

Method Summary

BooleanExpression	and(SqlExpression expr) Returns a new expression representing "this && expr".
BooleanExpression	eor(SqlExpression expr) Returns a new expression representing "this ^ expr".
BooleanExpression	eq(SqlExpression expr) Returns a new expression representing "this == expr".
BooleanExpression	ior(SqlExpression expr) Returns a new expression representing "this || expr".
BooleanExpression	not() Returns a new expression representing "!this".
BooleanExpression	noteq(SqlExpression expr) Returns a new expression representing "this != expr".
protected BooleanExpression	protectOuterJoins() Ensures that all columns referenced within this expression have been "protected" against exposure to OUTER JOIN-injected NULLs.
protected java.util.Set	unprotectedOuterJoins() Returns the set of unprotected outer join columns for this expression.
protected java.util.Set	unprotectedOuterJoins(QueryStatement targetQs) Returns the set of unprotected outer join columns for this expression.

Methods inherited from class com.triactive.jdo.store.sql.expr.AbstractSqlExpression

accessField, add, callMethod, cast, com, div, getColumnMapping, getJavaType, getMapping, getQueryStatement, getReferencedColumns, gt, gteq, innermostQuery, innermostQuery, lt, lteq, mod, mul, neg, newBody, newBody, newBody, newBody, newBody, newBody, newResultExpression, newSubqueryBody, select, setMapping, sub, toStatementText, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

BooleanExpression

public BooleanExpression(AbstractSqlExpression.Body body)

BooleanExpression

public BooleanExpression(QueryStatement.QueryColumn qsc)

Method Detail

and

public BooleanExpression and(SqlExpression expr)

Description copied from interface: SqlExpression

Returns a new expression representing "this && expr".

Specified by:

and in interface SqlExpression

Overrides:

and in class AbstractSqlExpression

eor

public BooleanExpression eor(SqlExpression expr)

Description copied from interface: SqlExpression

Returns a new expression representing "this ^ expr".

Specified by:

eor in interface SqlExpression

Overrides:

eor in class AbstractSqlExpression

ior

public BooleanExpression ior(SqlExpression expr)

Description copied from interface: SqlExpression

Returns a new expression representing "this || expr".

Specified by:

ior in interface SqlExpression

Overrides:

ior in class AbstractSqlExpression

not

public BooleanExpression not()

Description copied from interface: SqlExpression

Returns a new expression representing "!this".

Specified by:

not in interface SqlExpression

Overrides:

not in class AbstractSqlExpression

eq

public BooleanExpression eq(SqlExpression expr)

Description copied from interface: SqlExpression

Returns a new expression representing "this == expr".

Specified by:

eq in interface SqlExpression

Overrides:

eq in class AbstractSqlExpression

noteq

public BooleanExpression noteq(SqlExpression expr)

Description copied from interface: SqlExpression

Returns a new expression representing "this != expr".

Specified by:

noteq in interface SqlExpression

Overrides:

noteq in class AbstractSqlExpression

unprotectedOuterJoins

protected final java.util.Set unprotectedOuterJoins()

Returns the set of unprotected outer join columns for this expression. Equivalent to calling:

 unprotectedOuterJoins(qs)
 

and passing this.qs as the query statement.

Returns:

A set of QueryStatement.QueryColumn objects.

See Also:

unprotectedOuterJoins(QueryStatement)

unprotectedOuterJoins

protected java.util.Set unprotectedOuterJoins(QueryStatement targetQs)

Returns the set of unprotected outer join columns for this expression.

"Unprotected" means that the expression has not yet been modified to test that the relevant outer join columns are not NULL.

The set of columns to be protected is defined by first considering all columns referenced within the expression. Of those, any whose table expressions participated in an outer join might include rows with NULL values due to the outer join. We "protect" such references, i.e. ensure they are only exposed to actual stored data and not rows with OUTER JOIN-injected NULLs, by testing that all the columns on which the relevant table expressions were outer joined are NOT NULL.

In other words, given an expression such as:

 MOTHER.FIRST_NAME = ? AND FATHER.FIRST_NAME = ?
 

and assuming that the table expressions for MOTHER and FATHER were outer-joined on PERSON_ID, we say that the columns:

 MOTHER.PERSON_ID
 FATHER.PERSON_ID
 

are unprotected outer join columns for this expression. This example would be protected by modifying it to:

 MOTHER.PERSON_ID IS NOT NULL AND
 FATHER.PERSON_ID IS NOT NULL AND
 MOTHER.FIRST_NAME = ? AND FATHER.FIRST_NAME = ?
 

Strictly speaking this approach protects more column references than it needs to. For example, comparing FIRST_NAME to a string literal yields false anyway if FIRST_NAME is a NULL. But it's a simpler model to implement.

Parameters:

targetQs - Consider only references to columns in this statement.

Returns:

A set of QueryStatement.QueryColumn objects.

See Also:

protectOuterJoins()

protectOuterJoins

protected BooleanExpression protectOuterJoins()

Ensures that all columns referenced within this expression have been "protected" against exposure to OUTER JOIN-injected NULLs. If necessary, we AND this expression with another that tests that each unprotected outer join column IS NOT NULL.

This is called at least:

• Once for each side of an OR expression.
• Once for the entirety of a statement's WHERE condition.

Returns:

The modified expression, or this if no outer join protection was needed.

See Also:

unprotectedOuterJoins(QueryStatement), AlternativesExpression