org.teiid.query.optimizer.capabilities
Enum SourceCapabilities.Capability

java.lang.Object
  java.lang.Enum<SourceCapabilities.Capability>
      org.teiid.query.optimizer.capabilities.SourceCapabilities.Capability

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<SourceCapabilities.Capability>

Enclosing interface:

SourceCapabilities

public static enum SourceCapabilities.Capability
extends java.lang.Enum<SourceCapabilities.Capability>

Enum Constant Summary

BATCHED_UPDATES
Support indicates connector can accept queries with searched CASE WHEN ...

BULK_UPDATE

COMMON_TABLE_EXPRESSIONS

CONNECTOR_ID
The connector ID, which is used by the optimizer to determine when two models are bound to the same connector

CRITERIA_BETWEEN
Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)

CRITERIA_COMPARE_EQ
Support indicates connector accepts criteria of form (element operator constant)

CRITERIA_COMPARE_ORDERED

CRITERIA_EXISTS
Support indicates connector accepts the EXISTS criteria

CRITERIA_IN
Support indicates connector accepts criteria of form (element IN set)

CRITERIA_IN_SUBQUERY
Support indicates connector accepts IN criteria with a subquery on the right side

CRITERIA_ISNULL
Support indicates connector accepts criteria of form (element IS NULL)

CRITERIA_LIKE
Support indicates connector accepts criteria of form (element LIKE constant)

CRITERIA_LIKE_ESCAPE
Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char) - CURRENTLY NOT USED

CRITERIA_NOT
Support indicates connector accepts logical criteria NOT

CRITERIA_OR
Support indicates connector accepts logical criteria connected by OR

CRITERIA_QUANTIFIED_ALL
Support indicates connector accepts the quantified comparison criteria that use ALL

CRITERIA_QUANTIFIED_SOME
Support indicates connector accepts the quantified comparison criteria that use SOME

INSERT_WITH_ITERATOR

INSERT_WITH_QUERYEXPRESSION

JOIN_CRITERIA_ALLOWED

MAX_IN_CRITERIA_SIZE
The Maximum number of values allowed in an IN criteria (Integer)

MAX_QUERY_FROM_GROUPS
Max number of groups appearing in a from clause

QUERY_AGGREGATES
Composite support for group by and having - not used by the connector layer

QUERY_AGGREGATES_AVG
Support indicates connector can accept the AVG aggregate function

QUERY_AGGREGATES_COUNT
Support indicates connector can accept the COUNT aggregate function

QUERY_AGGREGATES_COUNT_STAR
Support indicates connector can accept the COUNT(*) aggregate function

QUERY_AGGREGATES_DISTINCT
Support indicates connector can accept DISTINCT within aggregate functions

QUERY_AGGREGATES_ENHANCED_NUMERIC
Support indicates connector can accept the enhanced numeric aggregates

QUERY_AGGREGATES_MAX
Support indicates connector can accept the MAX aggregate function

QUERY_AGGREGATES_MIN
Support indicates connector can accept the MIN aggregate function

QUERY_AGGREGATES_SUM
Support indicates connector can accept the SUM aggregate function

QUERY_CASE
Support indicates connector can accept queries with non-searched CASE WHEN ...

QUERY_EXCEPT
Support indicates connector can accept EXCEPT

QUERY_FROM_ANSI_JOIN
Indicates that the source prefers ANSI style joins

QUERY_FROM_GROUP_ALIAS
Support indicates connector can accept joins where groups have aliases (required for QUERY_FROM_JOIN_SELFJOIN)

QUERY_FROM_INLINE_VIEWS
Support indicates connector can push down inline views

QUERY_FROM_JOIN_INNER
Support indicates connector can accept inner joins

QUERY_FROM_JOIN_OUTER
Support indicates connector can accept right or left outer joins

QUERY_FROM_JOIN_OUTER_FULL
Support indicates connector can accept full outer joins

QUERY_FROM_JOIN_SELFJOIN
Support indicates connector can accept self-joins where a group is joined to itself with aliases

QUERY_FUNCTIONS_IN_GROUP_BY
Support indicates connector can accept GROUP BY with functions in it.

