"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "hsqldb/src/org/hsqldb/dbinfo/DatabaseInformationFull.java" between
hsqldb-2.7.0.zip and hsqldb-2.7.1.zip

About: HSQLDB (HyperSQL DataBase) is a SQL relational database engine written in Java. It supports nearly full ANSI-92 SQL (BNF format) and full core SQL:2008.

[ To the main hsqldb source changes report ]

DatabaseInformationFull.java  (hsqldb-2.7.0):DatabaseInformationFull.java  (hsqldb-2.7.1)
skipping to change at line 115 skipping to change at line 115
* Provides definitions for most of the SQL Standard Schemata views that are * Provides definitions for most of the SQL Standard Schemata views that are
* supported by HSQLDB.<p> * supported by HSQLDB.<p>
* *
* Provides definitions for some of HSQLDB's additional system vies. * Provides definitions for some of HSQLDB's additional system vies.
* *
* The definitions for the rest of system vies are provided by * The definitions for the rest of system vies are provided by
* DatabaseInformationMain, which this class extends. <p> * DatabaseInformationMain, which this class extends. <p>
* *
* @author Campbell Burnet (campbell-burnet@users dot sourceforge.net) * @author Campbell Burnet (campbell-burnet@users dot sourceforge.net)
* @author Fred Toussi (fredt@users dot sourceforge.net) * @author Fred Toussi (fredt@users dot sourceforge.net)
* @version 2.7.0 * @version 2.7.1
* @since 1.7.2 * @since 1.7.2
*/ */
final class DatabaseInformationFull final class DatabaseInformationFull
extends org.hsqldb.dbinfo.DatabaseInformationMain { extends org.hsqldb.dbinfo.DatabaseInformationMain {
static final String resourceFileName = static final String resourceFileName =
"/org/hsqldb/resources/information-schema.sql"; "/org/hsqldb/resources/information-schema.sql";
static final OrderedHashMap statementMap = static final OrderedHashMap statementMap =
LineGroupReader.getStatementMap(resourceFileName); LineGroupReader.getStatementMap(resourceFileName);
skipping to change at line 2695 skipping to change at line 2695
} }
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* The COLUMN_COLUMN_USAGE view has one row for each column referenced by * The COLUMN_COLUMN_USAGE view has one row for each column referenced by
* a GENERATED column.<p> * a GENERATED column.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* <pre> * <pre>
* TABLE_CATALOG VARCHAR * TABLE_CATALOG VARCHAR
* TABLE_SCHEMA VARCHAR * TABLE_SCHEMA VARCHAR
* TABLE_NAME VARCHAR * TABLE_NAME VARCHAR
* COLUMN_NAME VARCHAR * COLUMN_NAME VARCHAR
* DEPENDENT_COLUMN VARCHAR * DEPENDENT_COLUMN VARCHAR
* *
* </pre> * </pre>
* *
* <b>Description:</b> * <b>Description:</b>
skipping to change at line 2809 skipping to change at line 2809
} }
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* The COLUMN_DOMAIN_USAGE view has one row for each column defined with a * The COLUMN_DOMAIN_USAGE view has one row for each column defined with a
* a DOMAIN data type.<p> * a DOMAIN data type.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* <pre> * <pre>
* DOMAIN_CATALOG VARCHAR * DOMAIN_CATALOG VARCHAR
* DOMAIN_SCHEMA VARCHAR * DOMAIN_SCHEMA VARCHAR
* DOMAIN_NAME VARCHAR * DOMAIN_NAME VARCHAR
* TABLE_CATALOG VARCHAR * TABLE_CATALOG VARCHAR
* TABLE_SCHEMA VARCHAR * TABLE_SCHEMA VARCHAR
* TABLE_NAME VARCHAR * TABLE_NAME VARCHAR
* COLUMN_NAME VARCHAR * COLUMN_NAME VARCHAR
* *
* </pre> * </pre>
skipping to change at line 2927 skipping to change at line 2927
} }
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* The COLUMN_DOMAIN_USAGE view has one row for each column defined with a * The COLUMN_DOMAIN_USAGE view has one row for each column defined with a
* a DOMAIN data type.<p> * a DOMAIN data type.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* UDT_CATALOG VARCHAR * UDT_CATALOG VARCHAR
* UDT_SCHEMA VARCHAR * UDT_SCHEMA VARCHAR
* UDT_NAME VARCHAR * UDT_NAME VARCHAR
* TABLE_CATALOG VARCHAR * TABLE_CATALOG VARCHAR
* TABLE_SCHEMA VARCHAR * TABLE_SCHEMA VARCHAR
* TABLE_NAME VARCHAR * TABLE_NAME VARCHAR
* COLUMN_NAME VARCHAR * COLUMN_NAME VARCHAR
* *
skipping to change at line 3363 skipping to change at line 3363
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The CONSTRAINT_COLUMN_USAGE view has one row for each column identified b y * The CONSTRAINT_COLUMN_USAGE view has one row for each column identified b y
* a table constraint or assertion.<p> * a table constraint or assertion.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TABLE_CATALOG VARCHAR * TABLE_CATALOG VARCHAR
* TABLE_SCHEMA VARCHAR * TABLE_SCHEMA VARCHAR
* TABLE_NAME VARCHAR * TABLE_NAME VARCHAR
* COLUMN_NAME VARCHAR * COLUMN_NAME VARCHAR
* CONSTRAINT_CATALOG VARCHAR * CONSTRAINT_CATALOG VARCHAR
* CONSTRAINT_SCHEMA VARCHAR * CONSTRAINT_SCHEMA VARCHAR
* CONSTRAINT_NAME VARCHAR * CONSTRAINT_NAME VARCHAR
* *
skipping to change at line 3555 skipping to change at line 3555
return t; return t;
} }
/** /**
* SQL:2011 VIEW<p> * SQL:2011 VIEW<p>
* *
* The CONSTRAINT_PERIOD_USAGE view has one row for each PERIOD referenced * The CONSTRAINT_PERIOD_USAGE view has one row for each PERIOD referenced
* by a table constraint or assertion.<p> * by a table constraint or assertion.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TABLE_CATALOG VARCHAR * TABLE_CATALOG VARCHAR
* TABLE_SCHEMA VARCHAR * TABLE_SCHEMA VARCHAR
* TABLE_NAME VARCHAR * TABLE_NAME VARCHAR
* PERIOD_NAME VARCHAR * PERIOD_NAME VARCHAR
* CONSTRAINT_CATALOG VARCHAR * CONSTRAINT_CATALOG VARCHAR
* CONSTRAINT_SCHEMA VARCHAR * CONSTRAINT_SCHEMA VARCHAR
* CONSTRAINT_NAME VARCHAR * CONSTRAINT_NAME VARCHAR
* *
skipping to change at line 3944 skipping to change at line 3944
* <b>Description:</b> * <b>Description:</b>
* *
* <ol> * <ol>
* <li> A constraint is shown in this view if the authorization for the * <li> A constraint is shown in this view if the authorization for the
* DOMAIN that contains the constraint is the current user or is a role * DOMAIN that contains the constraint is the current user or is a role
* assigned to the current user. * assigned to the current user.
* *
* <li> The values of CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA and * <li> The values of CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA and
* CONSTRAINT_NAME are the catalog name, schema name, * CONSTRAINT_NAME are the catalog name, schema name,
* and identifier, respectively, of the constraint being * and identifier, respectively, of the constraint being
* described. <p> * described.
* *
* <li> Constraints are reported only if the user or one of its roles is * <li> Constraints are reported only if the user or one of its roles is
* the authorization (owner) of the DOMAIN. * the authorization (owner) of the DOMAIN.
* </ol> * </ol>
* *
* @return Table * @return Table
*/ */
Table DOMAIN_CONSTRAINTS(Session session, PersistentStore store) { Table DOMAIN_CONSTRAINTS(Session session, PersistentStore store) {
Table t = sysTables[DOMAIN_CONSTRAINTS]; Table t = sysTables[DOMAIN_CONSTRAINTS];
skipping to change at line 5909 skipping to change at line 5909
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The ROUTINE_COLUMN_USAGE view has one row for each column * The ROUTINE_COLUMN_USAGE view has one row for each column
* referenced in the body of a routine.<p> * referenced in the body of a routine.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* ROUTINE_CATALOG VARCHAR , * ROUTINE_CATALOG VARCHAR ,
* ROUTINE_SCHEMA VARCHAR , * ROUTINE_SCHEMA VARCHAR ,
* ROUTINE_NAME VARCHAR , * ROUTINE_NAME VARCHAR ,
* TABLE_CATALOG VARCHAR , * TABLE_CATALOG VARCHAR ,
* TABLE_SCHEMA VARCHAR , * TABLE_SCHEMA VARCHAR ,
skipping to change at line 6036 skipping to change at line 6036
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The ROUTINE_JAR_USAGE view has one row for each jar archive * The ROUTINE_JAR_USAGE view has one row for each jar archive
* referenced in the body of a Java routine.<p> * referenced in the body of a Java routine.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* JAR_CATALOG VARCHAR , * JAR_CATALOG VARCHAR ,
* JAR_SCHEMA VARCHAR , * JAR_SCHEMA VARCHAR ,
* JAR_NAME VARCHAR , * JAR_NAME VARCHAR ,
* *
* </pre> * </pre>
skipping to change at line 6138 skipping to change at line 6138
return t; return t;
} }
/** /**
* SQL:2011 VIEW<p> * SQL:2011 VIEW<p>
* *
* The ROUTINE_PERIOD_USAGE view has one row for each PERIOD * The ROUTINE_PERIOD_USAGE view has one row for each PERIOD
* referenced in the body of a routine.<p> * referenced in the body of a routine.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* ROUTINE_CATALOG VARCHAR , * ROUTINE_CATALOG VARCHAR ,
* ROUTINE_SCHEMA VARCHAR , * ROUTINE_SCHEMA VARCHAR ,
* ROUTINE_NAME VARCHAR , * ROUTINE_NAME VARCHAR ,
* TABLE_CATALOG VARCHAR , * TABLE_CATALOG VARCHAR ,
* TABLE_SCHEMA VARCHAR , * TABLE_SCHEMA VARCHAR ,
skipping to change at line 6418 skipping to change at line 6418
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The ROUTINE_ROUTINE_USAGE view has one row for each routine * The ROUTINE_ROUTINE_USAGE view has one row for each routine
* referenced in the body of a routine.<p> * referenced in the body of a routine.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* ROUTINE_CATALOG VARCHAR , * ROUTINE_CATALOG VARCHAR ,
* ROUTINE_SCHEMA VARCHAR , * ROUTINE_SCHEMA VARCHAR ,
* ROUTINE_NAME VARCHAR , * ROUTINE_NAME VARCHAR ,
* *
* </pre> * </pre>
* *
* <b>Description:</b> * <b>Description:</b>
* *
* <ol> * <ol>
* <li> The values of SPECIFIC_CATALOG, SPECIFIC_SCHEMA and * <li> The values of SPECIFIC_CATALOG, SPECIFIC_SCHEMA and
* SPECIFIC_NAME are the catalog name, schema name, * SPECIFIC_NAME are the catalog name, schema name,
* specific routine identifier, respectively, of the routine * specific routine identifier, respectively, of the routine
* which contains the reference. * which contains the reference.
* <li> The values of ROUTINE_CATALOG, ROUTINE_SCHEMA and ROUTINE_NAME * <li> The values of ROUTINE_CATALOG, ROUTINE_SCHEMA and ROUTINE_NAME
* are the catalog name, schema name and * are the catalog name, schema name and
* identifier, respectively, of the routine that is referenced.<p> * identifier, respectively, of the routine that is referenced.
* *
* <li> Referenced routines are reported only if the user or one of its role s is * <li> Referenced routines are reported only if the user or one of its role s is
* the authorization (owner) of the referenced routine. * the authorization (owner) of the referenced routine.
* *
* </ol> * </ol>
* *
* @return Table * @return Table
*/ */
Table ROUTINE_ROUTINE_USAGE(Session session, PersistentStore store) { Table ROUTINE_ROUTINE_USAGE(Session session, PersistentStore store) {
skipping to change at line 6526 skipping to change at line 6526
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The ROUTINE_SEQUENCE_USAGE view has one row for each SEQUENCE * The ROUTINE_SEQUENCE_USAGE view has one row for each SEQUENCE
* referenced in the body of a routine.<p> * referenced in the body of a routine.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* SEQUENCE_CATALOG VARCHAR , * SEQUENCE_CATALOG VARCHAR ,
* SEQUENCE_SCHEMA VARCHAR , * SEQUENCE_SCHEMA VARCHAR ,
* SEQUENCE_NAME VARCHAR , * SEQUENCE_NAME VARCHAR ,
* *
* </pre> * </pre>
skipping to change at line 6634 skipping to change at line 6634
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The ROUTINE_TABLE_USAGE view has one row for each TABLE * The ROUTINE_TABLE_USAGE view has one row for each TABLE
* referenced in the body of a routine.<p> * referenced in the body of a routine.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* ROUTINE_CATALOG VARCHAR , * ROUTINE_CATALOG VARCHAR ,
* ROUTINE_SCHEMA VARCHAR , * ROUTINE_SCHEMA VARCHAR ,
* ROUTINE_NAME VARCHAR , * ROUTINE_NAME VARCHAR ,
* TABLE_CATALOG VARCHAR , * TABLE_CATALOG VARCHAR ,
* TABLE_SCHEMA VARCHAR , * TABLE_SCHEMA VARCHAR ,
skipping to change at line 7142 skipping to change at line 7142
} }
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The SCHEMATA view has one row for each accessible schema. <p> * The SCHEMATA view has one row for each accessible schema. <p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* <pre> * <pre>
* CATALOG_NAME VARCHAR , * CATALOG_NAME VARCHAR ,
* SCHEMA_NAME VARCHAR , * SCHEMA_NAME VARCHAR ,
* SCHEMA_OWNER VARCHAR , * SCHEMA_OWNER VARCHAR ,
* DEFAULT_CHARACTER_SET_CATALOG VARCHAR , * DEFAULT_CHARACTER_SET_CATALOG VARCHAR ,
* DEFAULT_CHARACTER_SET_SCHEMA VARCHAR , * DEFAULT_CHARACTER_SET_SCHEMA VARCHAR ,
* DEFAULT_CHARACTER_SET_NAME VARCHAR , * DEFAULT_CHARACTER_SET_NAME VARCHAR ,
* SQL_PATH VARCHAR , * SQL_PATH VARCHAR ,
* *
* </pre> * </pre>
skipping to change at line 7715 skipping to change at line 7715
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The TRIGGER_COLUMN_USAGE view has one row for each column * The TRIGGER_COLUMN_USAGE view has one row for each column
* referenced in the body of a trigger.<p> * referenced in the body of a trigger.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* TABLE_CATALOG VARCHAR , * TABLE_CATALOG VARCHAR ,
* TABLE_SCHEMA VARCHAR , * TABLE_SCHEMA VARCHAR ,
* TABLE_NAME VARCHAR , * TABLE_NAME VARCHAR ,
* COLUMN_NAME VARCHAR , * COLUMN_NAME VARCHAR ,
* *
skipping to change at line 7836 skipping to change at line 7836
// Initialization // Initialization
return t; return t;
} }
/** /**
* SQL:2011 VIEW<p> * SQL:2011 VIEW<p>
* *
* The TRIGGER_PERIOD_USAGE view has one row for each PRDIOD * The TRIGGER_PERIOD_USAGE view has one row for each PRDIOD
* referenced in the body of a trigger.<p> * referenced in the body of a trigger.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* TABLE_CATALOG VARCHAR , * TABLE_CATALOG VARCHAR ,
* TABLE_SCHEMA VARCHAR , * TABLE_SCHEMA VARCHAR ,
* TABLE_NAME VARCHAR , * TABLE_NAME VARCHAR ,
* *
* </pre> * </pre>
* *
* <b>Description:</b> * <b>Description:</b>
* *
* <ol> * <ol>
* <li> The values of TRIGGER_CATALOG, TRIGGER_SCHEMA and TRIGGER_NAME * <li> The values of TRIGGER_CATALOG, TRIGGER_SCHEMA and TRIGGER_NAME
* are the catalog name, schema name and * are the catalog name, schema name and
* identifier, respectively, of the TRIGGER. * identifier, respectively, of the TRIGGER.
* <li> The values of TABLE_CATALOG, TABLE_SCHEMA and * <li> The values of TABLE_CATALOG, TABLE_SCHEMA and
* TABLE_NAME are the catalog name, schema name and * TABLE_NAME are the catalog name, schema name and
* identifier, respectively, of the TABLE * identifier, respectively, of the TABLE
* that is referenced. <p> * that is referenced.
* *
* <li> Referenced tables are reported only if the user or one of its roles is * <li> Referenced tables are reported only if the user or one of its roles is
* the authorization (owner) of the TRIGGER. * the authorization (owner) of the TRIGGER.
* *
* </ol> * </ol>
* *
* @return Table * @return Table
*/ */
Table TRIGGER_PERIOD_USAGE(Session session, PersistentStore store) { Table TRIGGER_PERIOD_USAGE(Session session, PersistentStore store) {
skipping to change at line 7968 skipping to change at line 7968
// Initialization // Initialization
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The TRIGGER_ROUTINE_USAGE view has one row for each routine * The TRIGGER_ROUTINE_USAGE view has one row for each routine
* referenced in the body of a trigger.<p> * referenced in the body of a trigger.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* SPECIFIC_CATALOG VARCHAR , * SPECIFIC_CATALOG VARCHAR ,
* SPECIFIC_SCHEMA VARCHAR , * SPECIFIC_SCHEMA VARCHAR ,
* SPECIFIC_NAME VARCHAR , * SPECIFIC_NAME VARCHAR ,
* *
* </pre> * </pre>
* *
* <b>Description:</b> * <b>Description:</b>
* *
* <ol> * <ol>
* <li> The values of TRIGGER_CATALOG, TRIGGER_SCHEMA and TRIGGER_NAME * <li> The values of TRIGGER_CATALOG, TRIGGER_SCHEMA and TRIGGER_NAME
* are the catalog name, schema name and * are the catalog name, schema name and
* identifier, respectively, of the TRIGGER. * identifier, respectively, of the TRIGGER.
* <li> The values of SPECIFIC_CATALOG, SPECIFIC_SCHEMA and * <li> The values of SPECIFIC_CATALOG, SPECIFIC_SCHEMA and
* SPECIFIC_NAME are the catalog name, schema name, * SPECIFIC_NAME are the catalog name, schema name,
* specific routine identifier, respectively, of the routine * specific routine identifier, respectively, of the routine
* that is referenced. <p> * that is referenced.
* *
* <li> Referenced routines are reported only if the user or one of its role s is * <li> Referenced routines are reported only if the user or one of its role s is
* the authorization (owner) of the TRIGGER. * the authorization (owner) of the TRIGGER.
* *
* </ol> * </ol>
* *
* @return Table * @return Table
*/ */
Table TRIGGER_ROUTINE_USAGE(Session session, PersistentStore store) { Table TRIGGER_ROUTINE_USAGE(Session session, PersistentStore store) {
skipping to change at line 8078 skipping to change at line 8078
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The TRIGGER_SEQUENCE_USAGE view has one row for each SEQUENCE * The TRIGGER_SEQUENCE_USAGE view has one row for each SEQUENCE
* referenced in the body of a trigger.<p> * referenced in the body of a trigger.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* SEQUENCE_CATALOG VARCHAR , * SEQUENCE_CATALOG VARCHAR ,
* SEQUENCE_SCHEMA VARCHAR , * SEQUENCE_SCHEMA VARCHAR ,
* SEQUENCE_NAME VARCHAR , * SEQUENCE_NAME VARCHAR ,
* *
* </pre> * </pre>
skipping to change at line 8189 skipping to change at line 8189
// Initialization // Initialization
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The TRIGGER_TABLE_USAGE view has one row for each TABLE * The TRIGGER_TABLE_USAGE view has one row for each TABLE
* referenced in the body of a trigger.<p> * referenced in the body of a trigger.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* TABLE_CATALOG VARCHAR , * TABLE_CATALOG VARCHAR ,
* TABLE_SCHEMA VARCHAR , * TABLE_SCHEMA VARCHAR ,
* TABLE_NAME VARCHAR , * TABLE_NAME VARCHAR ,
* *
* </pre> * </pre>
skipping to change at line 8300 skipping to change at line 8300
// Initialization // Initialization
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The TRIGGERS view has one row for each TRIGGER.<p> * The TRIGGERS view has one row for each TRIGGER.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* EVENT_MANIPULATION VARCHAR , * EVENT_MANIPULATION VARCHAR ,
* EVENT_OBJECT_CATALOG VARCHAR , * EVENT_OBJECT_CATALOG VARCHAR ,
* EVENT_OBJECT_SCHEMA VARCHAR , * EVENT_OBJECT_SCHEMA VARCHAR ,
* EVENT_OBJECT_TABLE VARCHAR , * EVENT_OBJECT_TABLE VARCHAR ,
* ACTION_ORDER VARCHAR , * ACTION_ORDER VARCHAR ,
skipping to change at line 8476 skipping to change at line 8476
// Initialization // Initialization
return t; return t;
} }
/** /**
* SQL:2008 VIEW<p> * SQL:2008 VIEW<p>
* *
* The TRIGGERED_UPDATE_COLUMNS view has one row for each column * The TRIGGERED_UPDATE_COLUMNS view has one row for each column
* referenced in the optional column list of a UPDATE trigger.<p> * referenced in the optional column list of a UPDATE trigger.<p>
* *
* <b>Definition:</b><p> * <b>Definition:</b>
* *
* <pre> * <pre>
* TRIGGER_CATALOG VARCHAR , * TRIGGER_CATALOG VARCHAR ,
* TRIGGER_SCHEMA VARCHAR , * TRIGGER_SCHEMA VARCHAR ,
* TRIGGER_NAME VARCHAR , * TRIGGER_NAME VARCHAR ,
* EVENT_OBJECT_CATALOG VARCHAR , * EVENT_OBJECT_CATALOG VARCHAR ,
* EVENT_OBJECT_SCHEMA VARCHAR , * EVENT_OBJECT_SCHEMA VARCHAR ,
* EVENT_OBJECT_NAME VARCHAR , * EVENT_OBJECT_NAME VARCHAR ,
* *
* </pre> * </pre>
skipping to change at line 8724 skipping to change at line 8724
* GRANTEE VARCHAR NOT NULL, * GRANTEE VARCHAR NOT NULL,
* OBJECT_CATALOG VARCHAR NULL, * OBJECT_CATALOG VARCHAR NULL,
* OBJECT_SCHEMA VARCHAR NULL, * OBJECT_SCHEMA VARCHAR NULL,
* OBJECT_NAME VARCHAR NOT NULL, * OBJECT_NAME VARCHAR NOT NULL,
* OBJECT_TYPE VARCHAR NOT NULL * OBJECT_TYPE VARCHAR NOT NULL
* PRIVILEGE_TYPE VARCHAR NOT NULL * PRIVILEGE_TYPE VARCHAR NOT NULL
* IS_GRANTABLE VARCHAR NOT NULL * IS_GRANTABLE VARCHAR NOT NULL
* ) * )
* </pre> * </pre>
* *
* <b>Description:</b><p> * <b>Description:</b>
* *
* <ol> * <ol>
* <li> The value of GRANTOR is the &lt;authorization identifier&gt; of the * <li> The value of GRANTOR is the &lt;authorization identifier&gt; of the
* user or role who granted usage privileges on the object of the type * user or role who granted usage privileges on the object of the type
* identified by OBJECT_TYPE that is identified by OBJECT_CATALOG, * identified by OBJECT_TYPE that is identified by OBJECT_CATALOG,
* OBJECT_SCHEMA, and OBJECT_NAME, to the user or role identified by th e * OBJECT_SCHEMA, and OBJECT_NAME, to the user or role identified by th e
* value of GRANTEE for the usage privilege being described. * value of GRANTEE for the usage privilege being described.
* *
* <li> The value of GRANTEE is the &lt;authorization identifier&gt; of some * <li> The value of GRANTEE is the &lt;authorization identifier&gt; of some
* user or role, or PUBLIC to indicate all users, to whom the usage * user or role, or PUBLIC to indicate all users, to whom the usage
skipping to change at line 9726 skipping to change at line 9726
t.insertSys(session, store, row); t.insertSys(session, store, row);
} }
return t; return t;
} }
//------------------------------------------------------------------------------ //------------------------------------------------------------------------------
// SQL SCHEMATA BASE TABLES // SQL SCHEMATA BASE TABLES
/** /**
* SQL:2008 VIEW<p>
*
* ROLE_AUTHORIZATION_DESCRIPTORS<p> * ROLE_AUTHORIZATION_DESCRIPTORS<p>
* *
* Contains a representation of the role authorization descriptors.<p> * Contains a representation of all role authorization descriptors.<p>
* <b>Definition</b> * <b>Definition</b>
* *
* <pre class="SqlCodeExample"> * <pre class="SqlCodeExample">
* ROLE_NAME VARCHAR name of view's defining catalog. * ROLE_NAME VARCHAR name of role.
* GRANTEE VARCHAR name of view's defining schema. * GRANTEE VARCHAR name of grantee.
* GRANTOR VARCHAR the simple name of the view. * GRANTOR VARCHAR name of grantor.
* IS_GRANTABLE VARCHAR the character representation of the * IS_GRANTABLE VARCHAR YES or NO
* </pre> * </pre>
* *
* <b>Description</b> * <b>Description</b>
* *
* <ol> * <ol>
* <li>The value of ROLE_NAME is the &lt;role name&gt; of some * <li>The value of ROLE_NAME is the &lt;role name&gt; of some
* &lt;role granted&gt; by the &lt;grant role statement&gt; or * &lt;role granted&gt; by the &lt;grant role statement&gt; or
* the &lt;role name&gt; of a &lt;role definition&gt;. * the &lt;role name&gt; of a &lt;role definition&gt;.
* *
* <li>The value of GRANTEE is an &lt;authorization identifier&gt;, * <li>The value of GRANTEE is an &lt;authorization identifier&gt;,
skipping to change at line 9814 skipping to change at line 9812
final int grantor = 2; final int grantor = 2;
final int is_grantable = 3; final int is_grantable = 3;
// Initialization // Initialization
grantees = session.getGrantee().visibleGrantees().iterator(); grantees = session.getGrantee().visibleGrantees().iterator();
// //
while (grantees.hasNext()) { while (grantees.hasNext()) {
granteeObject = (Grantee) grantees.next(); granteeObject = (Grantee) grantees.next();
granteeName = granteeObject.getName().getNameString(); granteeName = granteeObject.getName().getNameString();
roles = granteeObject.getDirectRoles().iterator(); roles = granteeObject.getDirectRolesWithPublic().iterator();
isGrantable = granteeObject.isAdmin() ? Tokens.T_YES isGrantable = granteeObject.isAdmin() ? Tokens.T_YES
: Tokens.T_NO; : Tokens.T_NO;
while (roles.hasNext()) { while (roles.hasNext()) {
Grantee role = (Grantee) roles.next(); Grantee role = (Grantee) roles.next();
row = t.getEmptyRowData(); row = t.getEmptyRowData();
row[role_name] = role.getName().getNameString(); row[role_name] = role.getName().getNameString();
row[grantee] = granteeName; row[grantee] = granteeName;
row[grantor] = grantorName; row[grantor] = grantorName;
 End of changes. 29 change blocks. 
33 lines changed or deleted 31 lines changed or added
To the Java Programs section of the hsqldb source changes report or the top of this page
Mainly generated by pkgdiff using rfcdiff
Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)