gudusoft.gsqlparser

Enum ETableCatalogStatus

Object

Enum<ETableCatalogStatus>

gudusoft.gsqlparser.ETableCatalogStatus

All Implemented Interfaces:

Serializable, Comparable<ETableCatalogStatus>

public enum ETableCatalogStatus
extends Enum<ETableCatalogStatus>

Whether a table reference was found in the catalog metadata (TSQLEnv).

This is a fact about the TABLE, and it is separate from which table a column belongs to. In SELECT amount FROM orders the column amount belongs to orders; that is decided by the structure of the statement and does not depend on the catalog. Whether the catalog holds a table orders is a second question, answered here. Oracle orders names the table ORDERS, so a catalog holding only "Orders" answers NOT_FOUND, while the column keeps its source table and its lineage.

Read it with TTable.getCatalogStatus(). It replaces guessing from TTable.getResolvedTable() == null, which cannot tell "looked and did not find" from "did not look", and from TTable.isResolved(), which only says a lookup was attempted.

See Also:

TTable.getCatalogStatus()

Enum Constant Summary

Enum Constants

Enum Constant and Description
FOUND The catalog holds this table; TTable.getResolvedTable() is that catalog entry.
NOT_CHECKED No catalog lookup applies: the environment holds no metadata to check against, or the reference is not a catalog object at all (a CTE reference, a subquery, a table function, a table variable), or no resolver has examined the table.
NOT_FOUND The environment holds catalog metadata, this is a base table reference, and it is not in it.

Method Summary

Modifier and Type	Method and Description
static ETableCatalogStatus	valueOf(String name) Returns the enum constant of this type with the specified name.
static ETableCatalogStatus[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class Enum

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

Methods inherited from class Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

NOT_CHECKED

public static final ETableCatalogStatus NOT_CHECKED

No catalog lookup applies: the environment holds no metadata to check against, or the reference is not a catalog object at all (a CTE reference, a subquery, a table function, a table variable), or no resolver has examined the table.

FOUND

public static final ETableCatalogStatus FOUND

The catalog holds this table; TTable.getResolvedTable() is that catalog entry.

NOT_FOUND

public static final ETableCatalogStatus NOT_FOUND

The environment holds catalog metadata, this is a base table reference, and it is not in it. "Not in the metadata that was supplied" is all it claims: a system object the metadata does not list (Oracle DUAL) and a temporary table the script never declares are reported here too, truthfully.

Method Detail

values

public static ETableCatalogStatus[] 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 (ETableCatalogStatus c : ETableCatalogStatus.values())
    System.out.println(c);

Returns:

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

valueOf

public static ETableCatalogStatus 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

NullPointerException - if the argument is null