QUERY_GROUP_BY

QUERY_HAVING

QUERY_INTERSECT
Support indicates connector can accept INTERSECT

QUERY_ORDERBY
Support indicates connector accepts ORDER BY clause

QUERY_ORDERBY_DEFAULT_NULL_ORDER

QUERY_ORDERBY_NULL_ORDERING

QUERY_ORDERBY_UNRELATED

QUERY_SEARCHED_CASE
Support indicates connector can accept queries with searched CASE WHEN ...

QUERY_SELECT_DISTINCT
Support indicates connector can accept queries with SELECT DISTINCT

QUERY_SELECT_EXPRESSION
Support indicates connector can accept queries non-elements in the SELECT

QUERY_SET_ORDER_BY
Support indicates connector can accept SET QUERY with an ORDER BY clause

QUERY_SUBQUERIES_CORRELATED
Support indicates connector can accept correalted subqueries wherever subqueries are accepted

QUERY_SUBQUERIES_SCALAR
Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses

QUERY_UNION
Support indicates connector can accept UNION and UNION ALL

REQUIRES_CRITERIA

ROW_LIMIT
Support indicates connector can limit result rows

ROW_OFFSET
Support indicates connector support a SQL clause whose output rows offset from the query's result rows (similar to LIMIT with offset)

Method Summary

