[teiid-commits] teiid SVN: r2566 - in branches/7.1.x: common-core/src/main/java/org/teiid/core and 16 other directories.

Author: shawkins Date: 2010-09-13 22:18:40 -0400 (Mon, 13 Sep 2010) New Revision: 2566 Added: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testVDBResources.expected Modified: branches/7.1.x/client/src/test/java/org/teiid/jdbc/util/ResultSetUtil.java branches/7.1.x/common-core/src/main/java/org/teiid/core/CoreConstants.java branches/7.1.x/documentation/admin-guide/src/main/docbook/en-US/content/adminshell.xml branches/7.1.x/documentation/caching-guide/src/main/docbook/en-US/content/matviews.xml branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/dataroles.xml branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/system_schema.xml branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/AuthorizationValidationVisitor.java branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/DataTierManagerImpl.java branches/7.1.x/engine/src/main/java/org/teiid/query/metadata/TransformationMetadata.java branches/7.1.x/engine/src/main/java/org/teiid/query/optimizer/relational/PlanToProcessConverter.java branches/7.1.x/engine/src/main/java/org/teiid/query/tempdata/TempTableDataManager.java branches/7.1.x/metadata/src/main/java/org/teiid/metadata/index/IndexMetadataFactory.java branches/7.1.x/metadata/src/main/resources/System.vdb branches/7.1.x/test-integration/common/src/test/java/org/teiid/jdbc/TestMMDatabaseMetaData.java branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestMatViews.java branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestSystemVirtualModel.java branches/7.1.x/test-integration/common/src/test/resources/TestCase3473/testGetTables.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetColumns.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedures.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProceduresWithEscape.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetSchemas.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_allTables.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableMultipleTypes.expected branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableTypes.expected branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_CLASS.expected branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_INDEX.expected branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_NAMESPACE.expected branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_PROC.expected branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_TYPE.expected branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testColumns.expected branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedures.expected branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testSchemas.expected branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testTables.expected branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testColumns.expected branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedures.expected branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testSchemas.expected branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTableIsSystem.expected branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTables.expected Log: TEIID-1246 initial checkin of refining sysadmin/metadata logic. Modified: branches/7.1.x/client/src/test/java/org/teiid/jdbc/util/ResultSetUtil.java =================================================================== --- branches/7.1.x/client/src/test/java/org/teiid/jdbc/util/ResultSetUtil.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/client/src/test/java/org/teiid/jdbc/util/ResultSetUtil.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -32,9 +32,12 @@ import java.io.PrintStream; import java.io.StringWriter; import java.lang.reflect.Method; +import java.sql.Blob; +import java.sql.Clob; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; +import java.sql.SQLXML; import java.util.ArrayList; import java.util.Collections; import java.util.List; @@ -279,12 +282,19 @@ int totalRows = 0; while (rs.next()) { for (int j = 1; j <= count; j++) { + Object obj = rs.getObject(j); + if (obj instanceof SQLXML) { + obj = ((SQLXML)obj).getString(); + } else if (obj instanceof Clob) { + obj = "Clob[" + ((Clob)obj).length() + "]"; //$NON-NLS-1$ //$NON-NLS-2$ + } else if (obj instanceof Blob) { + obj = "Blob[" + ((Blob)obj).length() + "]"; //$NON-NLS-1$ //$NON-NLS-2$ + } if (maxColWidth == 0) { - Object obj = rs.getObject(j); - out.print(obj == null ? NULL : obj); //$NON-NLS-1$ + out.print(obj == null ? NULL : obj); if (j != count) out.print(SPACER); } else { - String resizedString = resizeString(rs.getObject(j), sizes[j-1]); + String resizedString = resizeString(obj, sizes[j-1]); out.print(resizedString); if (j != count && resizedString.length() <= sizes[j-1]) { out.print(SPACER); @@ -346,7 +356,7 @@ try { Method m = RSMD.getMethod(METADATA_METHODS[i], params); Object obj = m.invoke(rsmd, columnParam); - String stringVal = (obj == null) ? NULL : obj.toString(); //$NON-NLS-1$ + String stringVal = (obj == null) ? NULL : obj.toString(); metadataStrings[col - 1][i] = stringVal; if (maxColWidths[i] < stringVal.length()) { maxColWidths[i] = stringVal.length(); @@ -378,7 +388,7 @@ private static String resizeString(Object obj, int size) { if (obj == null) { - return resizeString(NULL, size); //$NON-NLS-1$ + return resizeString(NULL, size); } String str = obj.toString(); if (str.length() == size) { Modified: branches/7.1.x/common-core/src/main/java/org/teiid/core/CoreConstants.java =================================================================== --- branches/7.1.x/common-core/src/main/java/org/teiid/core/CoreConstants.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/common-core/src/main/java/org/teiid/core/CoreConstants.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -52,6 +52,8 @@ public static final String SYSTEM_MODEL = "SYS"; //$NON-NLS-1$ + public static final String SYSTEM_ADMIN_MODEL = "SYSADMIN"; //$NON-NLS-1$ + public static final String ODBC_MODEL = "pg_catalog"; //$NON-NLS-1$ public static final String SYSTEM_VDB = "System.vdb"; //$NON-NLS-1$ Modified: branches/7.1.x/documentation/admin-guide/src/main/docbook/en-US/content/adminshell.xml =================================================================== --- branches/7.1.x/documentation/admin-guide/src/main/docbook/en-US/content/adminshell.xml 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/documentation/admin-guide/src/main/docbook/en-US/content/adminshell.xml 2010-09-14 02:18:40 UTC (rev 2566) @@ -274,5 +274,21 @@ // close the connection in the "conn1" disconnectAll();]]></programlisting> </section> - + <section> + <title>Interactive Shell Nuances</title> + <para>The interactive shell uses a special shell interpretter and therefore has different behavior than just writting a script in Groovy. + See the <ulink url="http://groovy.codehaus.org/Groovy+Shell">Groovy Shell Documentation</ulink> for more on its usage. Notable differences: + <itemizedlist> + <listitem> + <para>Def statements do not define a variable in the context of the Shell, e.g. do not use <code>def x = 1</code>, use <code>x = 1</code></para> + </listitem> + <listitem> + <para>Shell commands (as seen through <code>help</code>) using the non-functional shell syntax are only available in the shell.</para> + </listitem> + <listitem> + <para>Groovy classes using annotations cannot be parsed in the Shell.</para> + </listitem> + </itemizedlist> + </para> + </section> </chapter> \ No newline at end of file Modified: branches/7.1.x/documentation/caching-guide/src/main/docbook/en-US/content/matviews.xml =================================================================== --- branches/7.1.x/documentation/caching-guide/src/main/docbook/en-US/content/matviews.xml 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/documentation/caching-guide/src/main/docbook/en-US/content/matviews.xml 2010-09-14 02:18:40 UTC (rev 2566) @@ -108,22 +108,22 @@ <title>Loading And Refreshing</title> <para>An internal materialized view table is initially in an invalid state (there is no data). The first user query will trigger an implicit loading of the data. All other queries against the materialized view will block until the load completes. - In some situations administrators may wish to better control when the cache is loaded with a call to <code>SYS.refreshMatView</code>. The initial load may itself trigger the initial load + In some situations administrators may wish to better control when the cache is loaded with a call to <code>SYSADMIN.refreshMatView</code>. The initial load may itself trigger the initial load of dependent materialized views. After the initial load user queries against the materialized view table will only block if it is in an invalid state. - The valid state may also be controled through the <code>SYS.refreshMatView</code> procedure. + The valid state may also be controled through the <code>SYSADMIN.refreshMatView</code> procedure. <example> <title>Invalidating Refresh</title> - <programlisting>CALL SYS.refreshMatView(viewname=>'schema.matview', invalidate=>true)</programlisting> + <programlisting>CALL SYSADMIN.refreshMatView(viewname=>'schema.matview', invalidate=>true)</programlisting> <para>matview will be refreshed and user queries will block until the refresh is complete (or fails).</para> </example> While the initial load may trigger a transitive loading of dependent materialized views, subsequent refreshes performed with <code>refreshMatView</code> will use dependent materialized view tables if they exist. Only one load may occur at a time. If a load is already in progress when - the <code>SYS.refreshMatView</code> procedure is called, it will return -1 immediately rather than preempting the current load. + the <code>SYSADMIN.refreshMatView</code> procedure is called, it will return -1 immediately rather than preempting the current load. </para> <section> <title>TTL Snapshot Refresh</title> <para>The <link linkend="cache-hint">cache hint</link> may be used to automatically trigger a full snapshot refresh after a specified time to live. - The refresh is equivalent to <code>CALL SYS.refreshMatView('view name', false)</code>, but performed asynchronously so that user queries do not block on the load.</para> + The refresh is equivalent to <code>CALL SYSADMIN.refreshMatView('view name', false)</code>, but performed asynchronously so that user queries do not block on the load.</para> <example> <title>Auto-refresh Transformation Query</title> <programlisting>/*+ cache(ttl:3600000) */ select t.col, t1.col from t, t1 where t.id = t1.id</programlisting> @@ -143,13 +143,13 @@ <section> <title>Updatable</title> <para>In advanced use-cases the <link linkend="cache-hint">cache hint</link> may also be used to mark an internal materialized view as updatable. - An updatable internal materialized view may use the <code>SYS.refreshMatViewRow</code> procedure to update a single row in the materialized table. + An updatable internal materialized view may use the <code>SYSADMIN.refreshMatViewRow</code> procedure to update a single row in the materialized table. If the source row exists, the materialized view table row will be updated. If the source row does not exist, the correpsonding materialized row will be deleted. - To be updatable the materialized view must have a single column primary key. Composite keys are not yet supported by <code>SYS.refreshMatViewRow</code>. + To be updatable the materialized view must have a single column primary key. Composite keys are not yet supported by <code>SYSADMIN.refreshMatViewRow</code>. <example> <title>Updatable Transformation Query</title> <para>Transofrmation Query: <programlisting>/*+ cache(updatable) */ select t.col, t1.col from t, t1 where t.id = t1.id</programlisting></para> - <para>Update SQL: <programlisting>CALL SYS.updateMatViewRow(viewname=>'schema.matview', key=>5)</programlisting></para> + <para>Update SQL: <programlisting>CALL SYSADMIN.updateMatViewRow(viewname=>'schema.matview', key=>5)</programlisting></para> <para>Given that the schema.matview defines an interger column col as it's primary key, the update will check the live source(s) for the row values.</para> </example> The update query will not use dependent materialized view tables, so care should be taken to ensure that getting a single Modified: branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/dataroles.xml =================================================================== --- branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/dataroles.xml 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/dataroles.xml 2010-09-14 02:18:40 UTC (rev 2566) @@ -43,6 +43,9 @@ <warning><para>Unlike previous versions of Teiid, non-visible models are accessible by user queries. To restrict user access at a model level, at least one data role should be created to enable data role checking. In turn that role can be mapped to any authenticated user and should not grant permissions to models that should be inaccessable.</para></warning> + + <para>Permissions are not applicable to the SYS and pg_catalog schemas. These metadata reporting schemas are always accessible regardless of the user. + The SYSADMIN schema however may need permissions as applicable.</para> <orderedlist> <para>To process a <emphasis>SELECT</emphasis> statement or a stored procedure execution, the user account requires the following access rights:</para> Modified: branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/system_schema.xml =================================================================== --- branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/system_schema.xml 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/documentation/reference/src/main/docbook/en-US/content/system_schema.xml 2010-09-14 02:18:40 UTC (rev 2566) @@ -2,11 +2,57 @@ <!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.5//EN" "http://www.oasis-open.org/docbook/xml/4.5/docbookx.dtd"> <chapter id="system_schema"> <title>System Schema</title> + <para>The built-in SYS and SYSADMIN schemas provide metadata tables and procedures against the current VDB.</para> <section id="system_tables"> <title>System Tables</title> <section> <title>VDB, Schema, and Properties</title> <section> + <title>SYSADMIN.VDBResources</title> + <para>This table provides the current VDB contents.</para> + <informaltable frame="all"> + <tgroup cols="3"> + <thead> + <row> + <entry> + <para>Column Name</para> + </entry> + <entry> + <para>Type</para> + </entry> + <entry> + <para>Description</para> + </entry> + </row> + </thead> + <tbody> + <row> + <entry> + <para>resourcePath</para> + </entry> + <entry> + <para>string</para> + </entry> + <entry> + <para>The path to the contents.</para> + </entry> + </row> + <row> + <entry> + <para>contents</para> + </entry> + <entry> + <para>blob</para> + </entry> + <entry> + <para>The contents as a blob.</para> + </entry> + </row> + </tbody> + </tgroup> + </informaltable> + </section> + <section> <title>SYS.VirtualDatabases</title> <para>This table supplies information about the currently connected @@ -393,7 +439,7 @@ </informaltable> </section> <section> - <title>SYS.MatViews</title> + <title>SYSADMIN.MatViews</title> <para>This table supplies information about all the materailized views in the virtual database.</para> <informaltable frame="all"> <tgroup cols="3"> @@ -1726,42 +1772,9 @@ <tbody> <row> <entry> - <para>getCharacterVDBResource</para> + <para>SYS.getXMLSchemas</para> </entry> <entry> - <para>(string resourcePath)</para> - </entry> - <entry> - <para>A single column containing the resource as a clob.</para> - </entry> - </row> - <row> - <entry> - <para>getBinaryVDBResource</para> - </entry> - <entry> - <para>(sting resourcePath)</para> - </entry> - <entry> - <para>A single column containing the resource as a blob.</para> - </entry> - </row> - <row> - <entry> - <para>getVDBResourcePaths</para> - </entry> - <entry> - <para>()</para> - </entry> - <entry> - <para>A single column containing the resource paths as strings.</para> - </entry> - </row> - <row> - <entry> - <para>getXMLSchemas</para> - </entry> - <entry> <para>(string document)</para> </entry> <entry> @@ -1770,7 +1783,7 @@ </row> <row> <entry> - <para>refreshMatView</para> + <para>SYSADMIN.refreshMatView</para> </entry> <entry> <para>(string ViewName, boolean Invalidate)</para> @@ -1781,7 +1794,7 @@ </row> <row> <entry> - <para>refreshMatViewRow</para> + <para>SYSADMIN.refreshMatViewRow</para> </entry> <entry> <para>(string ViewName, object Key)</para> Modified: branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/AuthorizationValidationVisitor.java =================================================================== --- branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/AuthorizationValidationVisitor.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/AuthorizationValidationVisitor.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -36,6 +36,7 @@ import org.teiid.adminapi.DataPolicy; import org.teiid.adminapi.impl.DataPolicyMetadata; import org.teiid.api.exception.query.QueryMetadataException; +import org.teiid.core.CoreConstants; import org.teiid.core.TeiidComponentException; import org.teiid.core.TeiidProcessingException; import org.teiid.dqp.internal.process.multisource.MultiSourceElement; @@ -241,6 +242,11 @@ } } fullName = getMetadata().getFullName(metadataID); + Object modelId = getMetadata().getModelID(metadataID); + String modelName = getMetadata().getFullName(modelId); + if (CoreConstants.SYSTEM_MODEL.equals(modelName) || CoreConstants.ODBC_MODEL.equals(modelName)) { + continue; + } nameToSymbolMap.put(fullName, symbol); } catch(QueryMetadataException e) { handleException(e); @@ -261,7 +267,7 @@ // is not authorized in the exception message handleValidationError( - QueryPlugin.Util.getString("ERR.018.005.0095", new Object[]{DQPWorkContext.getWorkContext().getSessionId(), getActionLabel(actionCode)}), //$NON-NLS-1$ + QueryPlugin.Util.getString("ERR.018.005.0095", userName, getActionLabel(actionCode)), //$NON-NLS-1$ inaccessibleSymbols); } } Modified: branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/DataTierManagerImpl.java =================================================================== --- branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/DataTierManagerImpl.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/engine/src/main/java/org/teiid/dqp/internal/process/DataTierManagerImpl.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -43,13 +43,11 @@ import org.teiid.core.CoreConstants; import org.teiid.core.TeiidComponentException; import org.teiid.core.TeiidProcessingException; -import org.teiid.core.types.BlobImpl; import org.teiid.core.types.BlobType; -import org.teiid.core.types.ClobImpl; -import org.teiid.core.types.ClobType; import org.teiid.core.types.SQLXMLImpl; import org.teiid.core.types.XMLType; import org.teiid.core.util.Assertion; +import org.teiid.core.util.StringUtil; import org.teiid.dqp.internal.datamgr.ConnectorManager; import org.teiid.dqp.internal.datamgr.ConnectorManagerRepository; import org.teiid.dqp.internal.datamgr.ConnectorWork; @@ -99,14 +97,15 @@ KEYCOLUMNS, PROCEDUREPARAMS, REFERENCEKEYCOLUMNS, - PROPERTIES, - MATVIEWS + PROPERTIES } + private enum SystemAdminTables { + MATVIEWS, + VDBRESOURCES + } + private enum SystemProcs { - GETCHARACTERVDBRESOURCE, - GETBINARYVDBRESOURCE, - GETVDBRESOURCEPATHS, GETXMLSCHEMAS } @@ -122,7 +121,7 @@ public TupleSource registerRequest(CommandContext context, Command command, String modelName, String connectorBindingId, int nodeID) throws TeiidComponentException, TeiidProcessingException { RequestWorkItem workItem = requestMgr.getRequestWorkItem((RequestID)context.getProcessorID()); - if(CoreConstants.SYSTEM_MODEL.equals(modelName)) { + if(CoreConstants.SYSTEM_MODEL.equals(modelName) || CoreConstants.SYSTEM_ADMIN_MODEL.equals(modelName)) { return processSystemQuery(context, command, workItem.getDqpWorkContext()); } @@ -147,12 +146,58 @@ int vdbVersion = workContext.getVdbVersion(); VDBMetaData vdb = workContext.getVDB(); CompositeMetadataStore metadata = vdb.getAttachment(TransformationMetadata.class).getMetadataStore(); + TransformationMetadata indexMetadata = vdb.getAttachment(TransformationMetadata.class); Collection rows = new ArrayList(); int oid = 0; if (command instanceof Query) { Query query = (Query)command; UnaryFromClause ufc = (UnaryFromClause)query.getFrom().getClauses().get(0); GroupSymbol group = ufc.getGroup(); + if (StringUtil.startsWithIgnoreCase(group.getNonCorrelationName(), (CoreConstants.SYSTEM_ADMIN_MODEL))) { + final SystemAdminTables sysTable = SystemAdminTables.valueOf(group.getNonCorrelationName().substring(CoreConstants.SYSTEM_ADMIN_MODEL.length() + 1).toUpperCase()); + switch (sysTable) { + case MATVIEWS: + for (Schema schema : getVisibleSchemas(vdb, metadata)) { + for (Table table : schema.getTables().values()) { + if (!table.isMaterialized()) { + continue; + } + String targetSchema = null; + String matTableName = null; + String state = null; + Timestamp updated = null; + Integer cardinaltity = null; + Boolean valid = null; + if (table.getMaterializedTable() == null) { + TempTableStore globalStore = context.getGlobalTableStore(); + matTableName = RelationalPlanner.MAT_PREFIX+table.getFullName().toUpperCase(); + MatTableInfo info = globalStore.getMatTableInfo(matTableName); + valid = info.isValid(); + state = info.getState().name(); + updated = info.getUpdateTime()==-1?null:new Timestamp(info.getUpdateTime()); + TempMetadataID id = globalStore.getMetadataStore().getTempGroupID(matTableName); + if (id != null) { + cardinaltity = id.getCardinality(); + } + //ttl, pref_mem - not part of proper metadata + } else { + Table t = table.getMaterializedTable(); + matTableName = t.getName(); + targetSchema = t.getParent().getName(); + } + rows.add(Arrays.asList(vdbName, schema.getName(), table.getName(), targetSchema, matTableName, valid, state, updated, cardinaltity)); + } + } + break; + case VDBRESOURCES: + String[] filePaths = indexMetadata.getVDBResourcePaths(); + for (String filePath : filePaths) { + rows.add(Arrays.asList(filePath, new BlobType(indexMetadata.getVDBResourceAsBlob(filePath)))); + } + break; + } + return new CollectionTupleSource(rows.iterator()); + } final SystemTables sysTable = SystemTables.valueOf(group.getNonCorrelationName().substring(CoreConstants.SYSTEM_MODEL.length() + 1).toUpperCase()); switch (sysTable) { case DATATYPES: @@ -263,65 +308,15 @@ } } break; - case MATVIEWS: - if (!table.isMaterialized()) { - continue; - } - String targetSchema = null; - String matTableName = null; - String state = null; - Timestamp updated = null; - Integer cardinaltity = null; - Boolean valid = null; - if (table.getMaterializedTable() == null) { - TempTableStore globalStore = context.getGlobalTableStore(); - matTableName = RelationalPlanner.MAT_PREFIX+table.getFullName().toUpperCase(); - MatTableInfo info = globalStore.getMatTableInfo(matTableName); - valid = info.isValid(); - state = info.getState().name(); - updated = info.getUpdateTime()==-1?null:new Timestamp(info.getUpdateTime()); - TempMetadataID id = globalStore.getMetadataStore().getTempGroupID(matTableName); - if (id != null) { - cardinaltity = id.getCardinality(); - } - //ttl, pref_mem - not part of proper metadata - } else { - Table t = table.getMaterializedTable(); - matTableName = t.getName(); - targetSchema = t.getParent().getName(); - } - rows.add(Arrays.asList(vdbName, schema.getName(), table.getName(), targetSchema, matTableName, valid, state, updated, cardinaltity)); - break; } } } break; } } else { - TransformationMetadata indexMetadata = vdb.getAttachment(TransformationMetadata.class); StoredProcedure proc = (StoredProcedure)command; final SystemProcs sysTable = SystemProcs.valueOf(proc.getProcedureCallableName().substring(CoreConstants.SYSTEM_MODEL.length() + 1).toUpperCase()); switch (sysTable) { - case GETVDBRESOURCEPATHS: - String[] filePaths = indexMetadata.getVDBResourcePaths(); - for (String filePath : filePaths) { - rows.add(Arrays.asList(filePath, filePath.endsWith(".INDEX"))); //$NON-NLS-1$ - } - break; - case GETBINARYVDBRESOURCE: - String filePath = (String)((Constant)proc.getParameter(1).getExpression()).getValue(); - BlobImpl contents = indexMetadata.getVDBResourceAsBlob(filePath); - if (contents != null) { - rows.add(Arrays.asList(new BlobType(contents))); - } - break; - case GETCHARACTERVDBRESOURCE: - filePath = (String)((Constant)proc.getParameter(1).getExpression()).getValue(); - ClobImpl filecontents = indexMetadata.getVDBResourceAsClob(filePath); - if (filecontents != null) { - rows.add(Arrays.asList(new ClobType(filecontents))); - } - break; case GETXMLSCHEMAS: try { Object groupID = indexMetadata.getGroupID((String)((Constant)proc.getParameter(1).getExpression()).getValue()); Modified: branches/7.1.x/engine/src/main/java/org/teiid/query/metadata/TransformationMetadata.java =================================================================== --- branches/7.1.x/engine/src/main/java/org/teiid/query/metadata/TransformationMetadata.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/engine/src/main/java/org/teiid/query/metadata/TransformationMetadata.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -948,7 +948,7 @@ return null; } Resource r = this.vdbEntries.get(resourcePath); - if (r != null && r.visible) { + if (r != null) { return r.file; } return null; @@ -981,10 +981,8 @@ public String[] getVDBResourcePaths() throws TeiidComponentException, QueryMetadataException { LinkedList<String> paths = new LinkedList<String>(); for (Map.Entry<String, Resource> entry : this.vdbEntries.entrySet()) { - if (entry.getValue().visible) { - paths.add(entry.getKey()); - } - } + paths.add(entry.getKey()); + } return paths.toArray(new String[paths.size()]); } Modified: branches/7.1.x/engine/src/main/java/org/teiid/query/optimizer/relational/PlanToProcessConverter.java =================================================================== --- branches/7.1.x/engine/src/main/java/org/teiid/query/optimizer/relational/PlanToProcessConverter.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/engine/src/main/java/org/teiid/query/optimizer/relational/PlanToProcessConverter.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -471,7 +471,8 @@ return aNode; } GroupSymbol group = node.getGroups().iterator().next(); - if (!CoreConstants.SYSTEM_MODEL.equals(metadata.getFullName(metadata.getModelID(group.getMetadataID())))) { + if (!CoreConstants.SYSTEM_MODEL.equals(metadata.getFullName(metadata.getModelID(group.getMetadataID()))) + && !CoreConstants.SYSTEM_ADMIN_MODEL.equals(metadata.getFullName(metadata.getModelID(group.getMetadataID())))) { return aNode; } List projectSymbols = (List) node.getProperty(NodeConstants.Info.OUTPUT_COLS); Modified: branches/7.1.x/engine/src/main/java/org/teiid/query/tempdata/TempTableDataManager.java =================================================================== --- branches/7.1.x/engine/src/main/java/org/teiid/query/tempdata/TempTableDataManager.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/engine/src/main/java/org/teiid/query/tempdata/TempTableDataManager.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -139,7 +139,7 @@ if (command instanceof ProcedureContainer) { if (command instanceof StoredProcedure) { StoredProcedure proc = (StoredProcedure)command; - if (CoreConstants.SYSTEM_MODEL.equals(modelName)) { + if (CoreConstants.SYSTEM_ADMIN_MODEL.equals(modelName)) { TupleSource result = handleSystemProcedures(context, proc); if (result != null) { return result; Modified: branches/7.1.x/metadata/src/main/java/org/teiid/metadata/index/IndexMetadataFactory.java =================================================================== --- branches/7.1.x/metadata/src/main/java/org/teiid/metadata/index/IndexMetadataFactory.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/metadata/src/main/java/org/teiid/metadata/index/IndexMetadataFactory.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -43,7 +43,6 @@ import org.teiid.adminapi.impl.ModelMetaData; import org.teiid.adminapi.impl.VDBMetaData; import org.teiid.api.exception.query.QueryMetadataException; -import org.teiid.core.CoreConstants; import org.teiid.core.TeiidException; import org.teiid.core.TeiidRuntimeException; import org.teiid.core.id.UUID; @@ -210,21 +209,11 @@ this.vdbEntries = visibilityMap; } - private final static boolean isSystemModelWithSystemTableType(String modelName) { - return CoreConstants.SYSTEM_MODEL.equalsIgnoreCase(modelName); - } - private boolean isFileVisible(String pathInVDB, VDBMetaData vdb) { if (pathInVDB.endsWith(".xmi")) { //$NON-NLS-1$ String modelName = StringUtil.getFirstToken(StringUtil.getLastToken(pathInVDB, "/"), "."); //$NON-NLS-1$ //$NON-NLS-2$ - // If this is any of the Public System Models, like JDBC,ODBC system - // models - if (isSystemModelWithSystemTableType(modelName)) { - return true; - } - ModelMetaData model = vdb.getModel(modelName); if (model != null) { return model.isVisible(); Modified: branches/7.1.x/metadata/src/main/resources/System.vdb =================================================================== (Binary files differ) Modified: branches/7.1.x/test-integration/common/src/test/java/org/teiid/jdbc/TestMMDatabaseMetaData.java =================================================================== --- branches/7.1.x/test-integration/common/src/test/java/org/teiid/jdbc/TestMMDatabaseMetaData.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/java/org/teiid/jdbc/TestMMDatabaseMetaData.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -480,7 +480,7 @@ while(rs.next()) { count++; } - assertEquals(12, count); + assertEquals(11, count); } finally { if(rs != null) { rs.close(); Modified: branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestMatViews.java =================================================================== --- branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestMatViews.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestMatViews.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -53,7 +53,7 @@ @Test public void testSystemMatViewsWithImplicitLoad() throws Exception { Statement s = conn.createStatement(); - ResultSet rs = s.executeQuery("select * from SYS.MatViews order by name"); + ResultSet rs = s.executeQuery("select * from MatViews order by name"); assertTrue(rs.next()); assertEquals("NEEDS_LOADING", rs.getString("loadstate")); assertEquals("#MAT_TEST.ERRORVIEW", rs.getString("targetName")); @@ -65,7 +65,7 @@ assertEquals("#MAT_TEST.RANDOMVIEW", rs.getString("targetName")); rs = s.executeQuery("select * from MatView"); assertTrue(rs.next()); - rs = s.executeQuery("select * from SYS.MatViews where name = 'MatView'"); + rs = s.executeQuery("select * from MatViews where name = 'MatView'"); assertTrue(rs.next()); assertEquals("LOADED", rs.getString("loadstate")); try { @@ -73,17 +73,17 @@ } catch (SQLException e) { } - rs = s.executeQuery("select * from SYS.MatViews where name = 'ErrorView'"); + rs = s.executeQuery("select * from MatViews where name = 'ErrorView'"); assertTrue(rs.next()); assertEquals("FAILED_LOAD", rs.getString("loadstate")); } @Test public void testSystemMatViewsWithExplicitRefresh() throws Exception { Statement s = conn.createStatement(); - ResultSet rs = s.executeQuery("select * from (call SYS.refreshMatView('TEST.MATVIEW', false)) p"); + ResultSet rs = s.executeQuery("select * from (call refreshMatView('TEST.MATVIEW', false)) p"); assertTrue(rs.next()); assertEquals(1, rs.getInt(1)); - rs = s.executeQuery("select * from SYS.MatViews where name = 'MatView'"); + rs = s.executeQuery("select * from MatViews where name = 'MatView'"); assertTrue(rs.next()); assertEquals("LOADED", rs.getString("loadstate")); assertEquals(true, rs.getBoolean("valid")); @@ -91,12 +91,12 @@ @Test(expected=TeiidSQLException.class) public void testSystemMatViewsInvalidView() throws Exception { Statement s = conn.createStatement(); - s.execute("call SYS.refreshMatView('TEST.NotMat', false)"); + s.execute("call refreshMatView('TEST.NotMat', false)"); } @Test(expected=TeiidSQLException.class) public void testSystemMatViewsInvalidView1() throws Exception { Statement s = conn.createStatement(); - s.execute("call SYS.refreshMatView('foo', false)"); + s.execute("call refreshMatView('foo', false)"); } @Test public void testSystemMatViewsWithRowRefresh() throws Exception { @@ -108,15 +108,15 @@ Statement s = conn.createStatement(); //prior to load refresh of a single row returns -1 - ResultSet rs = s.executeQuery("select * from (call SYS.refreshMatViewRow('TEST.RANDOMVIEW', 0)) p"); + ResultSet rs = s.executeQuery("select * from (call refreshMatViewRow('TEST.RANDOMVIEW', 0)) p"); assertTrue(rs.next()); assertEquals(-1, rs.getInt(1)); assertFalse(rs.next()); - rs = s.executeQuery("select * from (call SYS.refreshMatView('TEST.RANDOMVIEW', false)) p"); + rs = s.executeQuery("select * from (call refreshMatView('TEST.RANDOMVIEW', false)) p"); assertTrue(rs.next()); assertEquals(1, rs.getInt(1)); - rs = s.executeQuery("select * from SYS.MatViews where name = 'RandomView'"); + rs = s.executeQuery("select * from MatViews where name = 'RandomView'"); assertTrue(rs.next()); assertEquals("LOADED", rs.getString("loadstate")); assertEquals(true, rs.getBoolean("valid")); @@ -124,23 +124,23 @@ assertTrue(rs.next()); double key = rs.getDouble(1); - rs = s.executeQuery("select * from (call SYS.refreshMatViewRow('TEST.RANDOMVIEW', "+key+")) p"); + rs = s.executeQuery("select * from (call refreshMatViewRow('TEST.RANDOMVIEW', "+key+")) p"); assertTrue(rs.next()); assertEquals(1, rs.getInt(1)); //1 row updated (removed) rs = s.executeQuery("select * from TEST.RANDOMVIEW"); assertFalse(rs.next()); - rs = s.executeQuery("select * from (call SYS.refreshMatViewRow('TEST.RANDOMVIEW', "+key+")) p"); + rs = s.executeQuery("select * from (call refreshMatViewRow('TEST.RANDOMVIEW', "+key+")) p"); assertTrue(rs.next()); assertEquals(0, rs.getInt(1)); //no rows updated } @Test(expected=TeiidSQLException.class) public void testSystemMatViewsWithRowRefreshNoPk() throws Exception { Statement s = conn.createStatement(); - s.executeQuery("select * from (call SYS.refreshMatView('TEST.MATVIEW', false)) p"); + s.executeQuery("select * from (call refreshMatView('TEST.MATVIEW', false)) p"); //prior to load refresh of a single row returns -1 - s.executeQuery("select * from (call SYS.refreshMatViewRow('TEST.MATVIEW', 0)) p"); + s.executeQuery("select * from (call refreshMatViewRow('TEST.MATVIEW', 0)) p"); } } Modified: branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestSystemVirtualModel.java =================================================================== --- branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestSystemVirtualModel.java 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/java/org/teiid/systemmodel/TestSystemVirtualModel.java 2010-09-14 02:18:40 UTC (rev 2566) @@ -22,6 +22,9 @@ package org.teiid.systemmodel; +import java.io.IOException; +import java.sql.SQLException; + import org.junit.Before; import org.junit.Test; import static org.junit.Assert.*; @@ -97,15 +100,9 @@ checkResult("testKeyColumns", "select* from SYS.KeyColumns order by Name, KeyName"); //$NON-NLS-1$ //$NON-NLS-2$ } - @Test public void testVDBResourcePathsProcedure() { - - String[] expected = { "ResourcePath[string] isBinary[boolean]", - "/parts/partsmd/PartsSupplier.xmi false", - "/ConfigurationInfo.def false", - "/MetaMatrix-VdbManifestModel.xmi false", - }; - execute("exec getVDBResourcePaths()",new Object[] {}); //$NON-NLS-1$ - assertResults(expected); + @Test public void testVDBResources() throws IOException, SQLException { + execute("select * from vdbresources",new Object[] {}); //$NON-NLS-1$ + TestMMDatabaseMetaData.compareResultSet(this.internalResultSet); } @Test public void testColumns() throws Exception { Modified: branches/7.1.x/test-integration/common/src/test/resources/TestCase3473/testGetTables.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestCase3473/testGetTables.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestCase3473/testGetTables.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -4,7 +4,6 @@ test SYS DataTypes SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS KeyColumns SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS Keys SYSTEM TABLE <null> <null> <null> <null> <null> <null> true -test SYS MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS ProcedureParams SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS Procedures SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS Properties SYSTEM TABLE <null> <null> <null> <null> <null> <null> true @@ -12,6 +11,7 @@ test SYS Schemas SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS Tables SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test SYS VirtualDatabases SYSTEM TABLE <null> <null> <null> <null> <null> <null> true +test SYSADMIN MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true test pg_catalog pg_am SYSTEM TABLE <null> <null> <null> <null> <null> <null> false test pg_catalog pg_attrdef SYSTEM TABLE <null> <null> <null> <null> <null> <null> false test pg_catalog pg_attribute SYSTEM TABLE <null> <null> <null> <null> <null> <null> false @@ -23,10 +23,11 @@ test pg_catalog pg_trigger SYSTEM TABLE <null> <null> <null> <null> <null> <null> false test pg_catalog pg_type SYSTEM TABLE <null> <null> <null> <null> <null> <null> false test pg_catalog pg_user SYSTEM TABLE <null> <null> <null> <null> <null> <null> false +test SYSADMIN VDBResources TABLE <null> <null> <null> <null> <null> <null> true test test all_databases TABLE <null> <null> <null> <null> <null> <null> false test test all_models TABLE <null> <null> <null> <null> <null> <null> false test test all_tables TABLE <null> <null> <null> <null> <null> <null> false -Row Count : 26 +Row Count : 27 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 test java.lang.String TABLE_CAT string SYS Tables 255 255 0 false true false true 1 false true true true TABLE_SCHEM 12 test java.lang.String TABLE_SCHEM string SYS Tables 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetColumns.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetColumns.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetColumns.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -363,15 +363,15 @@ QT_Ora9DS BQT2 LargeB BigDecimalValue 2 bigdecimal 20 <null> 0 10 1 <null> <null> <null> <null> 126 16 NO <null> <null> <null> ! <null> NO QT_Ora9DS BQT1 LargeB ObjectValue 2000 object 2048 <null> 0 10 1 <null> <null> <null> <null> 2048 17 NO <null> <null> <null> ! <null> NO QT_Ora9DS BQT2 LargeB ObjectValue 2000 object 2048 <null> 0 10 1 <null> <null> <null> <null> 2048 17 NO <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews VDBName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 1 YES <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews SchemaName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 2 YES <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews Name 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 3 YES <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews TargetSchemaName 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 4 NO <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews TargetName 12 string 4000 <null> 0 10 1 <null> <null> <null> <null> 4000 5 NO <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews Valid -7 boolean 1 <null> 0 10 1 <null> <null> <null> <null> 0 6 NO <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews LoadState 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 7 NO <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews Updated 93 timestamp 29 <null> 0 10 1 <null> <null> <null> <null> 0 8 NO <null> <null> <null> ! <null> NO -QT_Ora9DS SYS MatViews Cardinality 4 integer 10 <null> 0 10 1 <null> <null> <null> <null> 10 9 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews VDBName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 1 YES <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews SchemaName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 2 YES <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews Name 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 3 YES <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews TargetSchemaName 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 4 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews TargetName 12 string 4000 <null> 0 10 1 <null> <null> <null> <null> 4000 5 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews Valid -7 boolean 1 <null> 0 10 1 <null> <null> <null> <null> 0 6 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews LoadState 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 7 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews Updated 93 timestamp 29 <null> 0 10 1 <null> <null> <null> <null> 0 8 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN MatViews Cardinality 4 integer 10 <null> 0 10 1 <null> <null> <null> <null> 10 9 NO <null> <null> <null> ! <null> NO QT_Ora9DS BQT1 MediumA IntKey 4 integer 22 <null> 0 10 0 <null> <null> <null> <null> 0 1 YES <null> <null> <null> ! <null> NO QT_Ora9DS BQT2 MediumA IntKey 4 integer 22 <null> 0 10 0 <null> <null> <null> <null> 0 1 YES <null> <null> <null> ! <null> NO QT_Ora9DS BQT1 MediumA StringKey 12 string 10 <null> 0 10 0 <null> <null> <null> <null> 10 2 YES <null> <null> <null> ! <null> NO @@ -685,6 +685,8 @@ QT_Ora9DS VQT Union.U9 A 4 integer 22 <null> 0 10 0 <null> <null> <null> <null> 0 1 YES <null> <null> <null> ! <null> NO QT_Ora9DS VQT Union.U9 B 12 string 10 <null> 0 10 0 <null> <null> <null> <null> 10 2 YES <null> <null> <null> ! <null> NO QT_Ora9DS VQT Union.U9 C 7 float 20 <null> 0 10 0 <null> <null> <null> <null> 126 3 YES <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN VDBResources resourcePath 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 1 NO <null> <null> <null> ! <null> NO +QT_Ora9DS SYSADMIN VDBResources contents 2004 blob 2147483647 <null> 0 10 1 <null> <null> <null> <null> 0 2 NO <null> <null> <null> ! <null> NO QT_Ora9DS SYS VirtualDatabases Name 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 1 YES <null> <null> <null> ! <null> NO QT_Ora9DS SYS VirtualDatabases Version 12 string 50 <null> 0 10 0 <null> <null> <null> <null> 50 2 YES <null> <null> <null> ! <null> NO QT_Ora9DS XQTDoc choiceTestDocument choiceTest.data1.wrapper1.data1 12 string 4000 <null> 0 0 1 <null> <null> <null> <null> 0 0 NO <null> <null> <null> ! <null> NO @@ -1066,7 +1068,7 @@ QT_Ora9DS XQT xqtFullData BigIntegerValue 2 biginteger 19 <null> 0 10 1 <null> <null> <null> <null> 28 15 NO <null> <null> <null> ! <null> NO QT_Ora9DS XQT xqtFullData BigDecimalValue 2 bigdecimal 20 <null> 0 10 1 <null> <null> <null> <null> 126 16 NO <null> <null> <null> ! <null> NO QT_Ora9DS XQT xqtFullData ObjectValue 2000 object 2048 <null> 0 10 1 <null> <null> <null> <null> 2048 17 NO <null> <null> <null> ! <null> NO -Row Count : 1066 +Row Count : 1068 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 QT_Ora9DS java.lang.String TABLE_CAT string SYS Columns 255 255 0 false false false false 0 true true false false TABLE_SCHEM 12 QT_Ora9DS java.lang.String TABLE_SCHEM string SYS Columns 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -41,21 +41,15 @@ QT_Ora9DS SP sp_rows_between BigIntegerValue 3 2 biginteger 19 28 0 10 1 <null> <null> <null> <null> <null> 15 YES sp_rows_between QT_Ora9DS SP sp_rows_between BigDecimalValue 3 2 bigdecimal 20 126 0 10 1 <null> <null> <null> <null> <null> 16 YES sp_rows_between QT_Ora9DS SP sp_rows_between ObjectValue 3 2000 object 2147483647 2048 0 10 1 <null> <null> <null> <null> <null> 17 YES sp_rows_between -QT_Ora9DS SYS getBinaryVDBResource resourcePath 1 12 string 50 50 0 10 0 <null> <null> <null> <null> <null> 1 NO getBinaryVDBResource -QT_Ora9DS SYS getBinaryVDBResource VdbResource 3 2004 blob 2147483647 2147483647 0 10 1 <null> <null> <null> <null> <null> 1 YES getBinaryVDBResource -QT_Ora9DS SYS getCharacterVDBResource resourcePath 1 12 string 50 50 0 10 0 <null> <null> <null> <null> <null> 1 NO getCharacterVDBResource -QT_Ora9DS SYS getCharacterVDBResource VdbResource 3 2005 clob 2147483647 2147483647 0 10 1 <null> <null> <null> <null> <null> 1 YES getCharacterVDBResource -QT_Ora9DS SYS getVDBResourcePaths ResourcePath 3 12 string 50 50 0 10 1 <null> <null> <null> <null> <null> 1 YES getVDBResourcePaths -QT_Ora9DS SYS getVDBResourcePaths isBinary 3 -7 boolean 1 1 0 10 1 <null> <null> <null> <null> <null> 2 YES getVDBResourcePaths QT_Ora9DS SYS getXMLSchemas document 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO getXMLSchemas QT_Ora9DS SYS getXMLSchemas schema 3 2009 xml 2147483647 2147483647 0 10 1 <null> <null> <null> <null> <null> 1 YES getXMLSchemas -QT_Ora9DS SYS refreshMatView ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatView -QT_Ora9DS SYS refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatView -QT_Ora9DS SYS refreshMatView RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView -QT_Ora9DS SYS refreshMatViewRow ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow -QT_Ora9DS SYS refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow -QT_Ora9DS SYS refreshMatViewRow RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow -Row Count : 55 +QT_Ora9DS SYSADMIN refreshMatView ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatView +QT_Ora9DS SYSADMIN refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatView +QT_Ora9DS SYSADMIN refreshMatView RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView +QT_Ora9DS SYSADMIN refreshMatViewRow ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow +QT_Ora9DS SYSADMIN refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow +QT_Ora9DS SYSADMIN refreshMatViewRow RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow +Row Count : 49 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable PROCEDURE_CAT 12 QT_Ora9DS java.lang.String PROCEDURE_CAT string SYS ProcedureParams 255 255 0 false false false false 0 true true false false PROCEDURE_SCHEM 12 QT_Ora9DS java.lang.String PROCEDURE_SCHEM string SYS ProcedureParams 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedures.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedures.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedures.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -4,13 +4,10 @@ QT_Ora9DS SP sp_count_all_smalla_rows <null> <null> <null> <null> 1 sp_count_all_smalla_rows QT_Ora9DS SP sp_count_rows_between <null> <null> <null> <null> 1 sp_count_rows_between QT_Ora9DS SP sp_rows_between <null> <null> <null> <null> 2 sp_rows_between -QT_Ora9DS SYS getBinaryVDBResource <null> <null> <null> <null> 2 getBinaryVDBResource -QT_Ora9DS SYS getCharacterVDBResource <null> <null> <null> <null> 2 getCharacterVDBResource -QT_Ora9DS SYS getVDBResourcePaths <null> <null> <null> <null> 2 getVDBResourcePaths QT_Ora9DS SYS getXMLSchemas <null> <null> <null> <null> 2 getXMLSchemas -QT_Ora9DS SYS refreshMatView <null> <null> <null> <null> 1 refreshMatView -QT_Ora9DS SYS refreshMatViewRow <null> <null> <null> <null> 1 refreshMatViewRow -Row Count : 10 +QT_Ora9DS SYSADMIN refreshMatView <null> <null> <null> <null> 1 refreshMatView +QT_Ora9DS SYSADMIN refreshMatViewRow <null> <null> <null> <null> 1 refreshMatViewRow +Row Count : 7 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable PROCEDURE_CAT 12 QT_Ora9DS java.lang.String PROCEDURE_CAT string SYS Procedures 255 255 0 false false false false 0 true true false false PROCEDURE_SCHEM 12 QT_Ora9DS java.lang.String PROCEDURE_SCHEM string SYS Procedures 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProceduresWithEscape.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProceduresWithEscape.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProceduresWithEscape.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -4,13 +4,10 @@ QT_Ora9DS SP sp_count_all_smalla_rows <null> <null> <null> <null> 1 sp_count_all_smalla_rows QT_Ora9DS SP sp_count_rows_between <null> <null> <null> <null> 1 sp_count_rows_between QT_Ora9DS SP sp_rows_between <null> <null> <null> <null> 2 sp_rows_between -QT_Ora9DS SYS getBinaryVDBResource <null> <null> <null> <null> 2 getBinaryVDBResource -QT_Ora9DS SYS getCharacterVDBResource <null> <null> <null> <null> 2 getCharacterVDBResource -QT_Ora9DS SYS getVDBResourcePaths <null> <null> <null> <null> 2 getVDBResourcePaths QT_Ora9DS SYS getXMLSchemas <null> <null> <null> <null> 2 getXMLSchemas -QT_Ora9DS SYS refreshMatView <null> <null> <null> <null> 1 refreshMatView -QT_Ora9DS SYS refreshMatViewRow <null> <null> <null> <null> 1 refreshMatViewRow -Row Count : 10 +QT_Ora9DS SYSADMIN refreshMatView <null> <null> <null> <null> 1 refreshMatView +QT_Ora9DS SYSADMIN refreshMatViewRow <null> <null> <null> <null> 1 refreshMatViewRow +Row Count : 7 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable PROCEDURE_CAT 12 QT_Ora9DS java.lang.String PROCEDURE_CAT string SYS Procedures 255 255 0 false false false false 0 true true false false PROCEDURE_SCHEM 12 QT_Ora9DS java.lang.String PROCEDURE_SCHEM string SYS Procedures 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetSchemas.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetSchemas.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetSchemas.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -4,13 +4,14 @@ BQT2 QT_Ora9DS SP QT_Ora9DS SYS QT_Ora9DS +SYSADMIN QT_Ora9DS VQT QT_Ora9DS XQT QT_Ora9DS XQTDoc QT_Ora9DS XQTNestedDoc QT_Ora9DS XQTRecursiveDoc QT_Ora9DS pg_catalog QT_Ora9DS -Row Count : 10 +Row Count : 11 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_SCHEM 12 QT_Ora9DS java.lang.String TABLE_SCHEM string SYS Schemas 255 255 0 false true false true 1 false true true true TABLE_CATALOG 12 QT_Ora9DS java.lang.String TABLE_CATALOG string SYS Schemas 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -22,7 +22,6 @@ QT_Ora9DS SYS DataTypes SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS KeyColumns SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Keys SYSTEM TABLE <null> <null> <null> <null> <null> <null> true -QT_Ora9DS SYS MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS ProcedureParams SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Procedures SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Properties SYSTEM TABLE <null> <null> <null> <null> <null> <null> true @@ -30,6 +29,7 @@ QT_Ora9DS SYS Schemas SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Tables SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS VirtualDatabases SYSTEM TABLE <null> <null> <null> <null> <null> <null> true +QT_Ora9DS SYSADMIN MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS pg_catalog pg_am SYSTEM TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS pg_catalog pg_attrdef SYSTEM TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS pg_catalog pg_attribute SYSTEM TABLE <null> <null> <null> <null> <null> <null> false @@ -57,6 +57,7 @@ QT_Ora9DS BQT2 MediumB TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallA TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallB TABLE <null> <null> <null> <null> <null> <null> true +QT_Ora9DS SYSADMIN VDBResources TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS VQT Base.Agg1 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg2 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg3 TABLE <null> <null> <null> <null> <null> <null> false @@ -133,7 +134,7 @@ QT_Ora9DS XQTNestedDoc testOptimizableTempTable.MappingClasses.moveToRootTempTable XMLSTAGINGTABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQTNestedDoc testRootTempTable.MappingClasses.TemporaryTable1 XMLSTAGINGTABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQTRecursiveDoc testSimpleTempTable.MappingClasses.TemporaryTable1 XMLSTAGINGTABLE <null> <null> <null> <null> <null> <null> false -Row Count : 133 +Row Count : 134 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 QT_Ora9DS java.lang.String TABLE_CAT string SYS Tables 255 255 0 false true false true 1 false true true true TABLE_SCHEM 12 QT_Ora9DS java.lang.String TABLE_SCHEM string SYS Tables 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_allTables.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_allTables.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_allTables.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -22,7 +22,6 @@ QT_Ora9DS SYS DataTypes SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS KeyColumns SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Keys SYSTEM TABLE <null> <null> <null> <null> <null> <null> true -QT_Ora9DS SYS MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS ProcedureParams SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Procedures SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Properties SYSTEM TABLE <null> <null> <null> <null> <null> <null> true @@ -30,6 +29,7 @@ QT_Ora9DS SYS Schemas SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS Tables SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS SYS VirtualDatabases SYSTEM TABLE <null> <null> <null> <null> <null> <null> true +QT_Ora9DS SYSADMIN MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS pg_catalog pg_am SYSTEM TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS pg_catalog pg_attrdef SYSTEM TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS pg_catalog pg_attribute SYSTEM TABLE <null> <null> <null> <null> <null> <null> false @@ -57,6 +57,7 @@ QT_Ora9DS BQT2 MediumB TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallA TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallB TABLE <null> <null> <null> <null> <null> <null> true +QT_Ora9DS SYSADMIN VDBResources TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS VQT Base.Agg1 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg2 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg3 TABLE <null> <null> <null> <null> <null> <null> false @@ -133,7 +134,7 @@ QT_Ora9DS XQTNestedDoc testOptimizableTempTable.MappingClasses.moveToRootTempTable XMLSTAGINGTABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQTNestedDoc testRootTempTable.MappingClasses.TemporaryTable1 XMLSTAGINGTABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQTRecursiveDoc testSimpleTempTable.MappingClasses.TemporaryTable1 XMLSTAGINGTABLE <null> <null> <null> <null> <null> <null> false -Row Count : 133 +Row Count : 134 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 QT_Ora9DS java.lang.String TABLE_CAT string SYS Tables 255 255 0 false true false true 1 false true true true TABLE_SCHEM 12 QT_Ora9DS java.lang.String TABLE_SCHEM string SYS Tables 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableMultipleTypes.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableMultipleTypes.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableMultipleTypes.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -16,6 +16,7 @@ QT_Ora9DS BQT2 MediumB TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallA TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallB TABLE <null> <null> <null> <null> <null> <null> true +QT_Ora9DS SYSADMIN VDBResources TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS VQT Base.Agg1 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg2 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg3 TABLE <null> <null> <null> <null> <null> <null> false @@ -49,7 +50,7 @@ QT_Ora9DS VQT Union.U9 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQT xqtData TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQT xqtFullData TABLE <null> <null> <null> <null> <null> <null> false -Row Count : 49 +Row Count : 50 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 QT_Ora9DS java.lang.String TABLE_CAT string SYS Tables 255 255 0 false true false true 1 false true true true TABLE_SCHEM 12 QT_Ora9DS java.lang.String TABLE_SCHEM string SYS Tables 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableTypes.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableTypes.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetTables_specificTableTypes.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -16,6 +16,7 @@ QT_Ora9DS BQT2 MediumB TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallA TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS BQT2 SmallB TABLE <null> <null> <null> <null> <null> <null> true +QT_Ora9DS SYSADMIN VDBResources TABLE <null> <null> <null> <null> <null> <null> true QT_Ora9DS VQT Base.Agg1 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg2 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS VQT Base.Agg3 TABLE <null> <null> <null> <null> <null> <null> false @@ -49,7 +50,7 @@ QT_Ora9DS VQT Union.U9 TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQT xqtData TABLE <null> <null> <null> <null> <null> <null> false QT_Ora9DS XQT xqtFullData TABLE <null> <null> <null> <null> <null> <null> false -Row Count : 49 +Row Count : 50 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 QT_Ora9DS java.lang.String TABLE_CAT string SYS Tables 255 255 0 false true false true 1 false true true true TABLE_SCHEM 12 QT_Ora9DS java.lang.String TABLE_SCHEM string SYS Tables 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_ATTRIBUTE.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -19,222 +19,224 @@ 16 4 SUPPLIER_STATE 1043 2 5 2 false false false 17 5 VDBName 1043 255 1 255 false false false 18 5 SchemaName 1043 255 2 255 false false false -19 5 TableName 1043 255 3 255 false false false -20 5 Name 1043 255 4 255 false false false -21 5 Position <null> 10 5 10 false false false -22 5 NameInSource 1043 255 6 255 false false false -23 5 DataType 1043 100 7 100 false false false -24 5 Scale <null> 10 8 10 false false false -25 5 Length <null> 10 9 10 false false false -26 5 IsLengthFixed 16 1 10 1 false false false -27 5 SupportsSelect 16 1 11 1 false false false -28 5 SupportsUpdates 16 1 12 1 false false false -29 5 IsCaseSensitive 16 1 13 1 false false false -30 5 IsSigned 16 1 14 1 false false false -31 5 IsCurrency 16 1 15 1 false false false -32 5 IsAutoIncremented 16 1 16 1 false false false -33 5 NullType 1043 20 17 20 false false false -34 5 MinRange 1043 50 18 50 false false false -35 5 MaxRange 1043 50 19 50 false false false -36 5 SearchType 1043 20 20 20 false false false -37 5 Format 1043 255 21 255 false false false -38 5 DefaultValue 1043 255 22 255 false false false -39 5 JavaClass 1043 500 23 500 false false false -40 5 Precision <null> 10 24 10 false false false -41 5 CharOctetLength <null> 10 25 10 false false false -42 5 Radix <null> 10 26 10 false false false -43 5 UID 1043 50 27 50 false false false -44 5 Description 1043 255 28 255 false false false -45 5 OID <null> 10 29 10 false false false -46 6 Name 1043 100 1 100 false false false -47 6 IsStandard 16 1 2 1 false false false -48 6 IsPhysical 16 1 3 1 false false false -49 6 TypeName 1043 100 4 100 false false false -50 6 JavaClass 1043 500 5 500 false false false -51 6 Scale <null> 10 6 10 false false false -52 6 TypeLength <null> 10 7 10 false false false -53 6 NullType 1043 20 8 20 false false false -54 6 IsSigned 16 1 9 1 false false false -55 6 IsAutoIncremented 16 1 10 1 false false false -56 6 IsCaseSensitive 16 1 11 1 false false false -57 6 Precision <null> 10 12 10 false false false -58 6 Radix <null> 10 13 10 false false false -59 6 SearchType 1043 20 14 20 false false false -60 6 UID 1043 50 15 50 false false false -61 6 RuntimeType 1043 64 16 64 false false false -62 6 BaseType 1043 64 17 64 false false false -63 6 Description 1043 255 18 255 false false false -64 6 OID <null> 10 19 10 false false false -65 7 VDBName 1043 255 1 255 false false false -66 7 SchemaName 1043 255 2 255 false false false -67 7 TableName 1043 2048 3 2048 false false false -68 7 Name 1043 255 4 255 false false false -69 7 KeyName 1043 255 5 255 false false false -70 7 KeyType 1043 20 6 20 false false false -71 7 RefKeyUID 1043 50 7 50 false false false -72 7 UID 1043 50 8 50 false false false -73 7 Position <null> 10 9 10 false false false -74 7 OID <null> 10 10 10 false false false -75 8 VDBName 1043 255 1 255 false false false -76 8 SchemaName 1043 255 2 255 false false false -77 8 TableName 1043 2048 3 2048 false false false -78 8 Name 1043 255 4 255 false false false -79 8 Description 1043 255 5 255 false false false -80 8 NameInSource 1043 255 6 255 false false false -81 8 Type 1043 20 7 20 false false false -82 8 IsIndexed 16 1 8 1 false false false -83 8 RefKeyUID 1043 50 9 50 false false false -84 8 UID 1043 50 10 50 false false false -85 8 OID <null> 10 11 10 false false false -86 9 VDBName 1043 255 1 255 false false false -87 9 SchemaName 1043 255 2 255 false false false -88 9 Name 1043 255 3 255 false false false -89 9 TargetSchemaName 1043 255 4 255 false false false -90 9 TargetName 1043 4000 5 4000 false false false -91 9 Valid 16 0 6 0 false false false -92 9 LoadState 1043 255 7 255 false false false -93 9 Updated 1114 0 8 0 false false false -94 9 Cardinality <null> 10 9 10 false false false -95 10 VDBName 1043 255 1 255 false false false -96 10 SchemaName 1043 255 2 255 false false false -97 10 ProcedureName 1043 255 3 255 false false false -98 10 Name 1043 255 4 255 false false false -99 10 DataType 1043 25 5 25 false false false -100 10 Position <null> 10 6 10 false false false -101 10 Type 1043 100 7 100 false false false -102 10 Optional 16 1 8 1 false false false -103 10 Precision <null> 10 9 10 false false false -104 10 TypeLength <null> 10 10 10 false false false -105 10 Scale <null> 10 11 10 false false false -106 10 Radix <null> 10 12 10 false false false -107 10 NullType 1043 10 13 10 false false false -108 10 UID 1043 50 14 50 false false false -109 10 Description 1043 255 15 255 false false false -110 10 OID <null> 10 16 10 false false false -111 11 VDBName 1043 255 1 255 false false false -112 11 SchemaName 1043 255 2 255 false false false -113 11 Name 1043 255 3 255 false false false -114 11 NameInSource 1043 255 4 255 false false false -115 11 ReturnsResults 16 1 5 1 false false false -116 11 UID 1043 50 6 50 false false false -117 11 Description 1043 255 7 255 false false false -118 11 OID <null> 10 8 10 false false false -119 12 Name 1043 255 1 255 false false false -120 12 Value 1043 255 2 255 false false false -121 12 UID 1043 50 3 50 false false false -122 12 OID <null> 10 4 10 false false false -123 13 PKTABLE_CAT 1043 255 1 255 false false false -124 13 PKTABLE_SCHEM 1043 255 2 255 false false false -125 13 PKTABLE_NAME 1043 255 3 255 false false false -126 13 PKCOLUMN_NAME 1043 255 4 255 false false false -127 13 FKTABLE_CAT 1043 255 5 255 false false false -128 13 FKTABLE_SCHEM 1043 255 6 255 false false false -129 13 FKTABLE_NAME 1043 255 7 255 false false false -130 13 FKCOLUMN_NAME 1043 255 8 255 false false false -131 13 KEY_SEQ 21 5 9 5 false false false -132 13 UPDATE_RULE <null> 10 10 10 false false false -133 13 DELETE_RULE <null> 10 11 10 false false false -134 13 FK_NAME 1043 255 12 255 false false false -135 13 PK_NAME 1043 255 13 255 false false false -136 13 DEFERRABILITY <null> 10 14 10 false false false -137 14 VDBName 1043 255 1 255 false false false -138 14 Name 1043 255 2 255 false false false -139 14 IsPhysical 16 1 3 1 false false false -140 14 UID 1043 50 4 50 false false false -141 14 Description 1043 255 5 255 false false false -142 14 PrimaryMetamodelURI 1043 255 6 255 false false false -143 14 OID <null> 10 7 10 false false false -144 15 VDBName 1043 255 1 255 false false false -145 15 SchemaName 1043 255 2 255 false false false -146 15 Name 1043 255 3 255 false false false -147 15 Type 1043 20 4 20 false false false -148 15 NameInSource 1043 255 5 255 false false false -149 15 IsPhysical 16 1 6 1 false false false -150 15 SupportsUpdates 16 1 7 1 false false false -151 15 UID 1043 50 8 50 false false false -152 15 Cardinality <null> 10 9 10 false false false -153 15 Description 1043 255 10 255 false false false -154 15 IsSystem 16 1 11 1 false false false -155 15 IsMaterialized 16 0 12 0 false false false -156 15 OID <null> 10 13 10 false false false -157 16 Name 1043 255 1 255 false false false -158 16 Version 1043 50 2 50 false false false -159 17 oid <null> 0 1 0 false false false -160 17 nspname 1043 0 2 0 false false false +19 5 Name 1043 255 3 255 false false false +20 5 TargetSchemaName 1043 255 4 255 false false false +21 5 TargetName 1043 4000 5 4000 false false false +22 5 Valid 16 0 6 0 false false false +23 5 LoadState 1043 255 7 255 false false false +24 5 Updated 1114 0 8 0 false false false +25 5 Cardinality <null> 10 9 10 false false false +26 6 resourcePath 1043 255 1 255 false false false +27 6 contents 14939 0 2 0 false false false +28 7 VDBName 1043 255 1 255 false false false +29 7 SchemaName 1043 255 2 255 false false false +30 7 TableName 1043 255 3 255 false false false +31 7 Name 1043 255 4 255 false false false +32 7 Position <null> 10 5 10 false false false +33 7 NameInSource 1043 255 6 255 false false false +34 7 DataType 1043 100 7 100 false false false +35 7 Scale <null> 10 8 10 false false false +36 7 Length <null> 10 9 10 false false false +37 7 IsLengthFixed 16 1 10 1 false false false +38 7 SupportsSelect 16 1 11 1 false false false +39 7 SupportsUpdates 16 1 12 1 false false false +40 7 IsCaseSensitive 16 1 13 1 false false false +41 7 IsSigned 16 1 14 1 false false false +42 7 IsCurrency 16 1 15 1 false false false +43 7 IsAutoIncremented 16 1 16 1 false false false +44 7 NullType 1043 20 17 20 false false false +45 7 MinRange 1043 50 18 50 false false false +46 7 MaxRange 1043 50 19 50 false false false +47 7 SearchType 1043 20 20 20 false false false +48 7 Format 1043 255 21 255 false false false +49 7 DefaultValue 1043 255 22 255 false false false +50 7 JavaClass 1043 500 23 500 false false false +51 7 Precision <null> 10 24 10 false false false +52 7 CharOctetLength <null> 10 25 10 false false false +53 7 Radix <null> 10 26 10 false false false +54 7 UID 1043 50 27 50 false false false +55 7 Description 1043 255 28 255 false false false +56 7 OID <null> 10 29 10 false false false +57 8 Name 1043 100 1 100 false false false +58 8 IsStandard 16 1 2 1 false false false +59 8 IsPhysical 16 1 3 1 false false false +60 8 TypeName 1043 100 4 100 false false false +61 8 JavaClass 1043 500 5 500 false false false +62 8 Scale <null> 10 6 10 false false false +63 8 TypeLength <null> 10 7 10 false false false +64 8 NullType 1043 20 8 20 false false false +65 8 IsSigned 16 1 9 1 false false false +66 8 IsAutoIncremented 16 1 10 1 false false false +67 8 IsCaseSensitive 16 1 11 1 false false false +68 8 Precision <null> 10 12 10 false false false +69 8 Radix <null> 10 13 10 false false false +70 8 SearchType 1043 20 14 20 false false false +71 8 UID 1043 50 15 50 false false false +72 8 RuntimeType 1043 64 16 64 false false false +73 8 BaseType 1043 64 17 64 false false false +74 8 Description 1043 255 18 255 false false false +75 8 OID <null> 10 19 10 false false false +76 9 VDBName 1043 255 1 255 false false false +77 9 SchemaName 1043 255 2 255 false false false +78 9 TableName 1043 2048 3 2048 false false false +79 9 Name 1043 255 4 255 false false false +80 9 KeyName 1043 255 5 255 false false false +81 9 KeyType 1043 20 6 20 false false false +82 9 RefKeyUID 1043 50 7 50 false false false +83 9 UID 1043 50 8 50 false false false +84 9 Position <null> 10 9 10 false false false +85 9 OID <null> 10 10 10 false false false +86 10 VDBName 1043 255 1 255 false false false +87 10 SchemaName 1043 255 2 255 false false false +88 10 TableName 1043 2048 3 2048 false false false +89 10 Name 1043 255 4 255 false false false +90 10 Description 1043 255 5 255 false false false +91 10 NameInSource 1043 255 6 255 false false false +92 10 Type 1043 20 7 20 false false false +93 10 IsIndexed 16 1 8 1 false false false +94 10 RefKeyUID 1043 50 9 50 false false false +95 10 UID 1043 50 10 50 false false false +96 10 OID <null> 10 11 10 false false false +97 11 VDBName 1043 255 1 255 false false false +98 11 SchemaName 1043 255 2 255 false false false +99 11 ProcedureName 1043 255 3 255 false false false +100 11 Name 1043 255 4 255 false false false +101 11 DataType 1043 25 5 25 false false false +102 11 Position <null> 10 6 10 false false false +103 11 Type 1043 100 7 100 false false false +104 11 Optional 16 1 8 1 false false false +105 11 Precision <null> 10 9 10 false false false +106 11 TypeLength <null> 10 10 10 false false false +107 11 Scale <null> 10 11 10 false false false +108 11 Radix <null> 10 12 10 false false false +109 11 NullType 1043 10 13 10 false false false +110 11 UID 1043 50 14 50 false false false +111 11 Description 1043 255 15 255 false false false +112 11 OID <null> 10 16 10 false false false +113 12 VDBName 1043 255 1 255 false false false +114 12 SchemaName 1043 255 2 255 false false false +115 12 Name 1043 255 3 255 false false false +116 12 NameInSource 1043 255 4 255 false false false +117 12 ReturnsResults 16 1 5 1 false false false +118 12 UID 1043 50 6 50 false false false +119 12 Description 1043 255 7 255 false false false +120 12 OID <null> 10 8 10 false false false +121 13 Name 1043 255 1 255 false false false +122 13 Value 1043 255 2 255 false false false +123 13 UID 1043 50 3 50 false false false +124 13 OID <null> 10 4 10 false false false +125 14 PKTABLE_CAT 1043 255 1 255 false false false +126 14 PKTABLE_SCHEM 1043 255 2 255 false false false +127 14 PKTABLE_NAME 1043 255 3 255 false false false +128 14 PKCOLUMN_NAME 1043 255 4 255 false false false +129 14 FKTABLE_CAT 1043 255 5 255 false false false +130 14 FKTABLE_SCHEM 1043 255 6 255 false false false +131 14 FKTABLE_NAME 1043 255 7 255 false false false +132 14 FKCOLUMN_NAME 1043 255 8 255 false false false +133 14 KEY_SEQ 21 5 9 5 false false false +134 14 UPDATE_RULE <null> 10 10 10 false false false +135 14 DELETE_RULE <null> 10 11 10 false false false +136 14 FK_NAME 1043 255 12 255 false false false +137 14 PK_NAME 1043 255 13 255 false false false +138 14 DEFERRABILITY <null> 10 14 10 false false false +139 15 VDBName 1043 255 1 255 false false false +140 15 Name 1043 255 2 255 false false false +141 15 IsPhysical 16 1 3 1 false false false +142 15 UID 1043 50 4 50 false false false +143 15 Description 1043 255 5 255 false false false +144 15 PrimaryMetamodelURI 1043 255 6 255 false false false +145 15 OID <null> 10 7 10 false false false +146 16 VDBName 1043 255 1 255 false false false +147 16 SchemaName 1043 255 2 255 false false false +148 16 Name 1043 255 3 255 false false false +149 16 Type 1043 20 4 20 false false false +150 16 NameInSource 1043 255 5 255 false false false +151 16 IsPhysical 16 1 6 1 false false false +152 16 SupportsUpdates 16 1 7 1 false false false +153 16 UID 1043 50 8 50 false false false +154 16 Cardinality <null> 10 9 10 false false false +155 16 Description 1043 255 10 255 false false false +156 16 IsSystem 16 1 11 1 false false false +157 16 IsMaterialized 16 0 12 0 false false false +158 16 OID <null> 10 13 10 false false false +159 17 Name 1043 255 1 255 false false false +160 17 Version 1043 50 2 50 false false false 161 18 oid <null> 0 1 0 false false false -162 18 relname 1043 0 2 0 false false false -163 18 relnamespace <null> 0 3 0 false false false -164 18 relkind 1042 0 4 0 false false false -165 18 relam <null> 0 5 0 false false false -166 18 reltuples 700 0 6 0 false false false -167 18 relpages <null> 0 7 0 false false false -168 18 relhasrules 16 0 8 0 false false false -169 18 relhasoids 1043 0 9 0 false false false -170 19 oid <null> 0 1 0 false false false -171 19 attrelid <null> 0 2 0 false false false -172 19 attname 1043 0 3 0 false false false -173 19 atttypid <null> 0 4 0 false false false -174 19 attlen 21 0 5 0 false false false -175 19 attnum 21 0 6 0 false false false -176 19 atttypmod <null> 0 7 0 false false false -177 19 attnotnull 16 0 8 0 false false false -178 19 attisdropped 16 0 9 0 false false false -179 19 atthasdef 16 0 10 0 false false false -180 20 oid <null> 0 1 0 false false false -181 20 typname 1043 0 2 0 false false false -182 20 typnamespace <null> 0 3 0 false false false -183 20 typlen 21 0 4 0 false false false -184 20 typtype 1042 0 5 0 false false false -185 20 typbasetype <null> 0 6 0 false false false -186 20 typtypmod <null> 0 7 0 false false false -187 20 typrelid <null> 0 8 0 false false false -188 21 oid <null> 0 1 0 false false false -189 21 indexrelid <null> 0 2 0 false false false -190 21 indrelid <null> 0 3 0 false false false -191 21 indisclustered 16 0 4 0 false false false -192 21 indisunique 16 0 5 0 false false false -193 21 indisprimary 16 0 6 0 false false false -194 21 indexprs 1043 0 7 0 false false false -195 21 indkey 1043 0 8 0 false false false -196 22 oid <null> 0 1 0 false false false -197 22 amname 1043 0 2 0 false false false +162 18 nspname 1043 0 2 0 false false false +163 19 oid <null> 0 1 0 false false false +164 19 relname 1043 0 2 0 false false false +165 19 relnamespace <null> 0 3 0 false false false +166 19 relkind 1042 0 4 0 false false false +167 19 relam <null> 0 5 0 false false false +168 19 reltuples 700 0 6 0 false false false +169 19 relpages <null> 0 7 0 false false false +170 19 relhasrules 16 0 8 0 false false false +171 19 relhasoids 1043 0 9 0 false false false +172 20 oid <null> 0 1 0 false false false +173 20 attrelid <null> 0 2 0 false false false +174 20 attname 1043 0 3 0 false false false +175 20 atttypid <null> 0 4 0 false false false +176 20 attlen 21 0 5 0 false false false +177 20 attnum 21 0 6 0 false false false +178 20 atttypmod <null> 0 7 0 false false false +179 20 attnotnull 16 0 8 0 false false false +180 20 attisdropped 16 0 9 0 false false false +181 20 atthasdef 16 0 10 0 false false false +182 21 oid <null> 0 1 0 false false false +183 21 typname 1043 0 2 0 false false false +184 21 typnamespace <null> 0 3 0 false false false +185 21 typlen 21 0 4 0 false false false +186 21 typtype 1042 0 5 0 false false false +187 21 typbasetype <null> 0 6 0 false false false +188 21 typtypmod <null> 0 7 0 false false false +189 21 typrelid <null> 0 8 0 false false false +190 22 oid <null> 0 1 0 false false false +191 22 indexrelid <null> 0 2 0 false false false +192 22 indrelid <null> 0 3 0 false false false +193 22 indisclustered 16 0 4 0 false false false +194 22 indisunique 16 0 5 0 false false false +195 22 indisprimary 16 0 6 0 false false false +196 22 indexprs 1043 0 7 0 false false false +197 22 indkey 1043 0 8 0 false false false 198 23 oid <null> 0 1 0 false false false -199 23 proname 1043 0 2 0 false false false -200 23 proretset 16 0 3 0 false false false -201 23 prorettype <null> 0 4 0 false false false -202 23 pronargs 21 0 5 0 false false false -203 23 proargtypes <null> 0 6 0 false false false -204 23 proargnames <null> 0 7 0 false false false -205 23 proargmodes <null> 0 8 0 false false false -206 23 proallargtypes <null> 0 9 0 false false false -207 23 pronamespace <null> 0 10 0 false false false -208 24 oid <null> 0 1 0 false false false -209 24 tgconstrrelid <null> 0 2 0 false false false -210 24 tgfoid <null> 0 3 0 false false false -211 24 tgargs <null> 0 4 0 false false false -212 24 tgnargs <null> 0 5 0 false false false -213 24 tgdeferrable 16 0 6 0 false false false -214 24 tginitdeferred 16 0 7 0 false false false -215 24 tgconstrname 1043 0 8 0 false false false -216 24 tgrelid <null> 0 9 0 false false false -217 25 oid <null> 0 1 0 false false false -218 25 adsrc <null> 0 2 0 false false false -219 25 adrelid <null> 0 3 0 false false false -220 25 adnum <null> 0 4 0 false false false -221 26 oid <null> 0 1 0 false false false -222 26 datname 1043 0 2 0 false false false -223 26 encoding <null> 0 3 0 false false false -224 26 datlastsysoid <null> 0 4 0 false false false -225 26 datallowconn 1042 0 5 0 false false false -226 26 datconfig <null> 0 6 0 false false false -227 26 datacl <null> 0 7 0 false false false -228 26 datdba <null> 0 8 0 false false false -229 26 dattablespace <null> 0 9 0 false false false -230 27 oid <null> 0 1 0 false false false -231 27 usename 1043 0 2 0 false false false -232 27 usecreatedb 16 0 3 0 false false false -233 27 usesuper 16 0 4 0 false false false -Row Count : 234 +199 23 amname 1043 0 2 0 false false false +200 24 oid <null> 0 1 0 false false false +201 24 proname 1043 0 2 0 false false false +202 24 proretset 16 0 3 0 false false false +203 24 prorettype <null> 0 4 0 false false false +204 24 pronargs 21 0 5 0 false false false +205 24 proargtypes <null> 0 6 0 false false false +206 24 proargnames <null> 0 7 0 false false false +207 24 proargmodes <null> 0 8 0 false false false +208 24 proallargtypes <null> 0 9 0 false false false +209 24 pronamespace <null> 0 10 0 false false false +210 25 oid <null> 0 1 0 false false false +211 25 tgconstrrelid <null> 0 2 0 false false false +212 25 tgfoid <null> 0 3 0 false false false +213 25 tgargs <null> 0 4 0 false false false +214 25 tgnargs <null> 0 5 0 false false false +215 25 tgdeferrable 16 0 6 0 false false false +216 25 tginitdeferred 16 0 7 0 false false false +217 25 tgconstrname 1043 0 8 0 false false false +218 25 tgrelid <null> 0 9 0 false false false +219 26 oid <null> 0 1 0 false false false +220 26 adsrc <null> 0 2 0 false false false +221 26 adrelid <null> 0 3 0 false false false +222 26 adnum <null> 0 4 0 false false false +223 27 oid <null> 0 1 0 false false false +224 27 datname 1043 0 2 0 false false false +225 27 encoding <null> 0 3 0 false false false +226 27 datlastsysoid <null> 0 4 0 false false false +227 27 datallowconn 1042 0 5 0 false false false +228 27 datconfig <null> 0 6 0 false false false +229 27 datacl <null> 0 7 0 false false false +230 27 datdba <null> 0 8 0 false false false +231 27 dattablespace <null> 0 9 0 false false false +232 28 oid <null> 0 1 0 false false false +233 28 usename 1043 0 2 0 false false false +234 28 usecreatedb 16 0 3 0 false false false +235 28 usesuper 16 0 4 0 false false false +Row Count : 236 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable oid 4 PartsSupplier java.lang.Integer oid integer pg_catalog pg_attribute 11 10 0 false false false false 2 true true false false attrelid 4 PartsSupplier java.lang.Integer attrelid integer pg_catalog pg_attribute 11 10 0 false false false false 2 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_CLASS.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_CLASS.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_CLASS.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -5,30 +5,31 @@ 2 PARTSSUPPLIER.STATUS 0 r 0 0.0 0 false false 3 PARTSSUPPLIER.SUPPLIER_PARTS 0 r 0 0.0 0 false false 4 PARTSSUPPLIER.SUPPLIER 0 r 0 0.0 0 false false -5 Columns 1 r 0 0.0 0 false false -6 DataTypes 1 r 0 0.0 0 false false -7 KeyColumns 1 r 0 0.0 0 false false -8 Keys 1 r 0 0.0 0 false false -9 MatViews 1 r 0 0.0 0 false false -10 ProcedureParams 1 r 0 0.0 0 false false -11 Procedures 1 r 0 0.0 0 false false -12 Properties 1 r 0 0.0 0 false false -13 ReferenceKeyColumns 1 r 0 0.0 0 false false -14 Schemas 1 r 0 0.0 0 false false -15 Tables 1 r 0 0.0 0 false false -16 VirtualDatabases 1 r 0 0.0 0 false false -17 pg_namespace 2 v 0 0.0 0 false false -18 pg_class 2 v 0 0.0 0 false false -19 pg_attribute 2 v 0 0.0 0 false false -20 pg_type 2 v 0 0.0 0 false false -21 pg_index 2 v 0 0.0 0 false false -22 pg_am 2 v 0 0.0 0 false false -23 pg_proc 2 v 0 0.0 0 false false -24 pg_trigger 2 v 0 0.0 0 false false -25 pg_attrdef 2 v 0 0.0 0 false false -26 pg_database 2 v 0 0.0 0 false false -27 pg_user 2 v 0 0.0 0 false false -Row Count : 28 +5 MatViews 1 r 0 0.0 0 false false +6 VDBResources 1 r 0 0.0 0 false false +7 Columns 2 r 0 0.0 0 false false +8 DataTypes 2 r 0 0.0 0 false false +9 KeyColumns 2 r 0 0.0 0 false false +10 Keys 2 r 0 0.0 0 false false +11 ProcedureParams 2 r 0 0.0 0 false false +12 Procedures 2 r 0 0.0 0 false false +13 Properties 2 r 0 0.0 0 false false +14 ReferenceKeyColumns 2 r 0 0.0 0 false false +15 Schemas 2 r 0 0.0 0 false false +16 Tables 2 r 0 0.0 0 false false +17 VirtualDatabases 2 r 0 0.0 0 false false +18 pg_namespace 3 v 0 0.0 0 false false +19 pg_class 3 v 0 0.0 0 false false +20 pg_attribute 3 v 0 0.0 0 false false +21 pg_type 3 v 0 0.0 0 false false +22 pg_index 3 v 0 0.0 0 false false +23 pg_am 3 v 0 0.0 0 false false +24 pg_proc 3 v 0 0.0 0 false false +25 pg_trigger 3 v 0 0.0 0 false false +26 pg_attrdef 3 v 0 0.0 0 false false +27 pg_database 3 v 0 0.0 0 false false +28 pg_user 3 v 0 0.0 0 false false +Row Count : 29 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable oid 4 PartsSupplier java.lang.Integer oid integer pg_catalog pg_class 11 10 0 false false false false 2 true true false false relname 12 PartsSupplier java.lang.String relname string pg_catalog pg_class 4000 4000 0 false false false false 2 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_INDEX.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_INDEX.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_INDEX.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -9,10 +9,10 @@ 6 6 3 false false false 0 7 7 4 false false true 0 8 8 4 false false false 0 -9 9 18 false false true 0 -10 10 19 false false true 0 -11 11 21 false false true 0 -12 12 23 false false true 0 +9 9 19 false false true 0 +10 10 20 false false true 0 +11 11 22 false false true 0 +12 12 24 false false true 0 Row Count : 13 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable oid 4 PartsSupplier java.lang.Integer oid integer pg_catalog pg_index 11 10 0 false false false false 2 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_NAMESPACE.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_NAMESPACE.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_NAMESPACE.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,9 +1,10 @@ integer string oid nspname 0 PartsSupplier -1 SYS -2 pg_catalog -Row Count : 3 +1 SYSADMIN +2 SYS +3 pg_catalog +Row Count : 4 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable oid 4 PartsSupplier java.lang.Integer oid integer pg_catalog pg_namespace 11 10 0 false false false false 2 true true false false nspname 12 PartsSupplier java.lang.String nspname string pg_catalog pg_namespace 4000 4000 0 false false false false 2 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_PROC.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_PROC.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_PROC.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,12 +1,9 @@ integer string boolean integer short object object object object integer oid proname proretset prorettype pronargs proargtypes proargnames proargmodes proallargtypes pronamespace -0 getBinaryVDBResource false 3 2 <null> <null> <null> <null> 1 -1 getCharacterVDBResource false 5 2 <null> <null> <null> <null> 1 -2 getVDBResourcePaths false 45 2 <null> <null> <null> <null> 1 -3 getXMLSchemas false <null> 2 <null> <null> <null> <null> 1 -4 refreshMatViewRow false <null> 3 <null> <null> <null> <null> 1 -5 refreshMatView false <null> 3 <null> <null> <null> <null> 1 -Row Count : 6 +0 refreshMatViewRow false <null> 3 <null> <null> <null> <null> 1 +1 refreshMatView false <null> 3 <null> <null> <null> <null> 1 +2 getXMLSchemas false <null> 2 <null> <null> <null> <null> 2 +Row Count : 3 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable oid 4 PartsSupplier java.lang.Integer oid integer pg_catalog pg_proc 11 10 0 false false false false 2 true true false false proname 12 PartsSupplier java.lang.String proname string pg_catalog pg_proc 4000 4000 0 false false false false 2 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_TYPE.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_TYPE.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestODBCSchema/test_PG_TYPE.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,21 +1,21 @@ integer string integer short char integer integer integer oid typname typnamespace typlen typtype typbasetype typtypmod typrelid -16 boolean 1 1 b 0 -1 0 -20 long 1 8 b 0 -1 0 -21 short 1 2 b 0 -1 0 -23 int 1 4 b 0 -1 0 -25 text 1 -1 b 0 -1 0 -26 oid 1 4 b 0 -1 0 -142 xml 1 -1 b 0 -1 0 -700 float 1 4 b 0 -1 0 -701 double 1 8 b 0 -1 0 -1042 char 1 1 b 0 -1 0 -1043 string 1 -1 b 0 -1 0 -1082 date 1 4 b 0 -1 0 -1083 datetime 1 8 b 0 -1 0 -1114 timestamp 1 8 b 0 -1 0 -1700 decimal 1 -1 b 0 -1 0 -14939 lo 1 -1 b 0 -1 0 +16 boolean 2 1 b 0 -1 0 +20 long 2 8 b 0 -1 0 +21 short 2 2 b 0 -1 0 +23 int 2 4 b 0 -1 0 +25 text 2 -1 b 0 -1 0 +26 oid 2 4 b 0 -1 0 +142 xml 2 -1 b 0 -1 0 +700 float 2 4 b 0 -1 0 +701 double 2 8 b 0 -1 0 +1042 char 2 1 b 0 -1 0 +1043 string 2 -1 b 0 -1 0 +1082 date 2 4 b 0 -1 0 +1083 datetime 2 8 b 0 -1 0 +1114 timestamp 2 8 b 0 -1 0 +1700 decimal 2 -1 b 0 -1 0 +14939 lo 2 -1 b 0 -1 0 Row Count : 16 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable oid 4 PartsSupplier java.lang.Integer oid integer pg_catalog pg_type 11 10 0 false false false false 2 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testColumns.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testColumns.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testColumns.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -69,15 +69,15 @@ PartsSupplier SYS Keys RefKeyUID 12 string 50 <null> 0 10 1 <null> <null> <null> <null> 50 9 NO <null> <null> <null> ! <null> NO PartsSupplier SYS Keys UID 12 string 50 <null> 0 10 0 <null> <null> <null> <null> 50 10 YES <null> <null> <null> ! <null> NO PartsSupplier SYS Keys OID 4 integer 10 <null> 0 10 0 <null> <null> <null> <null> 10 11 YES <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews VDBName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 1 YES <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews SchemaName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 2 YES <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews Name 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 3 YES <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews TargetSchemaName 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 4 NO <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews TargetName 12 string 4000 <null> 0 10 1 <null> <null> <null> <null> 4000 5 NO <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews Valid -7 boolean 1 <null> 0 10 1 <null> <null> <null> <null> 0 6 NO <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews LoadState 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 7 NO <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews Updated 93 timestamp 29 <null> 0 10 1 <null> <null> <null> <null> 0 8 NO <null> <null> <null> ! <null> NO -PartsSupplier SYS MatViews Cardinality 4 integer 10 <null> 0 10 1 <null> <null> <null> <null> 10 9 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews VDBName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 1 YES <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews SchemaName 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 2 YES <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews Name 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 3 YES <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews TargetSchemaName 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 4 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews TargetName 12 string 4000 <null> 0 10 1 <null> <null> <null> <null> 4000 5 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews Valid -7 boolean 1 <null> 0 10 1 <null> <null> <null> <null> 0 6 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews LoadState 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 7 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews Updated 93 timestamp 29 <null> 0 10 1 <null> <null> <null> <null> 0 8 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN MatViews Cardinality 4 integer 10 <null> 0 10 1 <null> <null> <null> <null> 10 9 NO <null> <null> <null> ! <null> NO PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_ID 12 string 4 <null> 0 10 0 <null> <null> <null> <null> 4 1 YES <null> <null> <null> ! <null> NO PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_NAME 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 2 NO <null> <null> <null> ! <null> NO PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_COLOR 12 string 30 <null> 0 10 1 <null> <null> <null> <null> 30 3 NO <null> <null> <null> ! <null> NO @@ -157,6 +157,8 @@ PartsSupplier SYS Tables IsSystem -7 boolean 1 <null> 0 10 1 <null> <null> <null> <null> 1 11 NO <null> <null> <null> ! <null> NO PartsSupplier SYS Tables IsMaterialized -7 boolean 1 <null> 0 10 0 <null> <null> <null> <null> 0 12 YES <null> <null> <null> ! <null> NO PartsSupplier SYS Tables OID 4 integer 10 <null> 0 10 0 <null> <null> <null> <null> 10 13 YES <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN VDBResources resourcePath 12 string 255 <null> 0 10 1 <null> <null> <null> <null> 255 1 NO <null> <null> <null> ! <null> NO +PartsSupplier SYSADMIN VDBResources contents 2004 blob 2147483647 <null> 0 10 1 <null> <null> <null> <null> 0 2 NO <null> <null> <null> ! <null> NO PartsSupplier SYS VirtualDatabases Name 12 string 255 <null> 0 10 0 <null> <null> <null> <null> 255 1 YES <null> <null> <null> ! <null> NO PartsSupplier SYS VirtualDatabases Version 12 string 50 <null> 0 10 0 <null> <null> <null> <null> 50 2 YES <null> <null> <null> ! <null> NO PartsSupplier pg_catalog pg_am oid 4 integer 10 <null> 0 0 2 <null> <null> <null> <null> 0 1 <null> <null> <null> ! <null> NO @@ -234,7 +236,7 @@ PartsSupplier pg_catalog pg_user usename 12 string 4000 <null> 0 0 2 <null> <null> <null> <null> 0 2 <null> <null> <null> ! <null> NO PartsSupplier pg_catalog pg_user usecreatedb -7 boolean 1 <null> 0 0 2 <null> <null> <null> <null> 0 3 <null> <null> <null> ! <null> NO PartsSupplier pg_catalog pg_user usesuper -7 boolean 1 <null> 0 0 2 <null> <null> <null> <null> 0 4 <null> <null> <null> ! <null> NO -Row Count : 234 +Row Count : 236 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 PartsSupplier java.lang.String TABLE_CAT string SYS Columns 255 255 0 false false false false 0 true true false false TABLE_SCHEM 12 PartsSupplier java.lang.String TABLE_SCHEM string SYS Columns 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,20 +1,14 @@ string string string string short integer string integer integer short integer integer string string string string string integer string string PROCEDURE_CAT PROCEDURE_SCHEM PROCEDURE_NAME COLUMN_NAME COLUMN_TYPE DATA_TYPE TYPE_NAME PRECISION LENGTH SCALE RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SPECIFIC_NAME -PartsSupplier SYS getBinaryVDBResource resourcePath 1 12 string 50 50 0 10 0 <null> <null> <null> <null> <null> 1 NO getBinaryVDBResource -PartsSupplier SYS getBinaryVDBResource VdbResource 3 2004 blob 2147483647 2147483647 0 10 1 <null> <null> <null> <null> <null> 1 YES getBinaryVDBResource -PartsSupplier SYS getCharacterVDBResource resourcePath 1 12 string 50 50 0 10 0 <null> <null> <null> <null> <null> 1 NO getCharacterVDBResource -PartsSupplier SYS getCharacterVDBResource VdbResource 3 2005 clob 2147483647 2147483647 0 10 1 <null> <null> <null> <null> <null> 1 YES getCharacterVDBResource -PartsSupplier SYS getVDBResourcePaths ResourcePath 3 12 string 50 50 0 10 1 <null> <null> <null> <null> <null> 1 YES getVDBResourcePaths -PartsSupplier SYS getVDBResourcePaths isBinary 3 -7 boolean 1 1 0 10 1 <null> <null> <null> <null> <null> 2 YES getVDBResourcePaths PartsSupplier SYS getXMLSchemas document 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO getXMLSchemas PartsSupplier SYS getXMLSchemas schema 3 2009 xml 2147483647 2147483647 0 10 1 <null> <null> <null> <null> <null> 1 YES getXMLSchemas -PartsSupplier SYS refreshMatView ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatView -PartsSupplier SYS refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatView -PartsSupplier SYS refreshMatView RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView -PartsSupplier SYS refreshMatViewRow ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow -PartsSupplier SYS refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow -PartsSupplier SYS refreshMatViewRow RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow -Row Count : 14 +PartsSupplier SYSADMIN refreshMatView ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatView +PartsSupplier SYSADMIN refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatView +PartsSupplier SYSADMIN refreshMatView RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView +PartsSupplier SYSADMIN refreshMatViewRow ViewName 1 12 string 4000 4000 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow +PartsSupplier SYSADMIN refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow +PartsSupplier SYSADMIN refreshMatViewRow RowsUpdated 5 4 integer 10 10 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow +Row Count : 8 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable PROCEDURE_CAT 12 PartsSupplier java.lang.String PROCEDURE_CAT string SYS ProcedureParams 255 255 0 false false false false 0 true true false false PROCEDURE_SCHEM 12 PartsSupplier java.lang.String PROCEDURE_SCHEM string SYS ProcedureParams 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedures.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedures.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedures.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,12 +1,9 @@ string string string string string string string short string PROCEDURE_CAT PROCEDURE_SCHEM PROCEDURE_NAME RESERVED_1 RESERVED_2 RESERVED_3 REMARKS PROCEDURE_TYPE SPECIFIC_NAME -PartsSupplier SYS getBinaryVDBResource <null> <null> <null> <null> 2 getBinaryVDBResource -PartsSupplier SYS getCharacterVDBResource <null> <null> <null> <null> 2 getCharacterVDBResource -PartsSupplier SYS getVDBResourcePaths <null> <null> <null> <null> 2 getVDBResourcePaths PartsSupplier SYS getXMLSchemas <null> <null> <null> <null> 2 getXMLSchemas -PartsSupplier SYS refreshMatView <null> <null> <null> <null> 1 refreshMatView -PartsSupplier SYS refreshMatViewRow <null> <null> <null> <null> 1 refreshMatViewRow -Row Count : 6 +PartsSupplier SYSADMIN refreshMatView <null> <null> <null> <null> 1 refreshMatView +PartsSupplier SYSADMIN refreshMatViewRow <null> <null> <null> <null> 1 refreshMatViewRow +Row Count : 3 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable PROCEDURE_CAT 12 PartsSupplier java.lang.String PROCEDURE_CAT string SYS Procedures 255 255 0 false false false false 0 true true false false PROCEDURE_SCHEM 12 PartsSupplier java.lang.String PROCEDURE_SCHEM string SYS Procedures 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testSchemas.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testSchemas.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testSchemas.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -2,8 +2,9 @@ TABLE_SCHEM TABLE_CATALOG PartsSupplier PartsSupplier SYS PartsSupplier +SYSADMIN PartsSupplier pg_catalog PartsSupplier -Row Count : 3 +Row Count : 4 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_SCHEM 12 PartsSupplier java.lang.String TABLE_SCHEM string SYS Schemas 255 255 0 false true false true 1 false true true true TABLE_CATALOG 12 PartsSupplier java.lang.String TABLE_CATALOG string SYS Schemas 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testTables.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testTables.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testTables.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -4,7 +4,6 @@ PartsSupplier SYS DataTypes SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS KeyColumns SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS Keys SYSTEM TABLE <null> <null> <null> <null> <null> <null> true -PartsSupplier SYS MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS ProcedureParams SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS Procedures SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS Properties SYSTEM TABLE <null> <null> <null> <null> <null> <null> true @@ -12,6 +11,7 @@ PartsSupplier SYS Schemas SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS Tables SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier SYS VirtualDatabases SYSTEM TABLE <null> <null> <null> <null> <null> <null> true +PartsSupplier SYSADMIN MatViews SYSTEM TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier pg_catalog pg_am SYSTEM TABLE <null> <null> <null> <null> <null> <null> false PartsSupplier pg_catalog pg_attrdef SYSTEM TABLE <null> <null> <null> <null> <null> <null> false PartsSupplier pg_catalog pg_attribute SYSTEM TABLE <null> <null> <null> <null> <null> <null> false @@ -28,7 +28,8 @@ PartsSupplier PartsSupplier PARTSSUPPLIER.STATUS TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER TABLE <null> <null> <null> <null> <null> <null> true PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER_PARTS TABLE <null> <null> <null> <null> <null> <null> true -Row Count : 28 +PartsSupplier SYSADMIN VDBResources TABLE <null> <null> <null> <null> <null> <null> true +Row Count : 29 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable TABLE_CAT 12 PartsSupplier java.lang.String TABLE_CAT string SYS Tables 255 255 0 false true false true 1 false true true true TABLE_SCHEM 12 PartsSupplier java.lang.String TABLE_SCHEM string SYS Tables 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testColumns.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testColumns.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testColumns.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,105 +1,105 @@ string string string string integer string string integer integer boolean boolean boolean boolean boolean boolean boolean string string string string string string string integer integer integer string ! string integer VDBName SchemaName TableName Name Position NameInSource DataType Scale Length IsLengthFixed SupportsSelect SupportsUpdates IsCaseSensitive IsSigned IsCurrency IsAutoIncremented NullType MinRange MaxRange SearchType Format DefaultValue JavaClass Precision CharOctetLength Radix UID ! Description OID -PartsSupplier SYS DataTypes BaseType 17 <null> string 0 64 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 64 64 10 mmuuid:03beb57c-968b-4821-a6ae-cb1154cfadee ! <null> 62 -PartsSupplier SYS MatViews Cardinality 9 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:c20875ac-5df8-4a3f-89af-c766af8f81b6 ! <null> 94 -PartsSupplier SYS Tables Cardinality 9 <null> integer 0 10 false true false true true false false No Nulls <null> <null> All Except Like <null> <null> java.lang.Integer 10 10 10 mmuuid:24cdad3a-e8f7-4376-bb32-79f8bc8eeed2 ! <null> 152 -PartsSupplier SYS Columns CharOctetLength 25 <null> integer 0 10 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:de5def94-2804-4c91-91ed-26d630ce8afe ! <null> 41 -PartsSupplier SYS ReferenceKeyColumns DEFERRABILITY 14 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:88380f55-2cbd-4325-b9a3-9dcaa88a690e ! <null> 136 -PartsSupplier SYS ReferenceKeyColumns DELETE_RULE 11 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:9207f4df-a5ce-43bd-b3b2-fee57e459849 ! <null> 133 -PartsSupplier SYS Columns DataType 7 <null> string 0 100 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:9a8dc0d5-e65c-4032-a066-187f8d2e73ea ! <null> 23 -PartsSupplier SYS ProcedureParams DataType 5 <null> string 0 25 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 25 25 10 mmuuid:207a09af-65b8-405f-b1cb-537bc8632fa4 ! <null> 99 -PartsSupplier SYS Columns DefaultValue 22 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:7e853988-356b-4c7c-83d4-a9f015bff279 ! <null> 38 -PartsSupplier SYS Columns Description 28 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:74d73b53-b723-419e-9fea-de56408409ee ! <null> 44 -PartsSupplier SYS DataTypes Description 18 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:b7d95ef6-63a3-441c-8de5-c98e2e577ea3 ! <null> 63 -PartsSupplier SYS Keys Description 5 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:175e21b2-24c3-4677-a253-6d7cdb513a9a ! <null> 79 -PartsSupplier SYS ProcedureParams Description 15 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:05ac4703-5c2c-4410-93b7-19b39d90c803 ! <null> 109 -PartsSupplier SYS Procedures Description 7 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 225 255 10 mmuuid:fa0b5db7-acb1-4975-8410-d5d27df46040 ! <null> 117 -PartsSupplier SYS Schemas Description 5 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:1cb99300-a527-4a26-b4e6-08ebd92a781d ! <null> 141 -PartsSupplier SYS Tables Description 10 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:51605e41-5cb0-40ca-8c4a-4eca52780afc ! <null> 153 -PartsSupplier SYS ReferenceKeyColumns FKCOLUMN_NAME 8 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:f4b2b32c-e411-45e6-a236-fec4718f0874 ! <null> 130 -PartsSupplier SYS ReferenceKeyColumns FKTABLE_CAT 5 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 1 255 10 mmuuid:a0095da3-1258-44dc-bab9-33eacf886a28 ! <null> 127 -PartsSupplier SYS ReferenceKeyColumns FKTABLE_NAME 7 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:53284aaa-4c07-4930-8a0e-5e2aaa2da5cb ! <null> 129 -PartsSupplier SYS ReferenceKeyColumns FKTABLE_SCHEM 6 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:93a35adf-b6b1-4d9c-bdef-d336a84f478e ! <null> 128 -PartsSupplier SYS ReferenceKeyColumns FK_NAME 12 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:a9ca7516-6898-419d-b1ad-7d174d946d07 ! <null> 134 -PartsSupplier SYS Columns Format 21 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:172b133e-5bf1-4020-953c-de4446b1e64a ! <null> 37 -PartsSupplier SYS Columns IsAutoIncremented 16 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:0d41e284-f274-4fd1-8576-7696f4b758d0 ! <null> 32 -PartsSupplier SYS DataTypes IsAutoIncremented 10 <null> boolean 0 1 true true false true true false false No Nulls <null> <null> Searchable <null> ('0') java.lang.Boolean 1 1 10 mmuuid:2a1568e2-776a-474b-981f-040a6ad63361 ! <null> 55 -PartsSupplier SYS Columns IsCaseSensitive 13 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:21ee166a-b462-41a1-b88d-dc79f63d6e17 ! <null> 29 -PartsSupplier SYS DataTypes IsCaseSensitive 11 <null> boolean 0 1 true true false true false false false No Nulls <null> <null> Searchable <null> ('0') java.lang.Boolean 1 1 10 mmuuid:1468aaf2-6481-4d10-9554-44d0363fe571 ! <null> 56 -PartsSupplier SYS Columns IsCurrency 15 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:b28a2963-36e0-4b4a-a8f8-a2c06f2b440a ! <null> 31 -PartsSupplier SYS Keys IsIndexed 8 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:ea96cb7c-2dcf-453c-b83a-1aaa921d8f92 ! <null> 82 -PartsSupplier SYS Columns IsLengthFixed 10 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:571aa4ce-3254-4a2b-aa48-1cb23a0c47ed ! <null> 26 -PartsSupplier SYS Tables IsMaterialized 12 <null> boolean 0 0 false true true false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 10 mmuuid:89265cba-ab85-48c2-960a-a5a9594ba6d0 ! <null> 155 -PartsSupplier SYS DataTypes IsPhysical 3 <null> boolean 0 1 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:983714a2-bd0b-4fad-b4e8-dfb7832e9c4b ! <null> 48 -PartsSupplier SYS Schemas IsPhysical 3 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:bab257d7-cced-4605-9b40-8ca6c078aca7 ! <null> 139 -PartsSupplier SYS Tables IsPhysical 6 <null> boolean 0 1 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:e27712f6-a0a6-452e-848d-9de77691e939 ! <null> 149 -PartsSupplier SYS Columns IsSigned 14 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:36be2afa-8ebc-4af8-acc5-a887cf2b5a86 ! <null> 30 -PartsSupplier SYS DataTypes IsSigned 9 <null> boolean 0 1 true true false true false false false No Nulls <null> <null> Searchable <null> ('0') java.lang.Boolean 1 1 10 mmuuid:235cea48-b2b9-41d5-b296-8ab9c649b6e7 ! <null> 54 -PartsSupplier SYS DataTypes IsStandard 2 <null> boolean 0 1 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:02f27c5d-af55-4677-b91b-8690793671b2 ! <null> 47 -PartsSupplier SYS Tables IsSystem 11 <null> boolean 0 1 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:9fa7987c-7dc8-4102-9cc0-5658d5b46382 ! <null> 154 -PartsSupplier SYS Columns JavaClass 23 <null> string 0 500 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 500 500 10 mmuuid:6b8d5df5-7bd2-425c-8b2b-e427e026ef66 ! <null> 39 -PartsSupplier SYS DataTypes JavaClass 5 <null> string 0 500 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 500 500 10 mmuuid:4c68ef90-8042-44ab-896a-bb3890a8fe04 ! <null> 50 -PartsSupplier SYS ReferenceKeyColumns KEY_SEQ 9 <null> short 0 5 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Short 5 5 10 mmuuid:4884ac83-84ed-4b67-9f1a-bd79c0199269 ! <null> 131 -PartsSupplier SYS KeyColumns KeyName 5 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:da4bef58-83f4-4b88-8bb0-2dc8990be539 ! <null> 69 -PartsSupplier SYS KeyColumns KeyType 6 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:df9e15e6-ab77-486d-bfe0-0adc378aa99d ! <null> 70 -PartsSupplier SYS Columns Length 9 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:b36ea0f6-cbff-4049-bc9c-8ec9928be048 ! <null> 25 -PartsSupplier SYS MatViews LoadState 7 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:d730c1a8-a8b1-4912-957d-f310506ec93b ! <null> 92 -PartsSupplier SYS Columns MaxRange 19 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:0b0df4a5-7de5-4315-94f7-22c84958302e ! <null> 35 -PartsSupplier SYS Columns MinRange 18 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:dba0f97d-fab5-45f6-a1eb-3459ab3fcc74 ! <null> 34 -PartsSupplier SYS Columns Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:d1f44a6d-3e39-4251-b873-1280c2b035b3 ! <null> 20 -PartsSupplier SYS DataTypes Name 1 <null> string 0 100 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:17f7de33-e6f0-4b9c-b55e-a87f6b7bb9b3 ! <null> 46 -PartsSupplier SYS KeyColumns Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:08bda0c7-5f66-4fed-8285-d74b63eeb0e2 ! <null> 68 -PartsSupplier SYS Keys Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:149de302-2107-45ca-839d-fc0dd1e7d7f4 ! <null> 78 -PartsSupplier SYS MatViews Name 3 <null> string 0 255 false true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:75bd4c7c-71f9-44ee-be3a-16f82af5dec7 ! <null> 88 -PartsSupplier SYS ProcedureParams Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:2bf20c6f-5a95-436d-8f30-a24d164e77a4 ! <null> 98 -PartsSupplier SYS Procedures Name 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:bd17e98a-c40a-43b1-93ac-88d62937c051 ! <null> 113 -PartsSupplier SYS Properties Name 1 <null> string 0 255 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ba007c56-04b6-4981-ab89-3fdd33ff0de8 ! <null> 119 -PartsSupplier SYS Schemas Name 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:654112f8-bb4c-4453-9e4d-f3a96fba61ec ! <null> 138 -PartsSupplier SYS Tables Name 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ef487cc2-1214-439c-af6e-da431df00d2c ! <null> 146 -PartsSupplier SYS VirtualDatabases Name 1 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:42fa1249-8b24-4aae-a252-0a347db6ec30 ! <null> 157 -PartsSupplier SYS Columns NameInSource 6 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:fac72c6e-41dc-4a1b-8af3-f0796690d9cc ! <null> 22 -PartsSupplier SYS Keys NameInSource 6 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:a52a6169-99e0-4b7e-9dc6-3a93ffa6094a ! <null> 80 -PartsSupplier SYS Procedures NameInSource 4 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:a4e7a0fd-c340-49a9-9ac0-8328caaffda8 ! <null> 114 -PartsSupplier SYS Tables NameInSource 5 <null> string 0 255 true true false true false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:1f036fb0-b841-450c-8462-986cdd57e921 ! <null> 148 -PartsSupplier SYS Columns NullType 17 <null> string 0 20 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:4d83bdbb-a7ce-44cc-a201-021a517d3c1a ! <null> 33 -PartsSupplier SYS DataTypes NullType 8 <null> string 0 20 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:278b0534-1164-495e-a8c6-de45e0ff53a4 ! <null> 53 -PartsSupplier SYS ProcedureParams NullType 13 <null> string 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 10 10 10 mmuuid:d887c203-6bf5-462b-b2f0-f5302e2f4bcd ! <null> 107 -PartsSupplier SYS Columns OID 29 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:b9e5ba07-4a8d-4589-8aa9-597ae70d18a4 ! <null> 45 -PartsSupplier SYS DataTypes OID 19 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:a3c41050-80b6-4fb5-9c6b-5e20c0839cda ! <null> 64 -PartsSupplier SYS KeyColumns OID 10 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:207d123c-a3ff-4e4e-85ae-6f3b0debfc06 ! <null> 74 -PartsSupplier SYS Keys OID 11 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:d781f893-bdf3-4dc1-956f-7e7b1a138c99 ! <null> 85 -PartsSupplier SYS ProcedureParams OID 16 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:72125f93-846f-413c-82e1-fa3227fb043f ! <null> 110 -PartsSupplier SYS Procedures OID 8 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:c80c02d2-7174-4cc4-b347-e921a80f568c ! <null> 118 -PartsSupplier SYS Properties OID 4 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:54c1a7dc-5ca8-4d34-8672-e76d63fe3b95 ! <null> 122 -PartsSupplier SYS Schemas OID 7 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:31746839-e019-4321-90cb-a557e1d4754e ! <null> 143 -PartsSupplier SYS Tables OID 13 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:dae79c58-b381-4275-8c1c-b299d732d355 ! <null> 156 -PartsSupplier SYS ProcedureParams Optional 8 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:4033f891-5ef5-4a75-8a50-bd1d021e43ad ! <null> 102 +PartsSupplier SYS DataTypes BaseType 17 <null> string 0 64 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 64 64 10 mmuuid:03beb57c-968b-4821-a6ae-cb1154cfadee ! <null> 73 +PartsSupplier SYSADMIN MatViews Cardinality 9 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:abe699b0-b6bc-4413-9172-0a21ca9664d2 ! <null> 25 +PartsSupplier SYS Tables Cardinality 9 <null> integer 0 10 false true false true true false false No Nulls <null> <null> All Except Like <null> <null> java.lang.Integer 10 10 10 mmuuid:24cdad3a-e8f7-4376-bb32-79f8bc8eeed2 ! <null> 154 +PartsSupplier SYS Columns CharOctetLength 25 <null> integer 0 10 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:de5def94-2804-4c91-91ed-26d630ce8afe ! <null> 52 +PartsSupplier SYS ReferenceKeyColumns DEFERRABILITY 14 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:88380f55-2cbd-4325-b9a3-9dcaa88a690e ! <null> 138 +PartsSupplier SYS ReferenceKeyColumns DELETE_RULE 11 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:9207f4df-a5ce-43bd-b3b2-fee57e459849 ! <null> 135 +PartsSupplier SYS Columns DataType 7 <null> string 0 100 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:9a8dc0d5-e65c-4032-a066-187f8d2e73ea ! <null> 34 +PartsSupplier SYS ProcedureParams DataType 5 <null> string 0 25 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 25 25 10 mmuuid:207a09af-65b8-405f-b1cb-537bc8632fa4 ! <null> 101 +PartsSupplier SYS Columns DefaultValue 22 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:7e853988-356b-4c7c-83d4-a9f015bff279 ! <null> 49 +PartsSupplier SYS Columns Description 28 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:74d73b53-b723-419e-9fea-de56408409ee ! <null> 55 +PartsSupplier SYS DataTypes Description 18 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:b7d95ef6-63a3-441c-8de5-c98e2e577ea3 ! <null> 74 +PartsSupplier SYS Keys Description 5 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:175e21b2-24c3-4677-a253-6d7cdb513a9a ! <null> 90 +PartsSupplier SYS ProcedureParams Description 15 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:05ac4703-5c2c-4410-93b7-19b39d90c803 ! <null> 111 +PartsSupplier SYS Procedures Description 7 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 225 255 10 mmuuid:fa0b5db7-acb1-4975-8410-d5d27df46040 ! <null> 119 +PartsSupplier SYS Schemas Description 5 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:1cb99300-a527-4a26-b4e6-08ebd92a781d ! <null> 143 +PartsSupplier SYS Tables Description 10 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:51605e41-5cb0-40ca-8c4a-4eca52780afc ! <null> 155 +PartsSupplier SYS ReferenceKeyColumns FKCOLUMN_NAME 8 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:f4b2b32c-e411-45e6-a236-fec4718f0874 ! <null> 132 +PartsSupplier SYS ReferenceKeyColumns FKTABLE_CAT 5 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 1 255 10 mmuuid:a0095da3-1258-44dc-bab9-33eacf886a28 ! <null> 129 +PartsSupplier SYS ReferenceKeyColumns FKTABLE_NAME 7 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:53284aaa-4c07-4930-8a0e-5e2aaa2da5cb ! <null> 131 +PartsSupplier SYS ReferenceKeyColumns FKTABLE_SCHEM 6 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:93a35adf-b6b1-4d9c-bdef-d336a84f478e ! <null> 130 +PartsSupplier SYS ReferenceKeyColumns FK_NAME 12 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:a9ca7516-6898-419d-b1ad-7d174d946d07 ! <null> 136 +PartsSupplier SYS Columns Format 21 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:172b133e-5bf1-4020-953c-de4446b1e64a ! <null> 48 +PartsSupplier SYS Columns IsAutoIncremented 16 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:0d41e284-f274-4fd1-8576-7696f4b758d0 ! <null> 43 +PartsSupplier SYS DataTypes IsAutoIncremented 10 <null> boolean 0 1 true true false true true false false No Nulls <null> <null> Searchable <null> ('0') java.lang.Boolean 1 1 10 mmuuid:2a1568e2-776a-474b-981f-040a6ad63361 ! <null> 66 +PartsSupplier SYS Columns IsCaseSensitive 13 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:21ee166a-b462-41a1-b88d-dc79f63d6e17 ! <null> 40 +PartsSupplier SYS DataTypes IsCaseSensitive 11 <null> boolean 0 1 true true false true false false false No Nulls <null> <null> Searchable <null> ('0') java.lang.Boolean 1 1 10 mmuuid:1468aaf2-6481-4d10-9554-44d0363fe571 ! <null> 67 +PartsSupplier SYS Columns IsCurrency 15 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:b28a2963-36e0-4b4a-a8f8-a2c06f2b440a ! <null> 42 +PartsSupplier SYS Keys IsIndexed 8 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:ea96cb7c-2dcf-453c-b83a-1aaa921d8f92 ! <null> 93 +PartsSupplier SYS Columns IsLengthFixed 10 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:571aa4ce-3254-4a2b-aa48-1cb23a0c47ed ! <null> 37 +PartsSupplier SYS Tables IsMaterialized 12 <null> boolean 0 0 false true true false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 10 mmuuid:89265cba-ab85-48c2-960a-a5a9594ba6d0 ! <null> 157 +PartsSupplier SYS DataTypes IsPhysical 3 <null> boolean 0 1 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:983714a2-bd0b-4fad-b4e8-dfb7832e9c4b ! <null> 59 +PartsSupplier SYS Schemas IsPhysical 3 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:bab257d7-cced-4605-9b40-8ca6c078aca7 ! <null> 141 +PartsSupplier SYS Tables IsPhysical 6 <null> boolean 0 1 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:e27712f6-a0a6-452e-848d-9de77691e939 ! <null> 151 +PartsSupplier SYS Columns IsSigned 14 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:36be2afa-8ebc-4af8-acc5-a887cf2b5a86 ! <null> 41 +PartsSupplier SYS DataTypes IsSigned 9 <null> boolean 0 1 true true false true false false false No Nulls <null> <null> Searchable <null> ('0') java.lang.Boolean 1 1 10 mmuuid:235cea48-b2b9-41d5-b296-8ab9c649b6e7 ! <null> 65 +PartsSupplier SYS DataTypes IsStandard 2 <null> boolean 0 1 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:02f27c5d-af55-4677-b91b-8690793671b2 ! <null> 58 +PartsSupplier SYS Tables IsSystem 11 <null> boolean 0 1 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:9fa7987c-7dc8-4102-9cc0-5658d5b46382 ! <null> 156 +PartsSupplier SYS Columns JavaClass 23 <null> string 0 500 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 500 500 10 mmuuid:6b8d5df5-7bd2-425c-8b2b-e427e026ef66 ! <null> 50 +PartsSupplier SYS DataTypes JavaClass 5 <null> string 0 500 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 500 500 10 mmuuid:4c68ef90-8042-44ab-896a-bb3890a8fe04 ! <null> 61 +PartsSupplier SYS ReferenceKeyColumns KEY_SEQ 9 <null> short 0 5 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Short 5 5 10 mmuuid:4884ac83-84ed-4b67-9f1a-bd79c0199269 ! <null> 133 +PartsSupplier SYS KeyColumns KeyName 5 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:da4bef58-83f4-4b88-8bb0-2dc8990be539 ! <null> 80 +PartsSupplier SYS KeyColumns KeyType 6 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:df9e15e6-ab77-486d-bfe0-0adc378aa99d ! <null> 81 +PartsSupplier SYS Columns Length 9 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:b36ea0f6-cbff-4049-bc9c-8ec9928be048 ! <null> 36 +PartsSupplier SYSADMIN MatViews LoadState 7 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:c67365c3-f252-40f4-aae6-8971d3b1b153 ! <null> 23 +PartsSupplier SYS Columns MaxRange 19 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:0b0df4a5-7de5-4315-94f7-22c84958302e ! <null> 46 +PartsSupplier SYS Columns MinRange 18 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:dba0f97d-fab5-45f6-a1eb-3459ab3fcc74 ! <null> 45 +PartsSupplier SYSADMIN MatViews Name 3 <null> string 0 255 false true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:0f56d35c-e450-4b4f-86b0-bdb4f1015c57 ! <null> 19 +PartsSupplier SYS Columns Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:d1f44a6d-3e39-4251-b873-1280c2b035b3 ! <null> 31 +PartsSupplier SYS DataTypes Name 1 <null> string 0 100 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:17f7de33-e6f0-4b9c-b55e-a87f6b7bb9b3 ! <null> 57 +PartsSupplier SYS KeyColumns Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:08bda0c7-5f66-4fed-8285-d74b63eeb0e2 ! <null> 79 +PartsSupplier SYS Keys Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:149de302-2107-45ca-839d-fc0dd1e7d7f4 ! <null> 89 +PartsSupplier SYS ProcedureParams Name 4 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:2bf20c6f-5a95-436d-8f30-a24d164e77a4 ! <null> 100 +PartsSupplier SYS Procedures Name 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:bd17e98a-c40a-43b1-93ac-88d62937c051 ! <null> 115 +PartsSupplier SYS Properties Name 1 <null> string 0 255 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ba007c56-04b6-4981-ab89-3fdd33ff0de8 ! <null> 121 +PartsSupplier SYS Schemas Name 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:654112f8-bb4c-4453-9e4d-f3a96fba61ec ! <null> 140 +PartsSupplier SYS Tables Name 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ef487cc2-1214-439c-af6e-da431df00d2c ! <null> 148 +PartsSupplier SYS VirtualDatabases Name 1 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:42fa1249-8b24-4aae-a252-0a347db6ec30 ! <null> 159 +PartsSupplier SYS Columns NameInSource 6 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:fac72c6e-41dc-4a1b-8af3-f0796690d9cc ! <null> 33 +PartsSupplier SYS Keys NameInSource 6 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:a52a6169-99e0-4b7e-9dc6-3a93ffa6094a ! <null> 91 +PartsSupplier SYS Procedures NameInSource 4 <null> string 0 255 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:a4e7a0fd-c340-49a9-9ac0-8328caaffda8 ! <null> 116 +PartsSupplier SYS Tables NameInSource 5 <null> string 0 255 true true false true false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:1f036fb0-b841-450c-8462-986cdd57e921 ! <null> 150 +PartsSupplier SYS Columns NullType 17 <null> string 0 20 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:4d83bdbb-a7ce-44cc-a201-021a517d3c1a ! <null> 44 +PartsSupplier SYS DataTypes NullType 8 <null> string 0 20 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:278b0534-1164-495e-a8c6-de45e0ff53a4 ! <null> 64 +PartsSupplier SYS ProcedureParams NullType 13 <null> string 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 10 10 10 mmuuid:d887c203-6bf5-462b-b2f0-f5302e2f4bcd ! <null> 109 +PartsSupplier SYS Columns OID 29 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:b9e5ba07-4a8d-4589-8aa9-597ae70d18a4 ! <null> 56 +PartsSupplier SYS DataTypes OID 19 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:a3c41050-80b6-4fb5-9c6b-5e20c0839cda ! <null> 75 +PartsSupplier SYS KeyColumns OID 10 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:207d123c-a3ff-4e4e-85ae-6f3b0debfc06 ! <null> 85 +PartsSupplier SYS Keys OID 11 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:d781f893-bdf3-4dc1-956f-7e7b1a138c99 ! <null> 96 +PartsSupplier SYS ProcedureParams OID 16 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:72125f93-846f-413c-82e1-fa3227fb043f ! <null> 112 +PartsSupplier SYS Procedures OID 8 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:c80c02d2-7174-4cc4-b347-e921a80f568c ! <null> 120 +PartsSupplier SYS Properties OID 4 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:54c1a7dc-5ca8-4d34-8672-e76d63fe3b95 ! <null> 124 +PartsSupplier SYS Schemas OID 7 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:31746839-e019-4321-90cb-a557e1d4754e ! <null> 145 +PartsSupplier SYS Tables OID 13 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:dae79c58-b381-4275-8c1c-b299d732d355 ! <null> 158 +PartsSupplier SYS ProcedureParams Optional 8 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:4033f891-5ef5-4a75-8a50-bd1d021e43ad ! <null> 104 PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_COLOR 3 PART_COLOR string 0 30 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 30 10 mmuuid:015c0d00-73ff-1edc-a81c-ecf397b10590 ! <null> 2 PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_ID 1 PART_ID string 0 4 true true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 4 10 mmuuid:fadcd7c0-73fe-1edc-a81c-ecf397b10590 ! <null> 0 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER_PARTS PART_ID 2 PART_ID string 0 4 true true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 4 10 mmuuid:3fc400c0-73ff-1edc-a81c-ecf397b10590 ! <null> 9 PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_NAME 2 PART_NAME string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:0067e900-73ff-1edc-a81c-ecf397b10590 ! <null> 1 PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS PART_WEIGHT 4 PART_WEIGHT string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:015c0d01-73ff-1edc-a81c-ecf397b10590 ! <null> 3 -PartsSupplier SYS ReferenceKeyColumns PKCOLUMN_NAME 4 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:0125a80a-95f9-486f-aa90-debb21cb5f1b ! <null> 126 -PartsSupplier SYS ReferenceKeyColumns PKTABLE_CAT 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 1 255 10 mmuuid:f615a661-2c36-4ab1-b72b-5e13e99e052c ! <null> 123 -PartsSupplier SYS ReferenceKeyColumns PKTABLE_NAME 3 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:6d420bc2-0f85-4da9-833d-d71b428b0743 ! <null> 125 -PartsSupplier SYS ReferenceKeyColumns PKTABLE_SCHEM 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ef7b3b79-fb51-42ef-a723-080ed0a6e3bc ! <null> 124 -PartsSupplier SYS ReferenceKeyColumns PK_NAME 13 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ac210a6d-4de6-4d71-aa9b-e3d34baca81a ! <null> 135 -PartsSupplier SYS Columns Position 5 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:dbc8cd09-1b47-43c5-82ec-aba525b85cc4 ! <null> 21 -PartsSupplier SYS KeyColumns Position 9 <null> integer 0 10 true true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:92a4849c-ed0e-4f5f-a108-d7d71a5aba25 ! <null> 73 -PartsSupplier SYS ProcedureParams Position 6 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:5fdefd17-65f4-4350-9ee0-0ed3c34d10ae ! <null> 100 -PartsSupplier SYS Columns Precision 24 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:db3d49e2-fe1d-438b-8d07-847bf58506ab ! <null> 40 -PartsSupplier SYS DataTypes Precision 12 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:8673c810-7162-4331-ba0b-6fc3530d2d1c ! <null> 57 -PartsSupplier SYS ProcedureParams Precision 9 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:00fe7cad-0a83-42f0-90f2-d6a9584916b2 ! <null> 103 -PartsSupplier SYS Schemas PrimaryMetamodelURI 6 <null> string 0 255 false true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:eadfaba5-ce44-4529-816f-6af94666baec ! <null> 142 -PartsSupplier SYS ProcedureParams ProcedureName 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:8081b3a6-fc79-42fd-b7c9-a19d682a1658 ! <null> 97 +PartsSupplier SYS ReferenceKeyColumns PKCOLUMN_NAME 4 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:0125a80a-95f9-486f-aa90-debb21cb5f1b ! <null> 128 +PartsSupplier SYS ReferenceKeyColumns PKTABLE_CAT 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 1 255 10 mmuuid:f615a661-2c36-4ab1-b72b-5e13e99e052c ! <null> 125 +PartsSupplier SYS ReferenceKeyColumns PKTABLE_NAME 3 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:6d420bc2-0f85-4da9-833d-d71b428b0743 ! <null> 127 +PartsSupplier SYS ReferenceKeyColumns PKTABLE_SCHEM 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ef7b3b79-fb51-42ef-a723-080ed0a6e3bc ! <null> 126 +PartsSupplier SYS ReferenceKeyColumns PK_NAME 13 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:ac210a6d-4de6-4d71-aa9b-e3d34baca81a ! <null> 137 +PartsSupplier SYS Columns Position 5 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:dbc8cd09-1b47-43c5-82ec-aba525b85cc4 ! <null> 32 +PartsSupplier SYS KeyColumns Position 9 <null> integer 0 10 true true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:92a4849c-ed0e-4f5f-a108-d7d71a5aba25 ! <null> 84 +PartsSupplier SYS ProcedureParams Position 6 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:5fdefd17-65f4-4350-9ee0-0ed3c34d10ae ! <null> 102 +PartsSupplier SYS Columns Precision 24 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:db3d49e2-fe1d-438b-8d07-847bf58506ab ! <null> 51 +PartsSupplier SYS DataTypes Precision 12 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:8673c810-7162-4331-ba0b-6fc3530d2d1c ! <null> 68 +PartsSupplier SYS ProcedureParams Precision 9 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:00fe7cad-0a83-42f0-90f2-d6a9584916b2 ! <null> 105 +PartsSupplier SYS Schemas PrimaryMetamodelURI 6 <null> string 0 255 false true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:eadfaba5-ce44-4529-816f-6af94666baec ! <null> 144 +PartsSupplier SYS ProcedureParams ProcedureName 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:8081b3a6-fc79-42fd-b7c9-a19d682a1658 ! <null> 99 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER_PARTS QUANTITY 3 QUANTITY short 0 0 true true true false true false false Nullable <null> <null> All Except Like <null> <null> java.lang.Short 3 0 10 mmuuid:3fc400c1-73ff-1edc-a81c-ecf397b10590 ! <null> 10 -PartsSupplier SYS Columns Radix 26 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:43a6124c-972f-4c4c-af05-24080c2a8ad7 ! <null> 42 -PartsSupplier SYS DataTypes Radix 13 <null> integer 0 10 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:967ab8fd-3226-4a78-8cf2-2eb7fbf2981a ! <null> 58 -PartsSupplier SYS ProcedureParams Radix 12 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:8df37c99-3b12-4789-8128-4aa496f895c4 ! <null> 106 -PartsSupplier SYS KeyColumns RefKeyUID 7 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:aafbdf50-25aa-427b-b322-7cb36094a1e2 ! <null> 71 -PartsSupplier SYS Keys RefKeyUID 9 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:1cf4c5ad-5932-47ec-8593-385b75bfeba8 ! <null> 83 -PartsSupplier SYS Procedures ReturnsResults 5 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:b01164c8-dd10-410d-a91b-fcb2fc0450ce ! <null> 115 -PartsSupplier SYS DataTypes RuntimeType 16 <null> string 0 64 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 64 64 10 mmuuid:3c7bc9d0-b73f-49a0-b9ab-dc97a4d2a124 ! <null> 61 +PartsSupplier SYS Columns Radix 26 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:43a6124c-972f-4c4c-af05-24080c2a8ad7 ! <null> 53 +PartsSupplier SYS DataTypes Radix 13 <null> integer 0 10 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:967ab8fd-3226-4a78-8cf2-2eb7fbf2981a ! <null> 69 +PartsSupplier SYS ProcedureParams Radix 12 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:8df37c99-3b12-4789-8128-4aa496f895c4 ! <null> 108 +PartsSupplier SYS KeyColumns RefKeyUID 7 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:aafbdf50-25aa-427b-b322-7cb36094a1e2 ! <null> 82 +PartsSupplier SYS Keys RefKeyUID 9 <null> string 0 50 true true false false false false false Nullable <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:1cf4c5ad-5932-47ec-8593-385b75bfeba8 ! <null> 94 +PartsSupplier SYS Procedures ReturnsResults 5 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:b01164c8-dd10-410d-a91b-fcb2fc0450ce ! <null> 117 +PartsSupplier SYS DataTypes RuntimeType 16 <null> string 0 64 true true false true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 64 64 10 mmuuid:3c7bc9d0-b73f-49a0-b9ab-dc97a4d2a124 ! <null> 72 PartsSupplier PartsSupplier PARTSSUPPLIER.SHIP_VIA SHIPPER_ID 1 SHIPPER_ID short 0 0 true true true false true false false No Nulls <null> <null> All Except Like <null> <null> java.lang.Short 2 0 10 mmuuid:121bc540-73ff-1edc-a81c-ecf397b10590 ! <null> 4 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER_PARTS SHIPPER_ID 4 SHIPPER_ID short 0 0 true true true false true false false Nullable <null> <null> All Except Like <null> <null> java.lang.Short 2 0 10 mmuuid:3fc400c2-73ff-1edc-a81c-ecf397b10590 ! <null> 11 PartsSupplier PartsSupplier PARTSSUPPLIER.SHIP_VIA SHIPPER_NAME 2 SHIPPER_NAME string 0 30 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 30 10 mmuuid:130fe940-73ff-1edc-a81c-ecf397b10590 ! <null> 5 @@ -111,130 +111,132 @@ PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER SUPPLIER_NAME 2 SUPPLIER_NAME string 0 30 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 30 10 mmuuid:2f044881-73ff-1edc-a81c-ecf397b10590 ! <null> 13 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER SUPPLIER_STATE 5 SUPPLIER_STATE string 0 2 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 2 10 mmuuid:2fe92a41-73ff-1edc-a81c-ecf397b10590 ! <null> 16 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER SUPPLIER_STATUS 3 SUPPLIER_STATUS short 0 0 true true true false true false false Nullable <null> <null> All Except Like <null> <null> java.lang.Short 2 0 10 mmuuid:2f044882-73ff-1edc-a81c-ecf397b10590 ! <null> 14 -PartsSupplier SYS Columns Scale 8 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:cc6c6113-8d70-40c8-84c0-94e17c14e22e ! <null> 24 -PartsSupplier SYS DataTypes Scale 6 <null> integer 0 10 true true false false false false false Nullable <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:e8655204-e97a-45cd-909b-1e37731e9546 ! <null> 51 -PartsSupplier SYS ProcedureParams Scale 11 <null> integer 0 10 true true true false false false false No Nulls <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:360c8b1d-4b3d-42fd-952c-bf5763cad69e ! <null> 105 -PartsSupplier SYS Columns SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:859288c9-cd78-4407-90fc-61b5d310e2ab ! <null> 18 -PartsSupplier SYS KeyColumns SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:787be966-cf12-4956-907f-a8e6dc1009dc ! <null> 66 -PartsSupplier SYS Keys SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:4a7fc059-208e-4f98-b6ef-cb7c6102a327 ! <null> 76 -PartsSupplier SYS MatViews SchemaName 2 <null> string 0 255 false true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:ee14b6ad-9b87-41e5-8eb5-90262f9e0ec4 ! <null> 87 -PartsSupplier SYS ProcedureParams SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:88497911-619c-4ca8-b482-8885d940706a ! <null> 96 -PartsSupplier SYS Procedures SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:53a84865-334e-4750-b343-de2411d56e3e ! <null> 112 -PartsSupplier SYS Tables SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:95bd960c-fd84-44c9-9831-692376f69b46 ! <null> 145 -PartsSupplier SYS Columns SearchType 20 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:3037138a-bb20-4485-ba01-75bc20b1a532 ! <null> 36 -PartsSupplier SYS DataTypes SearchType 14 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:d8494fa3-40e4-44cd-b0d8-da5c83685a75 ! <null> 59 -PartsSupplier SYS Columns SupportsSelect 11 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:c2a50f93-0040-41ec-ad7b-e8511296555f ! <null> 27 -PartsSupplier SYS Columns SupportsUpdates 12 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:fab660d1-36bf-4a5b-bbe6-9a543e0ebd76 ! <null> 28 -PartsSupplier SYS Tables SupportsUpdates 7 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:5144d230-2b0e-4255-b321-65b9f6f6f76c ! <null> 150 -PartsSupplier SYS Columns TableName 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:2c09c9d1-2f25-45de-81cf-eeb2a5157d34 ! <null> 19 -PartsSupplier SYS KeyColumns TableName 3 <null> string 0 2048 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 2048 2048 10 mmuuid:c24fad72-0c0d-4260-96ae-f188ad77b137 ! <null> 67 -PartsSupplier SYS Keys TableName 3 <null> string 0 2048 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 2048 2048 10 mmuuid:7d9540bd-b51f-4206-8c33-b39c5ba8bb8b ! <null> 77 -PartsSupplier SYS MatViews TargetName 5 <null> string 0 4000 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 4000 10 mmuuid:9433bf0c-1046-4b83-9539-862fc0e190c6 ! <null> 90 -PartsSupplier SYS MatViews TargetSchemaName 4 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:544b39f9-5243-43ce-a0cb-747d91fc5c5e ! <null> 89 -PartsSupplier SYS Keys Type 7 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:29e73c18-afec-43a9-81ab-7378d6daf20b ! <null> 81 -PartsSupplier SYS ProcedureParams Type 7 <null> string 0 100 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:76a1981b-1226-4a55-9acf-82a061cc8642 ! <null> 101 -PartsSupplier SYS Tables Type 4 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:4814a0af-4e8f-4f55-9b25-3148d90d3d9b ! <null> 147 -PartsSupplier SYS DataTypes TypeLength 7 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:0668382a-f9c3-4507-8b0f-df65a2ebbf2f ! <null> 52 -PartsSupplier SYS ProcedureParams TypeLength 10 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:791d7a29-8fc5-4735-9144-1accc114b58e ! <null> 104 -PartsSupplier SYS DataTypes TypeName 4 <null> string 0 100 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:48081cdd-9e90-4440-a956-4a32af96d7f4 ! <null> 49 -PartsSupplier SYS Columns UID 27 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:5f491c75-769b-4908-9f68-2a9a486607bb ! <null> 43 -PartsSupplier SYS DataTypes UID 15 <null> string 0 50 true true false false true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:dd57f577-ffc4-4b55-8f7f-355b9ea3ce37 ! <null> 60 -PartsSupplier SYS KeyColumns UID 8 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:0d994a45-4f52-4b79-9b31-7ef22331fee2 ! <null> 72 -PartsSupplier SYS Keys UID 10 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:782218d1-5337-48c6-9070-0aafd4c6cd20 ! <null> 84 -PartsSupplier SYS ProcedureParams UID 14 <null> string 0 50 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 50 10 mmuuid:a278de2e-89f1-4281-9e63-54aebb6062ce ! <null> 108 -PartsSupplier SYS Procedures UID 6 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:de9df25a-c886-46e0-ae3a-8eb6792e43f4 ! <null> 116 -PartsSupplier SYS Properties UID 3 <null> string 0 50 true true false false true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:b333969a-83e0-4010-9463-9a0088da6c83 ! <null> 121 -PartsSupplier SYS Schemas UID 4 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:ad232e4d-9c01-4d0c-bc57-0459d9db918a ! <null> 140 -PartsSupplier SYS Tables UID 8 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:6afe3737-26f9-43a8-88db-86531b5dc66c ! <null> 151 -PartsSupplier SYS ReferenceKeyColumns UPDATE_RULE 10 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:30d5ae74-b19e-4186-97e1-aeff5801e44f ! <null> 132 -PartsSupplier SYS MatViews Updated 8 <null> timestamp 0 0 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.sql.Timestamp 0 0 10 mmuuid:8053993e-6653-473d-a8b5-7d73f26900b0 ! <null> 93 -PartsSupplier SYS Columns VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:83f19a81-1243-4751-8c99-daddbf37b1d7 ! <null> 17 -PartsSupplier SYS KeyColumns VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:f062eb9c-4854-47fb-b7bd-a4e23c782b62 ! <null> 65 -PartsSupplier SYS Keys VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:5785b523-7da3-42c1-8920-66daa1f7fa1d ! <null> 75 -PartsSupplier SYS MatViews VDBName 1 <null> string 0 255 false true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:9498360d-1e16-4d16-b88f-d46cc75a03c2 ! <null> 86 -PartsSupplier SYS ProcedureParams VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:f832f316-2403-43fa-9ccc-c3ab9d38acca ! <null> 95 -PartsSupplier SYS Procedures VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:1d664747-4a95-4605-8b28-381bed3121f1 ! <null> 111 -PartsSupplier SYS Schemas VDBName 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:73dbf95b-a283-4f0a-81b9-9b98e09c2906 ! <null> 137 -PartsSupplier SYS Tables VDBName 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:58de905f-9d64-4831-a985-da6d082ff709 ! <null> 144 -PartsSupplier SYS MatViews Valid 6 <null> boolean 0 0 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 10 mmuuid:0eb16d11-5da1-47bd-a26e-8403726b2eeb ! <null> 91 -PartsSupplier SYS Properties Value 2 <null> string 0 255 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:c917257d-06b7-41dd-a6cb-44c0ff0f897e ! <null> 120 -PartsSupplier SYS VirtualDatabases Version 2 <null> string 0 50 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:c876d749-a512-4810-9910-3034ca524c45 ! <null> 158 -PartsSupplier pg_catalog pg_attrdef adnum 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e22c521a-e208-4181-9dbd-89f5de7014b9 ! <null> 220 -PartsSupplier pg_catalog pg_attrdef adrelid 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e9b278d4-49af-442f-9a5a-b699fe3b102b ! <null> 219 -PartsSupplier pg_catalog pg_attrdef adsrc 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:4589389f-4abd-42a6-818f-ff1f2a085dfb ! <null> 218 -PartsSupplier pg_catalog pg_am amname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:3c67619c-7d8f-4378-b7e9-84a0451ea5e5 ! <null> 197 -PartsSupplier pg_catalog pg_attribute atthasdef 10 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:5868e549-4bbe-479e-bc7e-632c05cc2329 ! <null> 179 -PartsSupplier pg_catalog pg_attribute attisdropped 9 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:7beb42a9-dfe6-43de-98b6-7e8948b1a666 ! <null> 178 -PartsSupplier pg_catalog pg_attribute attlen 5 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:d1214249-95cd-426f-b8f6-4bf68c0504c7 ! <null> 174 -PartsSupplier pg_catalog pg_attribute attname 3 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:6064d149-4102-4c2d-9132-582342f25e90 ! <null> 172 -PartsSupplier pg_catalog pg_attribute attnotnull 8 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:91ce8bde-8570-4867-be17-80acfa9275a6 ! <null> 177 -PartsSupplier pg_catalog pg_attribute attnum 6 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:141fd911-f2dd-4edd-8f08-ad8a67ffd0fb ! <null> 175 -PartsSupplier pg_catalog pg_attribute attrelid 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:3be6b5de-2287-4279-93f3-4f5064799118 ! <null> 171 -PartsSupplier pg_catalog pg_attribute atttypid 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:99782493-1cce-4e14-9c1b-4de7ce50e2c8 ! <null> 173 -PartsSupplier pg_catalog pg_attribute atttypmod 7 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:2e2bae3c-ab93-49f5-b96c-7a7b9d66782d ! <null> 176 -PartsSupplier pg_catalog pg_database datacl 7 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:4b5beb14-03a0-4652-9d6f-5f8cc74d470c ! <null> 227 -PartsSupplier pg_catalog pg_database datallowconn 5 <null> char 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Character 0 0 0 mmuid:c2bdf40c-ec58-439c-a403-7adf604ceadd ! <null> 225 -PartsSupplier pg_catalog pg_database datconfig 6 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:5c9d54b2-433f-443a-85ce-821f42ed109e ! <null> 226 -PartsSupplier pg_catalog pg_database datdba 8 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:8b993c11-de2b-48bc-beb1-3e44c46811b4 ! <null> 228 -PartsSupplier pg_catalog pg_database datlastsysoid 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:3b621b25-171c-405b-8bf9-635cf93f2273 ! <null> 224 -PartsSupplier pg_catalog pg_database datname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:689cde3b-a631-4f25-94b4-ff2ffe022b0f ! <null> 222 -PartsSupplier pg_catalog pg_database dattablespace 9 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:36db343d-e99a-427c-a4e2-763a720ce4a4 ! <null> 229 -PartsSupplier pg_catalog pg_database encoding 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:1aedd02c-5801-41e7-accd-da1f257c26e8 ! <null> 223 -PartsSupplier pg_catalog pg_index indexprs 7 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:9ea3b6d2-b27b-4bb1-a99d-b703c3308384 ! <null> 194 -PartsSupplier pg_catalog pg_index indexrelid 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:83ae2247-7eec-459f-b037-ffd3cdca0627 ! <null> 189 -PartsSupplier pg_catalog pg_index indisclustered 4 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:16998907-e1dd-447e-898d-780994d30619 ! <null> 191 -PartsSupplier pg_catalog pg_index indisprimary 6 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:a52c714d-dfe9-406c-906b-fadd53ac4e98 ! <null> 193 -PartsSupplier pg_catalog pg_index indisunique 5 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:9f873e0f-903d-4c9d-8c37-1073b5ec4c67 ! <null> 192 -PartsSupplier pg_catalog pg_index indkey 8 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:1e6dbecd-9a2d-4aef-afbe-665de7acb9d6 ! <null> 195 -PartsSupplier pg_catalog pg_index indrelid 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:8709e084-48df-417d-b3f8-f4e9b7d8802b ! <null> 190 -PartsSupplier pg_catalog pg_namespace nspname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:0e513513-b35a-48be-975d-5dbed6ace7e9 ! <null> 160 -PartsSupplier pg_catalog pg_namespace oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:688e5112-4083-4b67-b42c-62d9a614c59a ! <null> 159 -PartsSupplier pg_catalog pg_class oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:c1e736ac-c9d4-4026-8904-23c90e6eb1c0 ! <null> 161 -PartsSupplier pg_catalog pg_attribute oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:f735e545-a81c-4ee2-84d0-3ea35d4083a2 ! <null> 170 -PartsSupplier pg_catalog pg_type oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:b6f64d16-b147-459d-8e84-1bd3048fb900 ! <null> 180 -PartsSupplier pg_catalog pg_index oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:09daed8d-b0b8-4552-a261-2b6c775b46b0 ! <null> 188 -PartsSupplier pg_catalog pg_am oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:f6517a63-8c14-4b73-a18d-afaa5dfb35d9 ! <null> 196 -PartsSupplier pg_catalog pg_proc oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:f20c9489-10ca-4596-8a37-24218b67f764 ! <null> 198 -PartsSupplier pg_catalog pg_trigger oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:2b75f0b1-7475-4ed5-9da3-d37a8a25f26a ! <null> 208 -PartsSupplier pg_catalog pg_attrdef oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:76a7dd05-9a7d-4243-b561-f3056500dcaf ! <null> 217 -PartsSupplier pg_catalog pg_database oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:382f9fc9-8c96-4df7-ab5d-04dfb47ee142 ! <null> 221 -PartsSupplier pg_catalog pg_user oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e63613cb-01ee-4b37-8b91-99d1aac4dfcb ! <null> 230 -PartsSupplier pg_catalog pg_proc proallargtypes 9 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:bcbed548-176c-4116-a5d6-7638cb0206e1 ! <null> 206 -PartsSupplier pg_catalog pg_proc proargmodes 8 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:d9f36bdc-7b25-4af0-b9f5-a96aac6d3094 ! <null> 205 -PartsSupplier pg_catalog pg_proc proargnames 7 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:ffa4ac73-b549-470e-931f-dc36330cb8c4 ! <null> 204 -PartsSupplier pg_catalog pg_proc proargtypes 6 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:6796c2e7-48a4-4f9f-bc98-d47913e2491c ! <null> 203 -PartsSupplier pg_catalog pg_proc proname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:bdf3ee1e-b5b7-48ab-b43c-4bbb2c8ae1e2 ! <null> 199 -PartsSupplier pg_catalog pg_proc pronamespace 10 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:a385751f-a31a-4d5d-9197-3fbd390b0251 ! <null> 207 -PartsSupplier pg_catalog pg_proc pronargs 5 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:9fb5a34a-3a7e-4d38-b7cd-239f28a3504e ! <null> 202 -PartsSupplier pg_catalog pg_proc proretset 3 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:b288b3aa-37f2-4a8e-8b1b-e932a2ce3e25 ! <null> 200 -PartsSupplier pg_catalog pg_proc prorettype 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e0244e1d-431c-41fa-8194-1e357e2b688b ! <null> 201 -PartsSupplier pg_catalog pg_class relam 5 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:c2f92b1a-6ba0-4486-8936-f5185d926178 ! <null> 165 -PartsSupplier pg_catalog pg_class relhasoids 9 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:3ac5a14a-1f9e-455b-8ea1-cf0878774fd7 ! <null> 169 -PartsSupplier pg_catalog pg_class relhasrules 8 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:6c26fd66-2a4a-4ccf-949a-a06a858db7f6 ! <null> 168 -PartsSupplier pg_catalog pg_class relkind 4 <null> char 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Character 0 0 0 mmuid:ef4359eb-6d51-4249-bfea-40bc0f407d10 ! <null> 164 -PartsSupplier pg_catalog pg_class relname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:5f9b50fa-8188-4048-93c2-3ad1587915df ! <null> 162 -PartsSupplier pg_catalog pg_class relnamespace 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:4591ef08-bff8-4f3b-9de7-420f9c7f9d2b ! <null> 163 -PartsSupplier pg_catalog pg_class relpages 7 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:44dee7d6-b6ae-44c7-85f2-e87364d8d059 ! <null> 167 -PartsSupplier pg_catalog pg_class reltuples 6 <null> float 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Float 0 0 0 mmuid:b9ed4b49-5a7b-4ba4-863a-37fd95b2a34c ! <null> 166 -PartsSupplier pg_catalog pg_trigger tgargs 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:250d7c06-728a-4b2a-b557-91f2a69bb184 ! <null> 211 -PartsSupplier pg_catalog pg_trigger tgconstrname 8 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:da4b59ca-ebff-45a8-ad68-9777bc587813 ! <null> 215 -PartsSupplier pg_catalog pg_trigger tgconstrrelid 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:635b6634-632c-43c9-8cc7-bcaa016133e8 ! <null> 209 -PartsSupplier pg_catalog pg_trigger tgdeferrable 6 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:d70f020b-658c-4f58-86dc-0fbb12e2d8af ! <null> 213 -PartsSupplier pg_catalog pg_trigger tgfoid 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:64977f3e-f2a0-466e-a5d1-80bb058cbe08 ! <null> 210 -PartsSupplier pg_catalog pg_trigger tginitdeferred 7 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:bfbff036-caf2-4652-80cf-398af17ed7d1 ! <null> 214 -PartsSupplier pg_catalog pg_trigger tgnargs 5 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:0c20dbe7-5d89-411f-a8ab-3d77b999595b ! <null> 212 -PartsSupplier pg_catalog pg_trigger tgrelid 9 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:c010d12f-2074-45db-8e18-979cee2c45da ! <null> 216 -PartsSupplier pg_catalog pg_type typbasetype 6 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:a17d2f61-cd68-4c0d-8d25-132f68eb3b67 ! <null> 185 -PartsSupplier pg_catalog pg_type typlen 4 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:931c09e1-937a-437e-aab2-2360f8d90e2b ! <null> 183 -PartsSupplier pg_catalog pg_type typname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:d600d818-2aad-4c92-9343-267d044dd97d ! <null> 181 -PartsSupplier pg_catalog pg_type typnamespace 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e47217d2-2b07-4353-bfbd-d7c883a5e7e0 ! <null> 182 -PartsSupplier pg_catalog pg_type typrelid 8 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:bec25882-b292-4ed1-a610-cad5d504837d ! <null> 187 -PartsSupplier pg_catalog pg_type typtype 5 <null> char 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Character 0 0 0 mmuid:83199eba-7af4-44a9-822f-006677b1b895 ! <null> 184 -PartsSupplier pg_catalog pg_type typtypmod 7 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:cee3559d-1ce6-4b17-ad57-2ecb79a9e1d2 ! <null> 186 -PartsSupplier pg_catalog pg_user usecreatedb 3 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:236445e1-408c-40a1-a61c-40e96fb5dc9f ! <null> 232 -PartsSupplier pg_catalog pg_user usename 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:bb78401d-d10c-43b1-af84-e4fa6b95db42 ! <null> 231 -PartsSupplier pg_catalog pg_user usesuper 4 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:6da98878-b46e-4ed1-b032-1bc72da595f4 ! <null> 233 -Row Count : 234 +PartsSupplier SYS Columns Scale 8 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:cc6c6113-8d70-40c8-84c0-94e17c14e22e ! <null> 35 +PartsSupplier SYS DataTypes Scale 6 <null> integer 0 10 true true false false false false false Nullable <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:e8655204-e97a-45cd-909b-1e37731e9546 ! <null> 62 +PartsSupplier SYS ProcedureParams Scale 11 <null> integer 0 10 true true true false false false false No Nulls <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:360c8b1d-4b3d-42fd-952c-bf5763cad69e ! <null> 107 +PartsSupplier SYSADMIN MatViews SchemaName 2 <null> string 0 255 false true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:2738c484-d24d-4c40-b0b7-e734afb03450 ! <null> 18 +PartsSupplier SYS Columns SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:859288c9-cd78-4407-90fc-61b5d310e2ab ! <null> 29 +PartsSupplier SYS KeyColumns SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:787be966-cf12-4956-907f-a8e6dc1009dc ! <null> 77 +PartsSupplier SYS Keys SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:4a7fc059-208e-4f98-b6ef-cb7c6102a327 ! <null> 87 +PartsSupplier SYS ProcedureParams SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:88497911-619c-4ca8-b482-8885d940706a ! <null> 98 +PartsSupplier SYS Procedures SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:53a84865-334e-4750-b343-de2411d56e3e ! <null> 114 +PartsSupplier SYS Tables SchemaName 2 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:95bd960c-fd84-44c9-9831-692376f69b46 ! <null> 147 +PartsSupplier SYS Columns SearchType 20 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:3037138a-bb20-4485-ba01-75bc20b1a532 ! <null> 47 +PartsSupplier SYS DataTypes SearchType 14 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:d8494fa3-40e4-44cd-b0d8-da5c83685a75 ! <null> 70 +PartsSupplier SYS Columns SupportsSelect 11 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:c2a50f93-0040-41ec-ad7b-e8511296555f ! <null> 38 +PartsSupplier SYS Columns SupportsUpdates 12 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:fab660d1-36bf-4a5b-bbe6-9a543e0ebd76 ! <null> 39 +PartsSupplier SYS Tables SupportsUpdates 7 <null> boolean 0 1 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.Boolean 1 1 10 mmuuid:5144d230-2b0e-4255-b321-65b9f6f6f76c ! <null> 152 +PartsSupplier SYS Columns TableName 3 <null> string 0 255 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:2c09c9d1-2f25-45de-81cf-eeb2a5157d34 ! <null> 30 +PartsSupplier SYS KeyColumns TableName 3 <null> string 0 2048 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 2048 2048 10 mmuuid:c24fad72-0c0d-4260-96ae-f188ad77b137 ! <null> 78 +PartsSupplier SYS Keys TableName 3 <null> string 0 2048 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 2048 2048 10 mmuuid:7d9540bd-b51f-4206-8c33-b39c5ba8bb8b ! <null> 88 +PartsSupplier SYSADMIN MatViews TargetName 5 <null> string 0 4000 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 4000 10 mmuuid:d2831595-d6f5-4cca-aa5d-2ff2530d0ab1 ! <null> 21 +PartsSupplier SYSADMIN MatViews TargetSchemaName 4 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:a95dba1c-283e-4f48-9671-34cecdb7d0e3 ! <null> 20 +PartsSupplier SYS Keys Type 7 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:29e73c18-afec-43a9-81ab-7378d6daf20b ! <null> 92 +PartsSupplier SYS ProcedureParams Type 7 <null> string 0 100 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:76a1981b-1226-4a55-9acf-82a061cc8642 ! <null> 103 +PartsSupplier SYS Tables Type 4 <null> string 0 20 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 20 20 10 mmuuid:4814a0af-4e8f-4f55-9b25-3148d90d3d9b ! <null> 149 +PartsSupplier SYS DataTypes TypeLength 7 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:0668382a-f9c3-4507-8b0f-df65a2ebbf2f ! <null> 63 +PartsSupplier SYS ProcedureParams TypeLength 10 <null> integer 0 10 true true false false false false false No Nulls <null> <null> Searchable <null> (0) java.lang.Integer 10 10 10 mmuuid:791d7a29-8fc5-4735-9144-1accc114b58e ! <null> 106 +PartsSupplier SYS DataTypes TypeName 4 <null> string 0 100 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 100 100 10 mmuuid:48081cdd-9e90-4440-a956-4a32af96d7f4 ! <null> 60 +PartsSupplier SYS Columns UID 27 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:5f491c75-769b-4908-9f68-2a9a486607bb ! <null> 54 +PartsSupplier SYS DataTypes UID 15 <null> string 0 50 true true false false true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:dd57f577-ffc4-4b55-8f7f-355b9ea3ce37 ! <null> 71 +PartsSupplier SYS KeyColumns UID 8 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:0d994a45-4f52-4b79-9b31-7ef22331fee2 ! <null> 83 +PartsSupplier SYS Keys UID 10 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:782218d1-5337-48c6-9070-0aafd4c6cd20 ! <null> 95 +PartsSupplier SYS ProcedureParams UID 14 <null> string 0 50 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 50 10 mmuuid:a278de2e-89f1-4281-9e63-54aebb6062ce ! <null> 110 +PartsSupplier SYS Procedures UID 6 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:de9df25a-c886-46e0-ae3a-8eb6792e43f4 ! <null> 118 +PartsSupplier SYS Properties UID 3 <null> string 0 50 true true false false true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:b333969a-83e0-4010-9463-9a0088da6c83 ! <null> 123 +PartsSupplier SYS Schemas UID 4 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:ad232e4d-9c01-4d0c-bc57-0459d9db918a ! <null> 142 +PartsSupplier SYS Tables UID 8 <null> string 0 50 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:6afe3737-26f9-43a8-88db-86531b5dc66c ! <null> 153 +PartsSupplier SYS ReferenceKeyColumns UPDATE_RULE 10 <null> integer 0 10 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Integer 10 10 10 mmuuid:30d5ae74-b19e-4186-97e1-aeff5801e44f ! <null> 134 +PartsSupplier SYSADMIN MatViews Updated 8 <null> timestamp 0 0 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.sql.Timestamp 0 0 10 mmuuid:33970a66-7ad4-411f-a6c4-545746747fe6 ! <null> 24 +PartsSupplier SYSADMIN MatViews VDBName 1 <null> string 0 255 false true true true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:c1ce9841-e272-4839-8c78-777a5f68d241 ! <null> 17 +PartsSupplier SYS Columns VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:83f19a81-1243-4751-8c99-daddbf37b1d7 ! <null> 28 +PartsSupplier SYS KeyColumns VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:f062eb9c-4854-47fb-b7bd-a4e23c782b62 ! <null> 76 +PartsSupplier SYS Keys VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:5785b523-7da3-42c1-8920-66daa1f7fa1d ! <null> 86 +PartsSupplier SYS ProcedureParams VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:f832f316-2403-43fa-9ccc-c3ab9d38acca ! <null> 97 +PartsSupplier SYS Procedures VDBName 1 <null> string 0 255 true true false false false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:1d664747-4a95-4605-8b28-381bed3121f1 ! <null> 113 +PartsSupplier SYS Schemas VDBName 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:73dbf95b-a283-4f0a-81b9-9b98e09c2906 ! <null> 139 +PartsSupplier SYS Tables VDBName 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:58de905f-9d64-4831-a985-da6d082ff709 ! <null> 146 +PartsSupplier SYSADMIN MatViews Valid 6 <null> boolean 0 0 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 10 mmuuid:13098912-bce2-4842-9ea9-b162fcd7383e ! <null> 22 +PartsSupplier SYS Properties Value 2 <null> string 0 255 true true false true true false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 255 255 10 mmuuid:c917257d-06b7-41dd-a6cb-44c0ff0f897e ! <null> 122 +PartsSupplier SYS VirtualDatabases Version 2 <null> string 0 50 true true false true false false false No Nulls <null> <null> Searchable <null> <null> java.lang.String 50 50 10 mmuuid:c876d749-a512-4810-9910-3034ca524c45 ! <null> 160 +PartsSupplier pg_catalog pg_attrdef adnum 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e22c521a-e208-4181-9dbd-89f5de7014b9 ! <null> 222 +PartsSupplier pg_catalog pg_attrdef adrelid 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e9b278d4-49af-442f-9a5a-b699fe3b102b ! <null> 221 +PartsSupplier pg_catalog pg_attrdef adsrc 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:4589389f-4abd-42a6-818f-ff1f2a085dfb ! <null> 220 +PartsSupplier pg_catalog pg_am amname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:3c67619c-7d8f-4378-b7e9-84a0451ea5e5 ! <null> 199 +PartsSupplier pg_catalog pg_attribute atthasdef 10 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:5868e549-4bbe-479e-bc7e-632c05cc2329 ! <null> 181 +PartsSupplier pg_catalog pg_attribute attisdropped 9 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:7beb42a9-dfe6-43de-98b6-7e8948b1a666 ! <null> 180 +PartsSupplier pg_catalog pg_attribute attlen 5 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:d1214249-95cd-426f-b8f6-4bf68c0504c7 ! <null> 176 +PartsSupplier pg_catalog pg_attribute attname 3 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:6064d149-4102-4c2d-9132-582342f25e90 ! <null> 174 +PartsSupplier pg_catalog pg_attribute attnotnull 8 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:91ce8bde-8570-4867-be17-80acfa9275a6 ! <null> 179 +PartsSupplier pg_catalog pg_attribute attnum 6 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:141fd911-f2dd-4edd-8f08-ad8a67ffd0fb ! <null> 177 +PartsSupplier pg_catalog pg_attribute attrelid 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:3be6b5de-2287-4279-93f3-4f5064799118 ! <null> 173 +PartsSupplier pg_catalog pg_attribute atttypid 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:99782493-1cce-4e14-9c1b-4de7ce50e2c8 ! <null> 175 +PartsSupplier pg_catalog pg_attribute atttypmod 7 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:2e2bae3c-ab93-49f5-b96c-7a7b9d66782d ! <null> 178 +PartsSupplier SYSADMIN VDBResources contents 2 <null> blob 0 0 false true true true true false false Nullable <null> <null> Searchable <null> <null> org.teiid.core.types.BlobType 0 0 10 mmuuid:f9421669-3564-451d-9293-96c1e5e72c4f ! <null> 27 +PartsSupplier pg_catalog pg_database datacl 7 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:4b5beb14-03a0-4652-9d6f-5f8cc74d470c ! <null> 229 +PartsSupplier pg_catalog pg_database datallowconn 5 <null> char 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Character 0 0 0 mmuid:c2bdf40c-ec58-439c-a403-7adf604ceadd ! <null> 227 +PartsSupplier pg_catalog pg_database datconfig 6 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:5c9d54b2-433f-443a-85ce-821f42ed109e ! <null> 228 +PartsSupplier pg_catalog pg_database datdba 8 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:8b993c11-de2b-48bc-beb1-3e44c46811b4 ! <null> 230 +PartsSupplier pg_catalog pg_database datlastsysoid 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:3b621b25-171c-405b-8bf9-635cf93f2273 ! <null> 226 +PartsSupplier pg_catalog pg_database datname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:689cde3b-a631-4f25-94b4-ff2ffe022b0f ! <null> 224 +PartsSupplier pg_catalog pg_database dattablespace 9 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:36db343d-e99a-427c-a4e2-763a720ce4a4 ! <null> 231 +PartsSupplier pg_catalog pg_database encoding 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:1aedd02c-5801-41e7-accd-da1f257c26e8 ! <null> 225 +PartsSupplier pg_catalog pg_index indexprs 7 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:9ea3b6d2-b27b-4bb1-a99d-b703c3308384 ! <null> 196 +PartsSupplier pg_catalog pg_index indexrelid 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:83ae2247-7eec-459f-b037-ffd3cdca0627 ! <null> 191 +PartsSupplier pg_catalog pg_index indisclustered 4 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:16998907-e1dd-447e-898d-780994d30619 ! <null> 193 +PartsSupplier pg_catalog pg_index indisprimary 6 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:a52c714d-dfe9-406c-906b-fadd53ac4e98 ! <null> 195 +PartsSupplier pg_catalog pg_index indisunique 5 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:9f873e0f-903d-4c9d-8c37-1073b5ec4c67 ! <null> 194 +PartsSupplier pg_catalog pg_index indkey 8 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:1e6dbecd-9a2d-4aef-afbe-665de7acb9d6 ! <null> 197 +PartsSupplier pg_catalog pg_index indrelid 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:8709e084-48df-417d-b3f8-f4e9b7d8802b ! <null> 192 +PartsSupplier pg_catalog pg_namespace nspname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:0e513513-b35a-48be-975d-5dbed6ace7e9 ! <null> 162 +PartsSupplier pg_catalog pg_namespace oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:688e5112-4083-4b67-b42c-62d9a614c59a ! <null> 161 +PartsSupplier pg_catalog pg_class oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:c1e736ac-c9d4-4026-8904-23c90e6eb1c0 ! <null> 163 +PartsSupplier pg_catalog pg_attribute oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:f735e545-a81c-4ee2-84d0-3ea35d4083a2 ! <null> 172 +PartsSupplier pg_catalog pg_type oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:b6f64d16-b147-459d-8e84-1bd3048fb900 ! <null> 182 +PartsSupplier pg_catalog pg_index oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:09daed8d-b0b8-4552-a261-2b6c775b46b0 ! <null> 190 +PartsSupplier pg_catalog pg_am oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:f6517a63-8c14-4b73-a18d-afaa5dfb35d9 ! <null> 198 +PartsSupplier pg_catalog pg_proc oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:f20c9489-10ca-4596-8a37-24218b67f764 ! <null> 200 +PartsSupplier pg_catalog pg_trigger oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:2b75f0b1-7475-4ed5-9da3-d37a8a25f26a ! <null> 210 +PartsSupplier pg_catalog pg_attrdef oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:76a7dd05-9a7d-4243-b561-f3056500dcaf ! <null> 219 +PartsSupplier pg_catalog pg_database oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:382f9fc9-8c96-4df7-ab5d-04dfb47ee142 ! <null> 223 +PartsSupplier pg_catalog pg_user oid 1 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e63613cb-01ee-4b37-8b91-99d1aac4dfcb ! <null> 232 +PartsSupplier pg_catalog pg_proc proallargtypes 9 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:bcbed548-176c-4116-a5d6-7638cb0206e1 ! <null> 208 +PartsSupplier pg_catalog pg_proc proargmodes 8 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:d9f36bdc-7b25-4af0-b9f5-a96aac6d3094 ! <null> 207 +PartsSupplier pg_catalog pg_proc proargnames 7 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:ffa4ac73-b549-470e-931f-dc36330cb8c4 ! <null> 206 +PartsSupplier pg_catalog pg_proc proargtypes 6 <null> object 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Object 0 0 0 mmuid:6796c2e7-48a4-4f9f-bc98-d47913e2491c ! <null> 205 +PartsSupplier pg_catalog pg_proc proname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:bdf3ee1e-b5b7-48ab-b43c-4bbb2c8ae1e2 ! <null> 201 +PartsSupplier pg_catalog pg_proc pronamespace 10 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:a385751f-a31a-4d5d-9197-3fbd390b0251 ! <null> 209 +PartsSupplier pg_catalog pg_proc pronargs 5 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:9fb5a34a-3a7e-4d38-b7cd-239f28a3504e ! <null> 204 +PartsSupplier pg_catalog pg_proc proretset 3 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:b288b3aa-37f2-4a8e-8b1b-e932a2ce3e25 ! <null> 202 +PartsSupplier pg_catalog pg_proc prorettype 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e0244e1d-431c-41fa-8194-1e357e2b688b ! <null> 203 +PartsSupplier pg_catalog pg_class relam 5 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:c2f92b1a-6ba0-4486-8936-f5185d926178 ! <null> 167 +PartsSupplier pg_catalog pg_class relhasoids 9 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:3ac5a14a-1f9e-455b-8ea1-cf0878774fd7 ! <null> 171 +PartsSupplier pg_catalog pg_class relhasrules 8 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:6c26fd66-2a4a-4ccf-949a-a06a858db7f6 ! <null> 170 +PartsSupplier pg_catalog pg_class relkind 4 <null> char 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Character 0 0 0 mmuid:ef4359eb-6d51-4249-bfea-40bc0f407d10 ! <null> 166 +PartsSupplier pg_catalog pg_class relname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:5f9b50fa-8188-4048-93c2-3ad1587915df ! <null> 164 +PartsSupplier pg_catalog pg_class relnamespace 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:4591ef08-bff8-4f3b-9de7-420f9c7f9d2b ! <null> 165 +PartsSupplier pg_catalog pg_class relpages 7 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:44dee7d6-b6ae-44c7-85f2-e87364d8d059 ! <null> 169 +PartsSupplier pg_catalog pg_class reltuples 6 <null> float 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Float 0 0 0 mmuid:b9ed4b49-5a7b-4ba4-863a-37fd95b2a34c ! <null> 168 +PartsSupplier SYSADMIN VDBResources resourcePath 1 <null> string 0 255 false true true true true false false Nullable <null> <null> Searchable <null> <null> java.lang.String 0 255 10 mmuuid:b1bc5150-3dcc-452e-9e75-4a506997f612 ! <null> 26 +PartsSupplier pg_catalog pg_trigger tgargs 4 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:250d7c06-728a-4b2a-b557-91f2a69bb184 ! <null> 213 +PartsSupplier pg_catalog pg_trigger tgconstrname 8 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:da4b59ca-ebff-45a8-ad68-9777bc587813 ! <null> 217 +PartsSupplier pg_catalog pg_trigger tgconstrrelid 2 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:635b6634-632c-43c9-8cc7-bcaa016133e8 ! <null> 211 +PartsSupplier pg_catalog pg_trigger tgdeferrable 6 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:d70f020b-658c-4f58-86dc-0fbb12e2d8af ! <null> 215 +PartsSupplier pg_catalog pg_trigger tgfoid 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:64977f3e-f2a0-466e-a5d1-80bb058cbe08 ! <null> 212 +PartsSupplier pg_catalog pg_trigger tginitdeferred 7 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:bfbff036-caf2-4652-80cf-398af17ed7d1 ! <null> 216 +PartsSupplier pg_catalog pg_trigger tgnargs 5 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:0c20dbe7-5d89-411f-a8ab-3d77b999595b ! <null> 214 +PartsSupplier pg_catalog pg_trigger tgrelid 9 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:c010d12f-2074-45db-8e18-979cee2c45da ! <null> 218 +PartsSupplier pg_catalog pg_type typbasetype 6 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:a17d2f61-cd68-4c0d-8d25-132f68eb3b67 ! <null> 187 +PartsSupplier pg_catalog pg_type typlen 4 <null> short 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Short 0 0 0 mmuid:931c09e1-937a-437e-aab2-2360f8d90e2b ! <null> 185 +PartsSupplier pg_catalog pg_type typname 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:d600d818-2aad-4c92-9343-267d044dd97d ! <null> 183 +PartsSupplier pg_catalog pg_type typnamespace 3 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:e47217d2-2b07-4353-bfbd-d7c883a5e7e0 ! <null> 184 +PartsSupplier pg_catalog pg_type typrelid 8 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:bec25882-b292-4ed1-a610-cad5d504837d ! <null> 189 +PartsSupplier pg_catalog pg_type typtype 5 <null> char 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Character 0 0 0 mmuid:83199eba-7af4-44a9-822f-006677b1b895 ! <null> 186 +PartsSupplier pg_catalog pg_type typtypmod 7 <null> integer 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Integer 0 0 0 mmuid:cee3559d-1ce6-4b17-ad57-2ecb79a9e1d2 ! <null> 188 +PartsSupplier pg_catalog pg_user usecreatedb 3 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:236445e1-408c-40a1-a61c-40e96fb5dc9f ! <null> 234 +PartsSupplier pg_catalog pg_user usename 2 <null> string 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.String 0 0 0 mmuid:bb78401d-d10c-43b1-af84-e4fa6b95db42 ! <null> 233 +PartsSupplier pg_catalog pg_user usesuper 4 <null> boolean 0 0 false true false false false false false Unknown <null> <null> Searchable <null> <null> java.lang.Boolean 0 0 0 mmuid:6da98878-b46e-4ed1-b032-1bc72da595f4 ! <null> 235 +Row Count : 236 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable VDBName 12 PartsSupplier java.lang.String VDBName string SYS Columns 255 255 0 false false false false 0 true true false false SchemaName 12 PartsSupplier java.lang.String SchemaName string SYS Columns 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,20 +1,14 @@ string string string string string integer string boolean integer integer integer integer string string string integer VDBName SchemaName ProcedureName Name DataType Position Type Optional Precision TypeLength Scale Radix NullType UID Description OID -PartsSupplier SYS refreshMatView Invalidate boolean 2 In false 0 0 0 10 No Nulls mmuuid:0a04801b-c78e-4ccf-a273-8b6c2fbc4fec <null> 12 -PartsSupplier SYS refreshMatViewRow Key object 2 In false 0 0 0 10 No Nulls mmuuid:c339f41d-5927-4516-849f-b1485c18ee6b <null> 9 -PartsSupplier SYS getVDBResourcePaths ResourcePath string 1 ResultSet false 50 50 0 10 Nullable mmuuid:ebbffdab-ac7e-41ab-974f-62785b3086f9 <null> 4 -PartsSupplier SYS refreshMatViewRow RowsUpdated integer 3 ReturnValue false 0 0 0 10 No Nulls mmuuid:882ac88e-8e35-4173-8961-71997ff3552a <null> 10 -PartsSupplier SYS refreshMatView RowsUpdated integer 3 ReturnValue false 0 0 0 10 No Nulls mmuuid:ea9da7d7-680a-41fc-8235-989e076f10a1 <null> 13 -PartsSupplier SYS getBinaryVDBResource VdbResource blob 1 ResultSet false 0 0 0 10 Nullable mmuuid:90d1f79d-bd98-46f4-ae8f-adacc329cf0b <null> 1 -PartsSupplier SYS getCharacterVDBResource VdbResource clob 1 ResultSet false 0 0 0 10 Nullable mmuuid:111f9fa8-74c9-479a-a184-8db64a1eab3c <null> 3 -PartsSupplier SYS refreshMatViewRow ViewName string 1 In false 0 0 0 10 No Nulls mmuuid:db4b20a0-0714-4cab-9a94-96a2171a4231 <null> 8 -PartsSupplier SYS refreshMatView ViewName string 1 In false 0 0 0 10 No Nulls mmuuid:9e3b093d-616b-46a2-9789-a963354f2f4c <null> 11 -PartsSupplier SYS getXMLSchemas document string 1 In false 0 0 0 10 No Nulls mmuuid:41f00dca-7bc1-4593-b2a7-a7d64936c2d4 <null> 6 -PartsSupplier SYS getVDBResourcePaths isBinary boolean 2 ResultSet false 1 1 0 10 Nullable mmuuid:e8d087da-9833-4422-a255-f0e0fea2cb61 <null> 5 -PartsSupplier SYS getBinaryVDBResource resourcePath string 1 In false 50 50 0 10 No Nulls mmuuid:25e5065a-454e-4a87-bf71-b6f71b98319f <null> 0 -PartsSupplier SYS getCharacterVDBResource resourcePath string 1 In false 50 50 0 10 No Nulls mmuuid:c54e777f-3cd0-45ad-a18b-e4e93532984f <null> 2 -PartsSupplier SYS getXMLSchemas schema xml 1 ResultSet false 0 0 0 10 Nullable mmuuid:f0cb82f2-111e-4433-ae77-59a27fa93991 <null> 7 -Row Count : 14 +PartsSupplier SYSADMIN refreshMatView Invalidate boolean 2 In false 0 0 0 10 No Nulls mmuuid:5736cfd3-750f-42d8-b083-102061e11c60 <null> 4 +PartsSupplier SYSADMIN refreshMatViewRow Key object 2 In false 0 0 0 10 No Nulls mmuuid:7af5a63b-1b91-4d1e-912e-846a7e84c579 <null> 1 +PartsSupplier SYSADMIN refreshMatViewRow RowsUpdated integer 3 ReturnValue false 0 0 0 10 No Nulls mmuuid:05a6a9be-c014-4d06-bcac-746cee4f118b <null> 2 +PartsSupplier SYSADMIN refreshMatView RowsUpdated integer 3 ReturnValue false 0 0 0 10 No Nulls mmuuid:d07a6a75-aa12-4dac-8eab-b2acdbaaffd8 <null> 5 +PartsSupplier SYSADMIN refreshMatViewRow ViewName string 1 In false 0 0 0 10 No Nulls mmuuid:ba635c44-a052-496d-9c35-ca010c0ebebe <null> 0 +PartsSupplier SYSADMIN refreshMatView ViewName string 1 In false 0 0 0 10 No Nulls mmuuid:e0c28e00-d987-48e4-8c60-5f637f10bf33 <null> 3 +PartsSupplier SYS getXMLSchemas document string 1 In false 0 0 0 10 No Nulls mmuuid:85b88af5-f0b8-401f-b35a-ccee56155492 <null> 6 +PartsSupplier SYS getXMLSchemas schema xml 1 ResultSet false 0 0 0 10 Nullable mmuuid:003980bb-38bb-41ad-b8c2-c87ca47aa554 <null> 7 +Row Count : 8 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable VDBName 12 PartsSupplier java.lang.String VDBName string SYS ProcedureParams 255 255 0 false false false false 0 true true false false SchemaName 12 PartsSupplier java.lang.String SchemaName string SYS ProcedureParams 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedures.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedures.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedures.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,12 +1,9 @@ string string string string boolean string string integer VDBName SchemaName Name NameInSource ReturnsResults UID Description OID -PartsSupplier SYS getBinaryVDBResource <null> true mmuuid:9bc0b701-b36e-4209-a986-9d38420d2c20 <null> 0 -PartsSupplier SYS getCharacterVDBResource <null> true mmuuid:72464082-00fc-44f0-98b9-8c8f637c6570 <null> 1 -PartsSupplier SYS getVDBResourcePaths <null> true mmuuid:1204d4b2-6f92-428d-bcc5-7b3a0da9a113 <null> 2 -PartsSupplier SYS getXMLSchemas <null> true mmuuid:2d51a2a4-9966-4bd8-861d-9c0ae8e4b869 <null> 3 -PartsSupplier SYS refreshMatView <null> false mmuuid:38467814-0f73-40c0-a373-0ee4f8bda99a <null> 5 -PartsSupplier SYS refreshMatViewRow <null> false mmuuid:f03ad830-a06c-4b8e-bb4e-2dd1ae59bb3f <null> 4 -Row Count : 6 +PartsSupplier SYS getXMLSchemas <null> true mmuuid:68497bd9-30f5-461b-bf13-6b26aeb2fc4f <null> 2 +PartsSupplier SYSADMIN refreshMatView <null> false mmuuid:52178344-dca8-4c76-8549-00a4515c7044 <null> 1 +PartsSupplier SYSADMIN refreshMatViewRow <null> false mmuuid:1674912b-af56-465a-a1b9-d1de8b761f10 <null> 0 +Row Count : 3 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable VDBName 12 PartsSupplier java.lang.String VDBName string SYS Procedures 255 255 0 false false false false 0 true true false false SchemaName 12 PartsSupplier java.lang.String SchemaName string SYS Procedures 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testSchemas.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testSchemas.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testSchemas.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,9 +1,10 @@ string string boolean string string string integer VDBName Name IsPhysical UID Description PrimaryMetamodelURI OID PartsSupplier PartsSupplier true mmuuid:19c7f380-73d8-1edc-a81c-ecf397b10590 <null> http://www.metamatrix.com/metamodels/Relational 0 -PartsSupplier SYS true mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de System http://www.metamatrix.com/metamodels/Relational 1 -PartsSupplier pg_catalog true mmuid:5a84789f-c794-4748-803a-09b6b605f6b9 <null> http://www.metamatrix.com/metamodels/Relational 2 -Row Count : 3 +PartsSupplier SYS true mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de System http://www.metamatrix.com/metamodels/Relational 2 +PartsSupplier SYSADMIN true mmuuid:82f6153e-31e0-4034-b335-013cb418da34 <null> http://www.metamatrix.com/metamodels/Relational 1 +PartsSupplier pg_catalog true mmuid:5a84789f-c794-4748-803a-09b6b605f6b9 <null> http://www.metamatrix.com/metamodels/Relational 3 +Row Count : 4 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable VDBName 12 PartsSupplier java.lang.String VDBName string SYS Schemas 255 255 0 false true false true 1 false true true true Name 12 PartsSupplier java.lang.String Name string SYS Schemas 255 255 0 false true false true 1 false true true true Modified: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTableIsSystem.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTableIsSystem.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTableIsSystem.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -5,6 +5,7 @@ PARTSSUPPLIER.STATUS PARTSSUPPLIER.SUPPLIER PARTSSUPPLIER.SUPPLIER_PARTS -Row Count : 5 +VDBResources +Row Count : 6 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable Name 12 PartsSupplier java.lang.String Name string SYS Tables 255 255 0 false true false false 0 true true false false Modified: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTables.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTables.expected 2010-09-14 02:11:55 UTC (rev 2565) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testTables.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -1,34 +1,35 @@ string string string string string boolean boolean string integer string boolean boolean integer VDBName SchemaName Name Type NameInSource IsPhysical SupportsUpdates UID Cardinality Description IsSystem IsMaterialized OID -PartsSupplier SYS Columns Table <null> true false mmuuid:1c9a5cb2-17b1-4e4a-8b0e-3a42bd052509 0 <null> true false 5 -PartsSupplier SYS DataTypes Table <null> true false mmuuid:9a8794f9-66f8-49e8-8576-89d212d0f957 0 <null> true false 6 -PartsSupplier SYS KeyColumns Table <null> true false mmuuid:14946083-3bd5-42d5-8283-1c0694347c29 0 <null> true false 7 -PartsSupplier SYS Keys Table <null> true false mmuuid:1e5135dc-ce5d-4b25-a8ff-63f5440b3108 0 <null> true false 8 -PartsSupplier SYS MatViews Table <null> true true mmuuid:29f7718e-bd87-4fe0-8b8a-9fec44517de5 0 <null> true false 9 +PartsSupplier SYS Columns Table <null> true false mmuuid:1c9a5cb2-17b1-4e4a-8b0e-3a42bd052509 0 <null> true false 7 +PartsSupplier SYS DataTypes Table <null> true false mmuuid:9a8794f9-66f8-49e8-8576-89d212d0f957 0 <null> true false 8 +PartsSupplier SYS KeyColumns Table <null> true false mmuuid:14946083-3bd5-42d5-8283-1c0694347c29 0 <null> true false 9 +PartsSupplier SYS Keys Table <null> true false mmuuid:1e5135dc-ce5d-4b25-a8ff-63f5440b3108 0 <null> true false 10 +PartsSupplier SYSADMIN MatViews Table <null> true true mmuuid:520ba1e8-3553-460f-8d18-9b43f089e256 0 <null> true false 5 PartsSupplier PartsSupplier PARTSSUPPLIER.PARTS Table PARTS true true mmuuid:f6276601-73fe-1edc-a81c-ecf397b10590 16 <null> false false 0 PartsSupplier PartsSupplier PARTSSUPPLIER.SHIP_VIA Table SHIP_VIA true true mmuuid:0f4e9b80-73ff-1edc-a81c-ecf397b10590 4 <null> false false 1 PartsSupplier PartsSupplier PARTSSUPPLIER.STATUS Table STATUS true true mmuuid:1f297200-73ff-1edc-a81c-ecf397b10590 3 <null> false false 2 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER Table SUPPLIER true true mmuuid:2c371ec0-73ff-1edc-a81c-ecf397b10590 16 <null> false false 4 PartsSupplier PartsSupplier PARTSSUPPLIER.SUPPLIER_PARTS Table SUPPLIER_PARTS true true mmuuid:3deafb00-73ff-1edc-a81c-ecf397b10590 227 <null> false false 3 -PartsSupplier SYS ProcedureParams Table <null> true false mmuuid:a56bd7fe-c87a-411c-8f5d-661975a25626 0 <null> true false 10 -PartsSupplier SYS Procedures Table <null> true false mmuuid:0bc132a5-9f8d-4a3c-9f5d-98156a98a962 0 <null> true false 11 -PartsSupplier SYS Properties Table <null> true false mmuuid:7a45e50a-d03f-4548-ba35-761651bbca85 0 <null> true false 12 -PartsSupplier SYS ReferenceKeyColumns Table <null> true false mmuuid:6a9653e8-a337-41b2-86fa-77b98f409a29 0 <null> true false 13 -PartsSupplier SYS Schemas Table <null> true false mmuuid:8648a554-b2ad-4e8e-84ca-2ec618b311a9 0 <null> true false 14 -PartsSupplier SYS Tables Table <null> true false mmuuid:8551b3bd-11cc-4049-9bcf-fe91a0eb7ba7 0 <null> true false 15 -PartsSupplier SYS VirtualDatabases Table <null> true false mmuuid:47297c72-d621-4f4e-af4e-74060ac5f489 0 <null> true false 16 -PartsSupplier pg_catalog pg_am Table <null> false false mmuid:1462b28e-0bab-436f-9654-013821506337 0 <null> true false 22 -PartsSupplier pg_catalog pg_attrdef Table <null> false false mmuid:71091853-c65e-46a9-9947-aa024f806e2d 0 <null> true false 25 -PartsSupplier pg_catalog pg_attribute Table <null> false false mmuid:fa463d98-365f-489a-a707-025193cb51eb 0 <null> true true 19 -PartsSupplier pg_catalog pg_class Table <null> false false mmuid:7e21f2e6-06e3-4bca-9b01-72ea47821560 0 <null> true true 18 -PartsSupplier pg_catalog pg_database Table <null> false false mmuid:492dd834-907f-429b-aa6e-958ad65204c6 0 <null> true false 26 -PartsSupplier pg_catalog pg_index Table <null> false false mmuid:22ac431d-e6e6-4eef-9d74-b31795424e97 0 <null> true true 21 -PartsSupplier pg_catalog pg_namespace Table <null> false false mmuid:6609866a-3d7b-4f4b-95fe-ebfac769d699 0 <null> true false 17 -PartsSupplier pg_catalog pg_proc Table <null> false false mmuid:da4b747e-7d87-403a-8309-2cdf1399031b 0 <null> true true 23 -PartsSupplier pg_catalog pg_trigger Table <null> false false mmuid:9569efdb-21b2-4b4f-a2db-e7406267b8ed 0 <null> true false 24 -PartsSupplier pg_catalog pg_type Table <null> false false mmuid:9462e3f8-cd3c-414f-a570-f6f33c40e36a 0 <null> true false 20 -PartsSupplier pg_catalog pg_user Table <null> false false mmuid:28d034eb-6f39-402f-b642-9c9560e57247 0 <null> true false 27 -Row Count : 28 +PartsSupplier SYS ProcedureParams Table <null> true false mmuuid:a56bd7fe-c87a-411c-8f5d-661975a25626 0 <null> true false 11 +PartsSupplier SYS Procedures Table <null> true false mmuuid:0bc132a5-9f8d-4a3c-9f5d-98156a98a962 0 <null> true false 12 +PartsSupplier SYS Properties Table <null> true false mmuuid:7a45e50a-d03f-4548-ba35-761651bbca85 0 <null> true false 13 +PartsSupplier SYS ReferenceKeyColumns Table <null> true false mmuuid:6a9653e8-a337-41b2-86fa-77b98f409a29 0 <null> true false 14 +PartsSupplier SYS Schemas Table <null> true false mmuuid:8648a554-b2ad-4e8e-84ca-2ec618b311a9 0 <null> true false 15 +PartsSupplier SYS Tables Table <null> true false mmuuid:8551b3bd-11cc-4049-9bcf-fe91a0eb7ba7 0 <null> true false 16 +PartsSupplier SYSADMIN VDBResources Table <null> true true mmuuid:1785804d-beaf-4831-9531-e59164fedd49 0 <null> false false 6 +PartsSupplier SYS VirtualDatabases Table <null> true false mmuuid:47297c72-d621-4f4e-af4e-74060ac5f489 0 <null> true false 17 +PartsSupplier pg_catalog pg_am Table <null> false false mmuid:1462b28e-0bab-436f-9654-013821506337 0 <null> true false 23 +PartsSupplier pg_catalog pg_attrdef Table <null> false false mmuid:71091853-c65e-46a9-9947-aa024f806e2d 0 <null> true false 26 +PartsSupplier pg_catalog pg_attribute Table <null> false false mmuid:fa463d98-365f-489a-a707-025193cb51eb 0 <null> true true 20 +PartsSupplier pg_catalog pg_class Table <null> false false mmuid:7e21f2e6-06e3-4bca-9b01-72ea47821560 0 <null> true true 19 +PartsSupplier pg_catalog pg_database Table <null> false false mmuid:492dd834-907f-429b-aa6e-958ad65204c6 0 <null> true false 27 +PartsSupplier pg_catalog pg_index Table <null> false false mmuid:22ac431d-e6e6-4eef-9d74-b31795424e97 0 <null> true true 22 +PartsSupplier pg_catalog pg_namespace Table <null> false false mmuid:6609866a-3d7b-4f4b-95fe-ebfac769d699 0 <null> true false 18 +PartsSupplier pg_catalog pg_proc Table <null> false false mmuid:da4b747e-7d87-403a-8309-2cdf1399031b 0 <null> true true 24 +PartsSupplier pg_catalog pg_trigger Table <null> false false mmuid:9569efdb-21b2-4b4f-a2db-e7406267b8ed 0 <null> true false 25 +PartsSupplier pg_catalog pg_type Table <null> false false mmuid:9462e3f8-cd3c-414f-a570-f6f33c40e36a 0 <null> true false 21 +PartsSupplier pg_catalog pg_user Table <null> false false mmuid:28d034eb-6f39-402f-b642-9c9560e57247 0 <null> true false 28 +Row Count : 29 getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable VDBName 12 PartsSupplier java.lang.String VDBName string SYS Tables 255 255 0 false true false true 1 false true true true SchemaName 12 PartsSupplier java.lang.String SchemaName string SYS Tables 255 255 0 false true false true 1 false true true true Added: branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testVDBResources.expected =================================================================== --- branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testVDBResources.expected (rev 0) +++ branches/7.1.x/test-integration/common/src/test/resources/TestSystemVirtualModel/testVDBResources.expected 2010-09-14 02:18:40 UTC (rev 2566) @@ -0,0 +1,26 @@ +string blob +resourcePath contents +/parts/partsmd/PartsSupplier.xmi Blob[9655] +/ConfigurationInfo.def Blob[4830] +/META-INF/MANIFEST.MF Blob[25] +/MetaMatrix-VdbManifestModel.xmi Blob[2393] +/runtime-inf/ANNOTATION.INDEX Blob[8212] +/runtime-inf/COLUMNS.INDEX Blob[25021] +/runtime-inf/DATATYPES.INDEX Blob[42378] +/runtime-inf/DELETE_TRANSFORM.INDEX Blob[8212] +/runtime-inf/FILES.INDEX Blob[8212] +/runtime-inf/INSERT_TRANSFORM.INDEX Blob[8212] +/runtime-inf/KEYS.INDEX Blob[25014] +/runtime-inf/MAPPING_TRANSFORM.INDEX Blob[8212] +/runtime-inf/MODELS.INDEX Blob[24855] +/runtime-inf/PROCEDURES.INDEX Blob[8212] +/runtime-inf/PROC_TRANSFORM.INDEX Blob[8212] +/runtime-inf/PROPERTIES.INDEX Blob[8212] +/runtime-inf/SELECT_TRANSFORM.INDEX Blob[8212] +/runtime-inf/TABLES.INDEX Blob[24947] +/runtime-inf/UPDATE_TRANSFORM.INDEX Blob[8212] +/runtime-inf/VDBS.INDEX Blob[24924] +Row Count : 20 +getColumnName getColumnType getCatalogName getColumnClassName getColumnLabel getColumnTypeName getSchemaName getTableName getColumnDisplaySize getPrecision getScale isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isNullable isReadOnly isSearchable isSigned isWritable +resourcePath 12 PartsSupplier java.lang.String resourcePath string SYSADMIN VDBResources 255 255 0 false true false true 1 false true true true +contents 2004 PartsSupplier java.sql.Blob contents blob SYSADMIN VDBResources 2147483647 2147483647 0 false true false true 1 false true true true