Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 41757 invoked from network); 15 Mar 2005 05:28:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 15 Mar 2005 05:28:12 -0000 Received: (qmail 31137 invoked by uid 500); 15 Mar 2005 05:28:12 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 31086 invoked by uid 500); 15 Mar 2005 05:28:12 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 31072 invoked by uid 500); 15 Mar 2005 05:28:11 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 31069 invoked by uid 99); 15 Mar 2005 05:28:11 -0000 X-ASF-Spam-Status: No, hits=-8.9 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Mon, 14 Mar 2005 21:28:10 -0800 Received: (qmail 41742 invoked by uid 65534); 15 Mar 2005 05:28:09 -0000 Message-ID: <20050315052809.41741.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Mailer: svnmailer-1.0.0-dev Date: Tue, 15 Mar 2005 05:28:09 -0000 Subject: svn commit: r157519 - incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out To: derby-cvs@incubator.apache.org From: kmarsden@apache.org X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Author: kmarsden Date: Mon Mar 14 21:28:07 2005 New Revision: 157519 URL: http://svn.apache.org/viewcvs?view=3Drev&rev=3D157519 Log: Master update for network client odbc_metadata test Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/odbc_metadata.out (with props) Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/func= tionTests/master/DerbyNetClient/odbc_metadata.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.o= ut?view=3Dauto&rev=3D157519 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/odbc_metadata.out (added) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/odbc_metadata.out Mon Mar 14 21:28:07 2005 @@ -0,0 +1,502 @@ +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Begin ODBC 3.0 Compliance Te= sts =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D +SQLProcedures: +=3D=3D> ODBC type/name checking done. +SQLProcedureColumns: +=3D=3D> ODBC type/name checking done. +SQLTables: +=3D=3D> ODBC type/name checking done. +SQLColumns: +=3D=3D> ODBC type/name checking done. +SQLColumnPrivileges: +=3D=3D> ODBC type/name checking done. +SQLTablePrivileges: +=3D=3D> ODBC type/name checking done. +SQLSpecialColumns: getBestRowIdentifier +=3D=3D> ODBC type/name checking done. +SQLSpecialColumns: getVersionColumns +=3D=3D> ODBC type/name checking done. +SQLPrimaryKeys: +=3D=3D> ODBC type/name checking done. +SQLForeignKeys: getImportedKeys +=3D=3D> ODBC type/name checking done. +SQLForeignKeys: getExportedKeys +=3D=3D> ODBC type/name checking done. +SQLForeignKeys: getCrossReference +=3D=3D> ODBC type/name checking done. +SQLGetTypeInfo +=3D=3D> ODBC type/name checking done. +SQLStatistics: +=3D=3D> ODBC type/name checking done. +=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D End ODBC 3.0 Compliance Test= s =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D +Test metadata starting +Column display size of the union result is: 12 +dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL +dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL +real + dec(10,2) -- precision: 7 scale: 0 display size: 13 type name: REAL +double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 ty= pe name: DOUBLE +dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 ty= pe name: DOUBLE +result row: 11.10 11.10 14.4 -6.699999999999999 6.699999999999999 +Column result scale after division is: 23 +dc / 2 =3D 5.55000000000000000000000 +dc / 2 =3D 5.55500000000000000000000 +JDBC Driver 'Apache Derby Network Client JDBC Driver', version 10.1 (10.1.= 0=2E0 alpha) +The URL is: jdbc:derby://localhost:1527/wombat;create=3Dtrue +allTablesAreSelectable(): true +maxColumnNameLength(): 30 +getSchemas(): +TABLE_SCHEM[VARCHAR] +APP +NULLID +SQLJ +SYS +SYSCAT +SYSCS_DIAG +SYSCS_UTIL +SYSFUN +SYSIBM +SYSPROC +SYSSTAT +getCatalogs(): +TABLE_CAT[CHAR] +getSearchStringEscape():=20 +getSQLKeywords(): ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,= EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PR= OPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,S= TATISTICS,TIMING,WAIT +getDefaultTransactionIsolation(): 2 +getProcedures(): +PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],NU= M_INPUT_PARAMS[INTEGER],NUM_OUTPUT_PARAMS[INTEGER],NUM_RESULT_SETS[INTEGER]= ,REMARKS[VARCHAR],PROCEDURE_TYPE[SMALLINT] +,APP,GETPCTEST1,null,null,null,org.apache.derbyTesting.functionTests.tests= .jdbcapi.metadata.getpc,1 +,APP,GETPCTEST2,null,null,null,org.apache.derbyTesting.functionTests.tests= .jdbcapi.metadata.getpc,1 +,APP,GETPCTEST3A,null,null,null,org.apache.derbyTesting.functionTests.test= s=2Ejdbcapi.metadata.getpc,1 +,APP,GETPCTEST3B,null,null,null,org.apache.derbyTesting.functionTests.test= s=2Ejdbcapi.metadata.getpc,1 +,APP,GETPCTEST4A,null,null,null,org.apache.derbyTesting.functionTests.test= s=2Ejdbcapi.metadata.getpc4a,1 +,APP,GETPCTEST4B,null,null,null,org.apache.derbyTesting.functionTests.test= s=2Ejdbcapi.metadata.getpc4b,1 +,APP,GETPCTEST4BX,null,null,null,org.apache.derbyTesting.functionTests.tes= ts.jdbcapi.metadata.getpc4b,1 +allProceduresAreCallable(): true +getUserName(): APP +isReadOnly(): false +nullsAreSortedHigh(): true +nullsAreSortedLow(): false +nullsAreSortedAtStart(): false +nullsAreSortedAtEnd(): false +getDatabaseProductName(): Apache Derby +getDatabaseProductVersion(): 10.1.0.0 alpha +getDriverVersion(): 10.1.0.0 alpha +usesLocalFiles(): true +usesLocalFilePerTable(): true +supportsMixedCaseIdentifiers(): false +storesUpperCaseIdentifiers(): true +storesLowerCaseIdentifiers(): false +storesMixedCaseIdentifiers(): false +supportsMixedCaseQuotedIdentifiers(): true +storesUpperCaseQuotedIdentifiers(): false +storesLowerCaseQuotedIdentifiers(): false +storesMixedCaseQuotedIdentifiers(): true +getIdentifierQuoteString(): " +getNumericFunctions(): ABS,SQRT +getStringFunctions(): LENGTH,LOWER,LTRIM,RTRIM,SUBSTR,SUBSTRING,UPPER +getSystemFunctions(): CURRENT_USER,getCurrentConnection,runTimeStatistics,= SESSION_USER,USER,CURRENT SCHEMA +getTimeDateFunctions(): CURDATE,CURTIME,CURRENT_DATE,CURRENT_TIME,CURRENT_= TIMESTAMP,EXTRACT +getExtraNameCharacters():=20 +supportsAlterTableWithAddColumn(): true +supportsAlterTableWithDropColumn(): true +supportsColumnAliasing(): true +nullPlusNonNullIsNull(): true +supportsConvert(): true +supportsConvert(Types.INTEGER, Types.SMALLINT): false +supportsTableCorrelationNames(): true +supportsDifferentTableCorrelationNames(): true +supportsExpressionsInOrderBy(): false +supportsOrderByUnrelated(): false +supportsGroupBy(): true +supportsGroupByUnrelated(): true +supportsGroupByBeyondSelect(): true +supportsLikeEscapeClause(): true +supportsMultipleResultSets(): true +supportsMultipleTransactions(): true +supportsNonNullableColumns(): true +supportsMinimumSQLGrammar(): true +supportsCoreSQLGrammar(): false +supportsExtendedSQLGrammar(): false +supportsANSI92EntryLevelSQL(): true +supportsANSI92IntermediateSQL(): false +supportsANSI92FullSQL(): false +supportsIntegrityEnhancementFacility(): false +supportsOuterJoins(): true +supportsFullOuterJoins(): false +supportsLimitedOuterJoins(): true +getSchemaTerm(): SCHEMA +getProcedureTerm(): PROCEDURE +getCatalogTerm(): CATALOG +isCatalogAtStart(): false +getCatalogSeparator():=20 +supportsSchemasInDataManipulation(): true +supportsSchemasInProcedureCalls(): true +supportsSchemasInTableDefinitions(): true +supportsSchemasInIndexDefinitions(): true +supportsSchemasInPrivilegeDefinitions(): true +supportsCatalogsInDataManipulation(): false +supportsCatalogsInProcedureCalls(): false +supportsCatalogsInTableDefinitions(): false +supportsCatalogsInIndexDefinitions(): false +supportsCatalogsInPrivilegeDefinitions(): false +supportsPositionedDelete(): true +supportsPositionedUpdate(): true +supportsSelectForUpdate(): true +supportsStoredProcedures(): true +supportsSubqueriesInComparisons(): true +supportsSubqueriesInExists(): true +supportsSubqueriesInIns(): true +supportsSubqueriesInQuantifieds(): true +supportsCorrelatedSubqueries(): true +supportsUnion(): true +supportsUnionAll(): true +supportsOpenCursorsAcrossCommit(): false +supportsOpenCursorsAcrossRollback(): false +supportsOpenStatementsAcrossCommit(): true +supportsOpenStatementsAcrossRollback(): false +getMaxBinaryLiteralLength(): 0 +getMaxCharLiteralLength(): 0 +getMaxColumnsInGroupBy(): 0 +getMaxColumnsInIndex(): 0 +getMaxColumnsInOrderBy(): 0 +getMaxColumnsInSelect(): 0 +getMaxColumnsInTable(): 0 +getMaxConnections(): 0 +getMaxCursorNameLength(): 18 +getMaxIndexLength(): 0 +getMaxSchemaNameLength(): 30 +getMaxProcedureNameLength(): 128 +getMaxCatalogNameLength(): 0 +getMaxRowSize(): 0 +doesMaxRowSizeIncludeBlobs(): true +getMaxStatementLength(): 0 +getMaxStatements(): 0 +getMaxTableNameLength(): 128 +getMaxTablesInSelect(): 0 +getMaxUserNameLength(): 30 +supportsTransactions(): true +supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE): false +supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ):= true +supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE): tr= ue +supportsDataDefinitionAndDataManipulationTransactions(): true +supportsDataManipulationTransactionsOnly(): false +dataDefinitionCausesTransactionCommit(): false +dataDefinitionIgnoredInTransactions(): false +getConnection(): same connection +getProcedureColumns(): +PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],CO= LUMN_NAME[VARCHAR],COLUMN_TYPE[SMALLINT],DATA_TYPE[SMALLINT],TYPE_NAME[VARC= HAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],N= UM_PREC_RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARC= HAR],SQL_DATA_TYPE[SMALLINT],SQL_DATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[I= NTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR],METHOD_ID[SMALLINT],= PARAMETER_ID[SMALLINT] +null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,3,null,null,1,null,null,12,null,3,= 1,YES,12,0 +null,APP,GETPCTEST1,A,1,12,VARCHAR,3,3,null,null,1,null,null,12,null,3,2,Y= ES,12,1 +null,APP,GETPCTEST1,B,1,2,NUMERIC,5,6,0,10,1,null,null,2,null,null,3,YES,1= 2,2 +null,APP,GETPCTEST1,C,1,5,SMALLINT,5,2,0,10,1,null,null,5,null,null,4,YES,= 12,3 +null,APP,GETPCTEST1,E,1,5,SMALLINT,5,2,0,10,1,null,null,5,null,null,5,YES,= 12,4 +null,APP,GETPCTEST1,F,1,4,INTEGER,10,4,0,10,1,null,null,4,null,null,6,YES,= 12,5 +null,APP,GETPCTEST1,G,1,-5,BIGINT,19,8,0,10,1,null,null,-5,null,null,7,YES= ,12,6 +null,APP,GETPCTEST1,H,1,8,DOUBLE,52,8,null,2,1,null,null,8,null,null,8,YES= ,12,7 +null,APP,GETPCTEST1,I,1,8,DOUBLE,52,8,null,2,1,null,null,8,null,null,9,YES= ,12,8 +null,APP,GETPCTEST1,K,1,91,DATE,10,-1,null,2,1,null,null,9,1,null,10,YES,1= 2,9 +null,APP,GETPCTEST1,L,1,92,TIME,8,-1,0,2,1,null,null,9,2,null,11,YES,12,10 +null,APP,GETPCTEST1,T,1,93,TIMESTAMP,26,-1,0,2,1,null,null,9,3,null,12,YES= ,12,11 +null,APP,GETPCTEST2,PA,1,4,INTEGER,10,4,0,10,1,null,null,4,null,null,1,YES= ,2,0 +null,APP,GETPCTEST2,PB,1,-5,BIGINT,19,8,0,10,1,null,null,-5,null,null,2,YE= S,2,1 +null,APP,GETPCTEST3A,STRING1,1,12,VARCHAR,5,5,null,null,1,null,null,12,nul= l,5,1,YES,2,0 +null,APP,GETPCTEST3A,STRING2,4,12,VARCHAR,5,5,null,null,1,null,null,12,nul= l,5,2,YES,2,1 +null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,5,null,null,1,null,null,12,nul= l,5,1,YES,2,0 +null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,5,null,null,1,null,null,12,nul= l,5,2,YES,2,1 +null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,null,4,null,nu= ll,1,YES,1,0 +getTables() with TABLE_TYPE in ('SYSTEM TABLE') : +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VAR= CHAR],REMARKS[VARCHAR] +,SYS,SYSALIASES,SYSTEM TABLE, +,SYS,SYSCHECKS,SYSTEM TABLE, +,SYS,SYSCOLUMNS,SYSTEM TABLE, +,SYS,SYSCONGLOMERATES,SYSTEM TABLE, +,SYS,SYSCONSTRAINTS,SYSTEM TABLE, +,SYS,SYSDEPENDS,SYSTEM TABLE, +,SYS,SYSFILES,SYSTEM TABLE, +,SYS,SYSFOREIGNKEYS,SYSTEM TABLE, +,SYS,SYSKEYS,SYSTEM TABLE, +,SYS,SYSSCHEMAS,SYSTEM TABLE, +,SYS,SYSSTATEMENTS,SYSTEM TABLE, +,SYS,SYSSTATISTICS,SYSTEM TABLE, +,SYS,SYSTABLES,SYSTEM TABLE, +,SYS,SYSTRIGGERS,SYSTEM TABLE, +,SYS,SYSVIEWS,SYSTEM TABLE, +,SYSIBM,SYSDUMMY1,SYSTEM TABLE, +getTables() with no types: +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VAR= CHAR],REMARKS[VARCHAR] +,SYS,SYSALIASES,SYSTEM TABLE, +,SYS,SYSCHECKS,SYSTEM TABLE, +,SYS,SYSCOLUMNS,SYSTEM TABLE, +,SYS,SYSCONGLOMERATES,SYSTEM TABLE, +,SYS,SYSCONSTRAINTS,SYSTEM TABLE, +,SYS,SYSDEPENDS,SYSTEM TABLE, +,SYS,SYSFILES,SYSTEM TABLE, +,SYS,SYSFOREIGNKEYS,SYSTEM TABLE, +,SYS,SYSKEYS,SYSTEM TABLE, +,SYS,SYSSCHEMAS,SYSTEM TABLE, +,SYS,SYSSTATEMENTS,SYSTEM TABLE, +,SYS,SYSSTATISTICS,SYSTEM TABLE, +,SYS,SYSTABLES,SYSTEM TABLE, +,SYS,SYSTRIGGERS,SYSTEM TABLE, +,SYS,SYSVIEWS,SYSTEM TABLE, +,SYSIBM,SYSDUMMY1,SYSTEM TABLE, +,APP,ALLTYPES,TABLE, +,APP,INFLIGHT,TABLE, +,APP,LOUIE,TABLE, +,APP,REFTAB,TABLE, +,APP,REFTAB2,TABLE, +,APP,T,TABLE, +,APP,SCREWIE,VIEW, +getTables() with TABLE_TYPE in ('VIEW','TABLE') : +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VAR= CHAR],REMARKS[VARCHAR] +,APP,ALLTYPES,TABLE, +,APP,INFLIGHT,TABLE, +,APP,LOUIE,TABLE, +,APP,REFTAB,TABLE, +,APP,REFTAB2,TABLE, +,APP,T,TABLE, +,APP,SCREWIE,VIEW, +getTableTypes(): +TABLE_TYPE[VARCHAR] +SYSTEM TABLE +TABLE +VIEW +getColumns(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_L= ENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[S= MALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_D= ATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],= IS_NULLABLE[VARCHAR] +getColumns('SYSTABLES'): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_L= ENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[S= MALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_D= ATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],= IS_NULLABLE[VARCHAR] +,SYS,SYSTABLES,TABLEID,1,CHAR,36,72,null,null,0,,null,1,null,72,1,NO +,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,256,null,null,0,,null,12,null,256,= 2,NO +,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,2,null,null,0,,null,1,null,2,3,NO +,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,72,null,null,0,,null,1,null,72,4,NO +,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,2,null,null,0,,null,1,null,2,5,NO +getColumns('ALLTYPES'): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_L= ENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[S= MALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_D= ATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],= IS_NULLABLE[VARCHAR] +,APP,ALLTYPES,SMALLINTCOL,5,SMALLINT,5,2,0,10,1,,null,5,null,null,1,YES +,APP,ALLTYPES,INTCOL,4,INTEGER,10,4,0,10,1,,20,4,null,null,2,YES +,APP,ALLTYPES,BIGINTCOL,-5,BIGINT,19,8,0,10,1,,null,-5,null,null,3,YES +,APP,ALLTYPES,REALCOL,7,REAL,23,4,null,2,1,,null,7,null,null,4,YES +,APP,ALLTYPES,DOUBLEPRECCOL,8,DOUBLE,52,8,null,2,1,,10,8,null,null,5,YES +,APP,ALLTYPES,DECIMALCOL10P4S,3,DECIMAL,10,13,4,10,1,,null,3,null,null,6,Y= ES +,APP,ALLTYPES,NUMERICCOL20P2S,2,NUMERIC,20,23,2,10,1,,null,2,null,null,7,Y= ES +,APP,ALLTYPES,CHAR8COL___,1,CHAR,8,16,null,null,1,,null,1,null,16,8,YES +,APP,ALLTYPES,VARCHAR9COL,12,VARCHAR,9,18,null,null,1,,null,12,null,18,9,Y= ES +,APP,ALLTYPES,LONGVARCHARCOL,-1,LONG VARCHAR,32700,32700,null,null,1,,null= ,-1,null,null,10,YES +,APP,ALLTYPES,BLOBCOL,2004,BLOB,3072,3072,null,null,1,,null,2004,null,null= ,11,YES +getColumns('LOUIE'): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_L= ENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[S= MALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_D= ATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],= IS_NULLABLE[VARCHAR] +,APP,LOUIE,I,4,INTEGER,10,4,0,10,0,,10,4,null,null,1,NO +,APP,LOUIE,S,5,SMALLINT,5,2,0,10,0,,null,5,null,null,2,NO +,APP,LOUIE,C30,1,CHAR,30,60,null,null,0,,null,1,null,60,3,NO +,APP,LOUIE,VC10,12,VARCHAR,10,20,null,null,0,,'asdf',12,null,20,4,NO +,APP,LOUIE,AI,-5,BIGINT,19,8,0,10,0,,AUTOINCREMENT: start -10 increment 20= 01,-5,null,null,5,NO +getColumns('INFLIGHT'): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_L= ENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[S= MALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_D= ATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],= IS_NULLABLE[VARCHAR] +,APP,INFLIGHT,FLT_NUM,1,CHAR,20,40,null,null,0,,null,1,null,40,1,NO +,APP,INFLIGHT,FLT_ORIGIN,1,CHAR,6,12,null,null,1,,null,1,null,12,2,YES +,APP,INFLIGHT,FLT_DEST,1,CHAR,6,12,null,null,1,,null,1,null,12,3,YES +,APP,INFLIGHT,FLT_AIRCRAFT,1,CHAR,20,40,null,null,1,,null,1,null,40,4,YES +,APP,INFLIGHT,FLT_FLYING_TIME,12,VARCHAR,22,44,null,null,1,,null,12,null,4= 4,5,YES +,APP,INFLIGHT,FLT_DEPT_TIME,1,CHAR,8,16,null,null,1,,null,1,null,16,6,YES +,APP,INFLIGHT,FLT_ARR_TIME,1,CHAR,8,16,null,null,1,,null,1,null,16,7,YES +,APP,INFLIGHT,FLT_NOTES,12,VARCHAR,510,1020,null,null,1,,null,12,null,1020= ,8,YES +,APP,INFLIGHT,FLT_DAYS_OF_WK,1,CHAR,14,28,null,null,1,,null,1,null,28,9,YES +,APP,INFLIGHT,FLT_CRAFT_PIC,12,VARCHAR,32672,65344,null,null,1,,null,12,nu= ll,65344,10,YES +getColumnPrivileges(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],GRANTOR[VARCHAR],GRANTEE[VARCHAR],PRIVILEGE[VARCHAR],IS_GRANTABLE[VA= RCHAR] +getTablePrivileges(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],GRANTOR[VARCHA= R],GRANTEE[VARCHAR],PRIVILEGE[VARCHAR],IS_GRANTABLE[VARCHAR] +getBestRowIdentifier("",null,"LOUIE"): +SCOPE[SMALLINT],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR= ],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],PSEU= DO_COLUMN[SMALLINT] +2,I,4,INTEGER,4,4,10,1 +2,VC10,12,VARCHAR,10,20,null,1 +getBestRowIdentifier("","SYS","SYSTABLES"): +SCOPE[SMALLINT],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR= ],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],PSEU= DO_COLUMN[SMALLINT] +2,TABLEID,1,CHAR,36,72,null,1 +getVersionColumns(): +SCOPE[SMALLINT],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR= ],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],PSEU= DO_COLUMN[SMALLINT] +getPrimaryKeys(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],KEY_SEQ[SMALLINT],PK_NAME[VARCHAR] +,APP,LOUIE,I,2,PRIMKEY +,APP,LOUIE,VC10,1,PRIMKEY +getPrimaryKeys(null, null, tablename): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],KEY_SEQ[SMALLINT],PK_NAME[VARCHAR] +,APP,LOUIE,I,2,PRIMKEY +,APP,LOUIE,VC10,1,PRIMKEY +getImportedKeys(): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB2,T2_VC10,1,3,3,T2_FKEY1,PRIMKEY,7 +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB2,T2_I,2,3,3,T2_FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,REFTAB,DPRIM,,APP,REFTAB,DFOR,1,3,3,FKEYSELF,PKEY_REFTAB,7 +getExportedKeys(): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +,APP,REFTAB,DPRIM,,APP,REFTAB,DFOR,1,3,3,FKEYSELF,PKEY_REFTAB,7 +,APP,LOUIE,VC10,,APP,REFTAB2,T2_VC10,1,3,3,T2_FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB2,T2_I,2,3,3,T2_FKEY1,PRIMKEY,7 +----- +getCrossReference('',null,'louie','',null,'reftab' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +getCrossReference('','APP','reftab','',null,'reftab' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFTAB,DPRIM,,APP,REFTAB,DFOR,1,3,3,FKEYSELF,PKEY_REFTAB,7 +getCrossReference('',null,null,'','APP','reftab' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +,APP,REFTAB,DPRIM,,APP,REFTAB,DFOR,1,3,3,FKEYSELF,PKEY_REFTAB,7 +getImportedKeys('',null,null,'','APP','reftab' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,REFTAB,DPRIM,,APP,REFTAB,DFOR,1,3,3,FKEYSELF,PKEY_REFTAB,7 +getCrossReference('',null,'louie','','APP',null): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,VC10,,APP,REFTAB2,T2_VC10,1,3,3,T2_FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB2,T2_I,2,3,3,T2_FKEY1,PRIMKEY,7 +getExportedKeys('',null,'louie,'','APP',null ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,LOUIE,VC10,,APP,REFTAB,VC10,1,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB,I,2,3,3,FKEY1,PRIMKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S2,2,3,3,FKEY2,UNIQUEKEY,7 +,APP,LOUIE,C30,,APP,REFTAB,C30,1,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,S,,APP,REFTAB,S,2,3,3,FKEY3,UNIQUEKEY,7 +,APP,LOUIE,VC10,,APP,REFTAB2,T2_VC10,1,3,3,T2_FKEY1,PRIMKEY,7 +,APP,LOUIE,I,,APP,REFTAB2,T2_I,2,3,3,T2_FKEY1,PRIMKEY,7 +getCrossReference('','badschema','LOUIE','','APP','REFTAB' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +getTypeInfo(): +TYPE_NAME[VARCHAR],DATA_TYPE[SMALLINT],COLUMN_SIZE[INTEGER],LITERAL_PREFIX= [VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[SMALLINT]= ,CASE_SENSITIVE[SMALLINT],SEARCHABLE[SMALLINT],UNSIGNED_ATTRIBUTE[SMALLINT]= ,FIXED_PREC_SCALE[SMALLINT],AUTO_UNIQUE_VAL[SMALLINT],LOCAL_TYPE_NAME[VARCH= AR],MINIMUM_SCALE[SMALLINT],MAXIMUM_SCALE[SMALLINT],SQL_DATA_TYPE[SMALLINT]= ,SQL_DATETIME_SUB[SMALLINT],NUM_PREC_RADIX[INTEGER],INTERVAL_PRECISION[SMAL= LINT] +BIGINT,-5,19,null,null,null,1,0,2,0,0,1,BIGINT,0,0,-5,null,10,null +LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,0,2,null,0,null,LONG VARCHA= R FOR BIT DATA,null,null,-4,null,null,null +VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,0,2,null,0,null,VARCHAR () = FOR BIT DATA,null,null,-3,null,null,null +CHAR () FOR BIT DATA,-2,254,X',',length,1,0,2,null,0,null,CHAR () FOR BIT = DATA,null,null,-2,null,null,null +LONG VARCHAR,-1,32700,',',null,1,1,3,null,0,null,LONG VARCHAR,null,null,-1= ,null,null,null +LONG NVARCHAR,-1,32700,',',null,1,1,3,null,0,null,LONG NVARCHAR,null,null,= -1,null,null,null +CHAR,1,254,',',length,1,1,3,null,0,null,CHAR,null,null,1,null,null,null +NATIONAL CHAR,1,2147483647,',',length,1,1,3,null,0,null,NATIONAL CHAR,null= ,null,1,null,null,null +NUMERIC,2,31,null,null,precision,scale,1,0,2,0,1,0,NUMERIC,0,32767,2,null,= 10,null +DECIMAL,3,31,null,null,precision,scale,1,0,2,0,1,0,DECIMAL,0,32767,3,null,= 10,null +INTEGER,4,10,null,null,null,1,0,2,0,0,1,INTEGER,0,0,4,null,10,null +SMALLINT,5,5,null,null,null,1,0,2,0,0,1,SMALLINT,0,0,5,null,10,null +FLOAT,6,52,null,null,precision,1,0,2,0,0,0,FLOAT,null,null,6,null,2,null +REAL,7,23,null,null,null,1,0,2,0,0,0,REAL,null,null,7,null,2,null +DOUBLE,8,52,null,null,null,1,0,2,0,0,0,DOUBLE,null,null,8,null,2,null +VARCHAR,12,32672,',',length,1,1,3,null,0,null,VARCHAR,null,null,12,null,nu= ll,null +NATIONAL CHAR VARYING,12,2147483647,',',length,1,1,3,null,0,null,NATIONAL = CHAR VARYING,null,null,12,null,null,null +DATE,91,10,DATE',',null,1,0,2,1,0,0,DATE,0,0,9,1,2,null +TIME,92,0,TIME',',null,1,0,2,1,0,0,TIME,0,0,9,2,2,null +TIMESTAMP,93,0,TIMESTAMP',',null,1,0,2,1,0,0,TIMESTAMP,0,0,9,3,2,null +BLOB,2004,2147483647,null,null,length,1,0,1,null,0,null,BLOB,null,null,200= 4,null,null,null +CLOB,2005,2147483647,',',length,1,1,1,null,0,null,CLOB,null,null,2005,null= ,null,null +getIndexInfo(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMA= LLINT],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_= POSITION[SMALLINT],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEG= ER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] +,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null +,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null +getIndexInfo(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMA= LLINT],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_= POSITION[SMALLINT],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEG= ER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] +,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null +,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null +,SYS,SYSCOLUMNS,1,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null +getIndexInfo(): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMA= LLINT],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_= POSITION[SMALLINT],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEG= ER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] +,SYS,SYSTABLES,0,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null +,SYS,SYSTABLES,0,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null +,SYS,SYSTABLES,0,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null +getColumns('SYSTABLES'): +TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VA= RCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_L= ENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[S= MALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_D= ATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],= IS_NULLABLE[VARCHAR] +,SYS,SYSTABLES,TABLEID,1,CHAR,36,72,null,null,0,,null,1,null,72,1,NO +,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,256,null,null,0,,null,12,null,256,= 2,NO +,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,2,null,null,0,,null,1,null,2,3,NO +,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,72,null,null,0,,null,1,null,72,4,NO +,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,2,null,null,0,,null,1,null,2,5,NO +OK -- user result set closed by intervening OBDC getColumns request; this = was expected because of the way the test works. +----- +Referential action values +RESTRICT =3D 1 +NO ACTION =3D 3 +CASCADE =3D 0 +SETNULL =3D 2 +SETDEFAULT =3D 4 +getCrossReference('','APP','REFACTION1','','APP','REFACTIONNONE' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERAT= ED-IDxxxx,7 +getCrossReference('','APP','REFACTION1','','APP','REFACTRESTRICT' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,xxxxGENERATED-IDxxxx,xxxxGEN= ERATED-IDxxxx,7 +getCrossReference('','APP','REFACTION1','','APP','REFACTNOACTION' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGEN= ERATED-IDxxxx,7 +getCrossReference('','APP','REFACTION1','','APP','REFACTCASCADE' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTCASCADE,A,1,3,0,xxxxGENERATED-IDxxxx,xxxxGENE= RATED-IDxxxx,7 +getCrossReference('','APP','REFACTION1','','APP','REFACTSETNULL' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,xxxxGENERATED-IDxxxx,xxxxGENE= RATED-IDxxxx,7 +getCrossReference('','APP','REFACTION1','','APP','REFACTUPDRESTRICT' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,xxxxGENERATED-IDxxxx,xxxx= GENERATED-IDxxxx,7 +getCrossReference('','APP','REFACTION1','','APP','REFACTUPDNOACTION' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxx= GENERATED-IDxxxx,7 +getImportedKeys - none update Passed +getImportedKeys - none delete Passed +getImportedKeys - delete Restrict Passed +getImportedKeys - delete NO ACTION Passed +getImportedKeys - delete CASCADE Passed +getImportedKeys - delete SET NULL Passed +getImportedKeys - update Restrict Passed +getImportedKeys - update NO ACTION Passed +getExportedKeys('',null,null,'','APP','REFACTION1' ): +PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN= _NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VAR= CHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE= _RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT] +,APP,REFACTION1,A,,APP,REFACTCASCADE,A,1,3,0,xxxxGENERATED-IDxxxx,xxxxGENE= RATED-IDxxxx,7 +,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGEN= ERATED-IDxxxx,7 +,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERAT= ED-IDxxxx,7 +,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,xxxxGENERATED-IDxxxx,xxxxGEN= ERATED-IDxxxx,7 +,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,xxxxGENERATED-IDxxxx,xxxxGENE= RATED-IDxxxx,7 +,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxx= GENERATED-IDxxxx,7 +,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,xxxxGENERATED-IDxxxx,xxxx= GENERATED-IDxxxx,7 +----- +getColumns for 'T1' + Next line is real null. +defval for col C1 type INTEGER DEFAULT 'null' wasnull true + Next line is real null. +defval for col C2 type INTEGER DEFAULT 'null' wasnull true +defval for col C3 type INTEGER DEFAULT 'NULL' wasnull false + Next line is real null. +defval for col C4 type CHAR DEFAULT 'null' wasnull true +defval for col C5 type CHAR DEFAULT 'NULL' wasnull false +defval for col C6 type CHAR DEFAULT ''NULL'' wasnull false +defval for col C7 type INTEGER DEFAULT '88' wasnull false +Test metadata finished Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting= /functionTests/master/DerbyNetClient/odbc_metadata.out ---------------------------------------------------------------------------= --- svn:eol-style =3D native