static SourceCapabilities.Capability	valueOf(java.lang.String name) Returns the enum constant of this type with the specified name.
static SourceCapabilities.Capability[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

QUERY_SELECT_DISTINCT

public static final SourceCapabilities.Capability QUERY_SELECT_DISTINCT

Support indicates connector can accept queries with SELECT DISTINCT

QUERY_SELECT_EXPRESSION

public static final SourceCapabilities.Capability QUERY_SELECT_EXPRESSION

Support indicates connector can accept queries non-elements in the SELECT

QUERY_FROM_GROUP_ALIAS

public static final SourceCapabilities.Capability QUERY_FROM_GROUP_ALIAS

Support indicates connector can accept joins where groups have aliases (required for QUERY_FROM_JOIN_SELFJOIN)

Since:

3.1 SP2

MAX_QUERY_FROM_GROUPS

public static final SourceCapabilities.Capability MAX_QUERY_FROM_GROUPS

Max number of groups appearing in a from clause

JOIN_CRITERIA_ALLOWED

public static final SourceCapabilities.Capability JOIN_CRITERIA_ALLOWED

Since:

6.1.0

QUERY_FROM_JOIN_INNER

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_INNER

Support indicates connector can accept inner joins

Since:

3.1 SP2

QUERY_FROM_ANSI_JOIN

public static final SourceCapabilities.Capability QUERY_FROM_ANSI_JOIN

Indicates that the source prefers ANSI style joins

Since:

6.0.0

QUERY_FROM_JOIN_SELFJOIN

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_SELFJOIN

Support indicates connector can accept self-joins where a group is joined to itself with aliases

Since:

3.1 SP2

QUERY_FROM_JOIN_OUTER

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_OUTER

Support indicates connector can accept right or left outer joins

Since:

3.1 SP2

QUERY_FROM_INLINE_VIEWS

public static final SourceCapabilities.Capability QUERY_FROM_INLINE_VIEWS

Support indicates connector can push down inline views

Since:

4.1

QUERY_FROM_JOIN_OUTER_FULL

public static final SourceCapabilities.Capability QUERY_FROM_JOIN_OUTER_FULL

Support indicates connector can accept full outer joins

Since:

3.1 SP2

CRITERIA_BETWEEN

public static final SourceCapabilities.Capability CRITERIA_BETWEEN

Support indicates connector accepts criteria of form (element BETWEEN constant AND constant)

Since:

4.0

CRITERIA_COMPARE_EQ

public static final SourceCapabilities.Capability CRITERIA_COMPARE_EQ

Support indicates connector accepts criteria of form (element operator constant)

Since:

3.1 SP2

CRITERIA_COMPARE_ORDERED

public static final SourceCapabilities.Capability CRITERIA_COMPARE_ORDERED

CRITERIA_LIKE

public static final SourceCapabilities.Capability CRITERIA_LIKE

Support indicates connector accepts criteria of form (element LIKE constant)

Since:

3.1 SP2

CRITERIA_LIKE_ESCAPE

public static final SourceCapabilities.Capability CRITERIA_LIKE_ESCAPE

Support indicates connector accepts criteria of form (element LIKE constant ESCAPE char) - CURRENTLY NOT USED

Since:

3.1 SP2

CRITERIA_IN

public static final SourceCapabilities.Capability CRITERIA_IN

Support indicates connector accepts criteria of form (element IN set)

Since:

3.1 SP2

CRITERIA_IN_SUBQUERY

public static final SourceCapabilities.Capability CRITERIA_IN_SUBQUERY

Support indicates connector accepts IN criteria with a subquery on the right side

Since:

4.0

CRITERIA_ISNULL

public static final SourceCapabilities.Capability CRITERIA_ISNULL

Support indicates connector accepts criteria of form (element IS NULL)

Since:

3.1 SP2

CRITERIA_OR

public static final SourceCapabilities.Capability CRITERIA_OR

Support indicates connector accepts logical criteria connected by OR

Since:

3.1 SP2

CRITERIA_NOT

public static final SourceCapabilities.Capability CRITERIA_NOT

Support indicates connector accepts logical criteria NOT

Since:

3.1 SP2

CRITERIA_EXISTS

public static final SourceCapabilities.Capability CRITERIA_EXISTS

Support indicates connector accepts the EXISTS criteria

Since:

4.0

CRITERIA_QUANTIFIED_SOME

public static final SourceCapabilities.Capability CRITERIA_QUANTIFIED_SOME

Support indicates connector accepts the quantified comparison criteria that use SOME

Since:

4.0

CRITERIA_QUANTIFIED_ALL

public static final SourceCapabilities.Capability CRITERIA_QUANTIFIED_ALL

Support indicates connector accepts the quantified comparison criteria that use ALL

Since:

4.0

QUERY_ORDERBY

public static final SourceCapabilities.Capability QUERY_ORDERBY

Support indicates connector accepts ORDER BY clause

Since:

3.1 SP2

QUERY_ORDERBY_UNRELATED

public static final SourceCapabilities.Capability QUERY_ORDERBY_UNRELATED

QUERY_ORDERBY_NULL_ORDERING

public static final SourceCapabilities.Capability QUERY_ORDERBY_NULL_ORDERING

QUERY_ORDERBY_DEFAULT_NULL_ORDER

public static final SourceCapabilities.Capability QUERY_ORDERBY_DEFAULT_NULL_ORDER

QUERY_AGGREGATES

public static final SourceCapabilities.Capability QUERY_AGGREGATES

Composite support for group by and having - not used by the connector layer

QUERY_GROUP_BY

public static final SourceCapabilities.Capability QUERY_GROUP_BY

Since:

6.1.0 indicates support for GROUP BY

QUERY_HAVING

public static final SourceCapabilities.Capability QUERY_HAVING

Since:

6.1.0 indicates support for HAVING

QUERY_AGGREGATES_SUM

public static final SourceCapabilities.Capability QUERY_AGGREGATES_SUM

Support indicates connector can accept the SUM aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_AVG

public static final SourceCapabilities.Capability QUERY_AGGREGATES_AVG

Support indicates connector can accept the AVG aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_MIN

public static final SourceCapabilities.Capability QUERY_AGGREGATES_MIN

Support indicates connector can accept the MIN aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_MAX

public static final SourceCapabilities.Capability QUERY_AGGREGATES_MAX

Support indicates connector can accept the MAX aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_ENHANCED_NUMERIC

public static final SourceCapabilities.Capability QUERY_AGGREGATES_ENHANCED_NUMERIC

Support indicates connector can accept the enhanced numeric aggregates

Since:

3.1 SP2

QUERY_AGGREGATES_COUNT

public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT

Support indicates connector can accept the COUNT aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_COUNT_STAR

public static final SourceCapabilities.Capability QUERY_AGGREGATES_COUNT_STAR

Support indicates connector can accept the COUNT(*) aggregate function

Since:

3.1 SP2

QUERY_AGGREGATES_DISTINCT

public static final SourceCapabilities.Capability QUERY_AGGREGATES_DISTINCT

Support indicates connector can accept DISTINCT within aggregate functions

Since:

3.1 SP2

QUERY_SUBQUERIES_SCALAR

public static final SourceCapabilities.Capability QUERY_SUBQUERIES_SCALAR

Support indicates connector can accept scalar subqueries in the SELECT, WHERE, and HAVING clauses

Since:

4.0

QUERY_SUBQUERIES_CORRELATED

public static final SourceCapabilities.Capability QUERY_SUBQUERIES_CORRELATED

Support indicates connector can accept correalted subqueries wherever subqueries are accepted

Since:

4.0

QUERY_CASE

public static final SourceCapabilities.Capability QUERY_CASE

Support indicates connector can accept queries with non-searched CASE WHEN ... END

Since:

4.0

QUERY_SEARCHED_CASE

public static final SourceCapabilities.Capability QUERY_SEARCHED_CASE

Support indicates connector can accept queries with searched CASE WHEN ... END

Since:

4.0

QUERY_UNION

public static final SourceCapabilities.Capability QUERY_UNION

Support indicates connector can accept UNION and UNION ALL

Since:

4.2

QUERY_INTERSECT

public static final SourceCapabilities.Capability QUERY_INTERSECT

Support indicates connector can accept INTERSECT

Since:

5.6

QUERY_EXCEPT

public static final SourceCapabilities.Capability QUERY_EXCEPT

Support indicates connector can accept EXCEPT

Since:

5.6

QUERY_SET_ORDER_BY

public static final SourceCapabilities.Capability QUERY_SET_ORDER_BY

Support indicates connector can accept SET QUERY with an ORDER BY clause

Since:

4.2

QUERY_FUNCTIONS_IN_GROUP_BY

public static final SourceCapabilities.Capability QUERY_FUNCTIONS_IN_GROUP_BY

Support indicates connector can accept GROUP BY with functions in it.

Since:

5.0

BATCHED_UPDATES

public static final SourceCapabilities.Capability BATCHED_UPDATES

Support indicates connector can accept queries with searched CASE WHEN ... END

Since:

4.2

BULK_UPDATE

public static final SourceCapabilities.Capability BULK_UPDATE

ROW_LIMIT

public static final SourceCapabilities.Capability ROW_LIMIT

Support indicates connector can limit result rows

Since:

5.0 SP1

ROW_OFFSET

public static final SourceCapabilities.Capability ROW_OFFSET

Support indicates connector support a SQL clause whose output rows offset from the query's result rows (similar to LIMIT with offset)

Since:

5.0 SP1

MAX_IN_CRITERIA_SIZE

public static final SourceCapabilities.Capability MAX_IN_CRITERIA_SIZE

The Maximum number of values allowed in an IN criteria (Integer)

Since:

4.4

CONNECTOR_ID

public static final SourceCapabilities.Capability CONNECTOR_ID

The connector ID, which is used by the optimizer to determine when two models are bound to the same connector

Since:

5.0.2

REQUIRES_CRITERIA

public static final SourceCapabilities.Capability REQUIRES_CRITERIA

Since:

6.0.0 indicates support for where all

INSERT_WITH_QUERYEXPRESSION

public static final SourceCapabilities.Capability INSERT_WITH_QUERYEXPRESSION

INSERT_WITH_ITERATOR

public static final SourceCapabilities.Capability INSERT_WITH_ITERATOR

COMMON_TABLE_EXPRESSIONS

public static final SourceCapabilities.Capability COMMON_TABLE_EXPRESSIONS

Method Detail

values

public static SourceCapabilities.Capability[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (SourceCapabilities.Capability c : SourceCapabilities.Capability.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static SourceCapabilities.Capability valueOf(java.lang.String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

java.lang.IllegalArgumentException - if this enum type has no constant with the specified name

java.lang.NullPointerException - if the argument is null