org.eigenbase.sql.validate
Enum SqlConformance

java.lang.Object
  java.lang.Enum<SqlConformance>
      org.eigenbase.sql.validate.SqlConformance

All Implemented Interfaces:

Serializable, Comparable<SqlConformance>

public enum SqlConformance
extends Enum<SqlConformance>

Enumeration of valid SQL compatiblity modes.

Since:

Nov 06, 2007

Version:

$Id: //open/dev/farrago/src/org/eigenbase/sql/validate/SqlConformance.java#4 $

Author:

jhyde

Enum Constant Summary

Default

Oracle10g

Pragmatic2003

Pragmatic99

Sql2003

Strict92

Strict99

Method Summary

boolean	isSortByAlias() Whether 'order by x' is interpreted to mean 'sort by the select list item whose alias is x' even if there is a column called x.
boolean	isSortByAliasObscures() Whether "empno" is invalid in "select empno as x from emp order by empno" because the alias "x" obscures it.
boolean	isSortByOrdinal() Whether 'order by 2' is interpreted to mean 'sort by the 2nd column in the select list'.
static SqlConformance	valueOf(String name) Returns the enum constant of this type with the specified name.
static SqlConformance[]	values() Returns an array containing the constants of this enum type, in the order they're declared.

Methods inherited from class java.lang.Enum

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

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

Default

public static final SqlConformance Default

Strict92

public static final SqlConformance Strict92

Strict99

public static final SqlConformance Strict99

Pragmatic99

public static final SqlConformance Pragmatic99

Oracle10g

public static final SqlConformance Oracle10g

Sql2003

public static final SqlConformance Sql2003

Pragmatic2003

public static final SqlConformance Pragmatic2003

Method Detail

values

public static final SqlConformance[] values()

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

for(SqlConformance c : SqlConformance.values())
        System.out.println(c);

Returns:

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

valueOf

public static SqlConformance valueOf(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:

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

isSortByOrdinal

public boolean isSortByOrdinal()

Whether 'order by 2' is interpreted to mean 'sort by the 2nd column in the select list'.

isSortByAlias

public boolean isSortByAlias()

Whether 'order by x' is interpreted to mean 'sort by the select list item whose alias is x' even if there is a column called x.

isSortByAliasObscures

public boolean isSortByAliasObscures()

Whether "empno" is invalid in "select empno as x from emp order by empno" because the alias "x" obscures it.