START - phase CREATE db version 10.1 jdbc url is jdbc:derby:updtest_10_1/su_10_1;create=true Engine Apache Derby 10.1.2.2 complete caseConnectionCheck - passed true complete caseInitialize - passed true complete caseProcedures - passed true Test metadata starting Column display size of the union result is: 13 dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL dec(10,2) -- precision: 10 scale: 2 display size: 13 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 type name: DOUBLE dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE result row: 11.10 11.10 14.4 -6.699999999999999 6.699999999999999 Column result scale after division is: 23 dc / 2 = 5.55000000000000000000000 dc / 2 = 5.55500000000000000000000 JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.1 (10.1.2.2) The URL is: jdbc:derby:updtest_10_1/su_10_1 allTablesAreSelectable(): true maxColumnNameLength(): 128 getSchemas(): TABLE_SCHEM[VARCHAR] APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT getCatalogs(): TABLE_CAT[CHAR] getSearchStringEscape(): getSQLKeywords(): ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATISTICS,TIMING,WAIT getDefaultTransactionIsolation(): 2 getProcedures(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],RESERVED1[INTEGER],RESERVED2[INTEGER],RESERVED3[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.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST3B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST4A,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4a,1 ,APP,GETPCTEST4B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 ,APP,GETPCTEST4BX,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 getUDTs() with user-named types null : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('DISTINCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT', 'STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] allProceduresAreCallable(): true getUserName(): APP isReadOnly(): false nullsAreSortedHigh(): true nullsAreSortedLow(): false nullsAreSortedAtStart(): false nullsAreSortedAtEnd(): false getDatabaseProductName(): Apache Derby getDatabaseProductVersion(): 10.1.2.2 getDriverVersion(): 10.1.2.2 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(): 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(): false supportsANSI92IntermediateSQL(): false supportsANSI92FullSQL(): false supportsIntegrityEnhancementFacility(): false supportsOuterJoins(): true supportsFullOuterJoins(): false supportsLimitedOuterJoins(): true getSchemaTerm(): SCHEMA getProcedureTerm(): PROCEDURE getCatalogTerm(): CATALOG isCatalogAtStart(): false getCatalogSeparator(): 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(): 128 getMaxIndexLength(): 0 getMaxSchemaNameLength(): 128 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): true supportsDataDefinitionAndDataManipulationTransactions(): true supportsDataManipulationTransactionsOnly(): false dataDefinitionCausesTransactionCommit(): false dataDefinitionIgnoredInTransactions(): false Test the metadata calls related to visibility of changes made by others for different resultset types Since Derby materializes a forward only ResultSet incrementally, it is possible to see changes made by others and hence following 3 metadata calls will return true for forward only ResultSets. othersUpdatesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true Scroll insensitive ResultSet by their definition do not see changes made by others and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false Derby does not yet implement scroll sensitive resultsets and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false SupportsResultSetConcurrency: TYPE_FORWARD_ONLY,CONCUR_READ_ONLY: true SupportsResultSetConcurrency: TYPE_FORWARD_ONLY,CONCUR_UPDATABLE: true SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY: true SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_UPDATABLE: false SupportsResultSetConcurrency: TYPE_SCROLL_SENSITIVE,CONCUR_READ_ONLY: false SupportsResultSetConcurrency: TYPE_SCROLL_SENSITIVE,CONCUR_UPDATABLE: false getConnection(): same connection getProcedureColumns(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],COLUMN_TYPE[SMALLINT],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],PRECISION[INTEGER],LENGTH[INTEGER],SCALE[SMALLINT],RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],METHOD_ID[SMALLINT],PARAMETER_ID[SMALLINT] null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,6,null,null,1,null,12,0 null,APP,GETPCTEST1,A,1,12,VARCHAR,3,6,null,null,1,null,12,1 null,APP,GETPCTEST1,B,1,2,NUMERIC,5,14,0,10,1,null,12,2 null,APP,GETPCTEST1,C,1,5,SMALLINT,5,2,0,10,1,null,12,3 null,APP,GETPCTEST1,E,1,5,SMALLINT,5,2,0,10,1,null,12,4 null,APP,GETPCTEST1,F,1,4,INTEGER,10,4,0,10,1,null,12,5 null,APP,GETPCTEST1,G,1,-5,BIGINT,19,40,0,10,1,null,12,6 null,APP,GETPCTEST1,H,1,8,DOUBLE,52,8,null,2,1,null,12,7 null,APP,GETPCTEST1,I,1,8,DOUBLE,52,8,null,2,1,null,12,8 null,APP,GETPCTEST1,K,1,91,DATE,10,6,0,10,1,null,12,9 null,APP,GETPCTEST1,L,1,92,TIME,8,6,0,10,1,null,12,10 null,APP,GETPCTEST1,T,1,93,TIMESTAMP,26,16,6,10,1,null,12,11 null,APP,GETPCTEST2,PA,1,4,INTEGER,10,4,0,10,1,null,2,0 null,APP,GETPCTEST2,PB,1,-5,BIGINT,19,40,0,10,1,null,2,1 null,APP,GETPCTEST3A,STRING1,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3A,STRING2,4,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,1,0 getTables() with TABLE_TYPE in ('SYSTEM TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],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[VARCHAR],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,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTables() with TABLE_TYPE in ('VIEW','TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR] ,APP,ALLTYPES,TABLE, ,APP,INFLIGHT,TABLE, ,APP,LOUIE,TABLE, ,APP,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTableTypes(): TABLE_TYPE[VARCHAR] SYSTEM TABLE TABLE VIEW getColumns(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO getColumns('ALLTYPES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,ALLTYPES,SMALLINTCOL,5,SMALLINT,5,null,0,10,1,,null,null,null,null,1,YES ,APP,ALLTYPES,INTCOL,4,INTEGER,10,null,0,10,1,,20,null,null,null,2,YES ,APP,ALLTYPES,BIGINTCOL,-5,BIGINT,19,null,0,10,1,,null,null,null,null,3,YES ,APP,ALLTYPES,REALCOL,7,REAL,23,null,null,2,1,,null,null,null,null,4,YES ,APP,ALLTYPES,DOUBLEPRECCOL,8,DOUBLE,52,null,null,2,1,,10,null,null,null,5,YES ,APP,ALLTYPES,FLOATCOL,8,DOUBLE,52,null,null,2,1,,8.8,null,null,null,6,YES ,APP,ALLTYPES,DECIMALCOL10P4S,3,DECIMAL,10,null,4,10,1,,null,null,null,null,7,YES ,APP,ALLTYPES,NUMERICCOL20P2S,2,NUMERIC,20,null,2,10,1,,null,null,null,null,8,YES ,APP,ALLTYPES,CHAR8COL___,1,CHAR,8,null,null,null,1,,null,null,null,16,9,YES ,APP,ALLTYPES,CHAR8FORBITCOL___,-2,CHAR () FOR BIT DATA,8,null,null,null,1,,null,null,null,null,10,YES ,APP,ALLTYPES,VARCHAR9COL,12,VARCHAR,9,null,null,null,1,,null,null,null,18,11,YES ,APP,ALLTYPES,VARCHAR9BITCOL,-3,VARCHAR () FOR BIT DATA,9,null,null,null,1,,null,null,null,null,12,YES ,APP,ALLTYPES,LONGVARCHARCOL,-1,LONG VARCHAR,32700,null,null,null,1,,null,null,null,null,13,YES ,APP,ALLTYPES,LONGVARBINARYCOL,-4,LONG VARCHAR FOR BIT DATA,32700,null,null,null,1,,null,null,null,null,14,YES ,APP,ALLTYPES,BLOBCOL,2004,BLOB,3072,null,null,null,1,,null,null,null,null,15,YES ,APP,ALLTYPES,CLOBCOL,2005,CLOB,3072,null,null,null,1,,null,null,null,null,16,YES ,APP,ALLTYPES,DATECOL,91,DATE,10,null,0,10,1,,null,null,null,null,17,YES ,APP,ALLTYPES,TIMECOL,92,TIME,8,null,0,10,1,,null,null,null,null,18,YES ,APP,ALLTYPES,TSCOL,93,TIMESTAMP,26,null,6,10,1,,null,null,null,null,19,YES getColumns('LOUIE'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,LOUIE,I,4,INTEGER,10,null,0,10,0,,10,null,null,null,1,NO ,APP,LOUIE,S,5,SMALLINT,5,null,0,10,0,,null,null,null,null,2,NO ,APP,LOUIE,C30,1,CHAR,30,null,null,null,0,,null,null,null,60,3,NO ,APP,LOUIE,VC10,12,VARCHAR,10,null,null,null,0,,'asdf',null,null,20,4,NO ,APP,LOUIE,AI,-5,BIGINT,19,null,0,10,0,,AUTOINCREMENT: start -10 increment 2001,null,null,null,5,NO getColumns('INFLIGHT'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,INFLIGHT,FLT_NUM,1,CHAR,20,null,null,null,0,,null,null,null,40,1,NO ,APP,INFLIGHT,FLT_ORIGIN,1,CHAR,6,null,null,null,1,,null,null,null,12,2,YES ,APP,INFLIGHT,FLT_DEST,1,CHAR,6,null,null,null,1,,null,null,null,12,3,YES ,APP,INFLIGHT,FLT_AIRCRAFT,1,CHAR,20,null,null,null,1,,null,null,null,40,4,YES ,APP,INFLIGHT,FLT_FLYING_TIME,12,VARCHAR,22,null,null,null,1,,null,null,null,44,5,YES ,APP,INFLIGHT,FLT_DEPT_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,6,YES ,APP,INFLIGHT,FLT_ARR_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,7,YES ,APP,INFLIGHT,FLT_NOTES,12,VARCHAR,510,null,null,null,1,,null,null,null,1020,8,YES ,APP,INFLIGHT,FLT_DAYS_OF_WK,1,CHAR,14,null,null,null,1,,null,null,null,28,9,YES ,APP,INFLIGHT,FLT_CRAFT_PIC,12,VARCHAR,32672,null,null,null,1,,null,null,null,65344,10,YES getColumnPrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],GRANTOR[VARCHAR],GRANTEE[VARCHAR],PRIVILEGE[VARCHAR],IS_GRANTABLE[VARCHAR] getTablePrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],GRANTOR[VARCHAR],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],PSEUDO_COLUMN[SMALLINT] 2,I,4,INTEGER,4,null,10,1 2,VC10,12,VARCHAR,10,null,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],PSEUDO_COLUMN[SMALLINT] 2,TABLEID,1,CHAR,36,null,null,1 getVersionColumns(): SCOPE[INTEGER],COLUMN_NAME[VARCHAR],DATA_TYPE[INTEGER],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],PSEUDO_COLUMN[INTEGER] getPrimaryKeys(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[INTEGER],CASE_SENSITIVE[BOOLEAN],SEARCHABLE[INTEGER],UNSIGNED_ATTRIBUTE[BOOLEAN],FIXED_PREC_SCALE[BOOLEAN],AUTO_INCREMENT[BOOLEAN],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[INTEGER],MAXIMUM_SCALE[INTEGER],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],NUM_PREC_RADIX[INTEGER] BIGINT,-5,19,null,null,null,1,false,2,false,false,true,BIGINT,0,0,null,null,10 LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,false,2,true,false,false,LONG VARCHAR FOR BIT DATA,null,null,null,null,null VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,false,2,true,false,false,VARCHAR () FOR BIT DATA,null,null,null,null,null CHAR () FOR BIT DATA,-2,254,X',',length,1,false,2,true,false,false,CHAR () FOR BIT DATA,null,null,null,null,null LONG VARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG VARCHAR,null,null,null,null,null LONG NVARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG NVARCHAR,null,null,null,null,null CHAR,1,254,',',length,1,true,3,true,false,false,CHAR,null,null,null,null,null NATIONAL CHAR,1,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR,null,null,null,null,null NUMERIC,2,31,null,null,precision,scale,1,false,2,false,true,false,NUMERIC,0,32767,null,null,10 DECIMAL,3,31,null,null,precision,scale,1,false,2,false,true,false,DECIMAL,0,32767,null,null,10 INTEGER,4,10,null,null,null,1,false,2,false,false,true,INTEGER,0,0,null,null,10 SMALLINT,5,5,null,null,null,1,false,2,false,false,true,SMALLINT,0,0,null,null,10 FLOAT,6,52,null,null,precision,1,false,2,false,false,false,FLOAT,null,null,null,null,2 REAL,7,23,null,null,null,1,false,2,false,false,false,REAL,null,null,null,null,2 DOUBLE,8,52,null,null,null,1,false,2,false,false,false,DOUBLE,null,null,null,null,2 VARCHAR,12,32672,',',length,1,true,3,true,false,false,VARCHAR,null,null,null,null,null NATIONAL CHAR VARYING,12,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR VARYING,null,null,null,null,null DATE,91,10,DATE',',null,1,false,2,true,false,false,DATE,0,0,null,null,10 TIME,92,8,TIME',',null,1,false,2,true,false,false,TIME,0,0,null,null,10 TIMESTAMP,93,26,TIMESTAMP',',null,1,false,2,true,false,false,TIMESTAMP,0,6,null,null,10 BLOB,2004,2147483647,null,null,length,1,false,1,null,false,null,BLOB,null,null,null,null,null CLOB,2005,2147483647,',',length,1,true,1,null,false,null,CLOB,null,null,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null ,SYS,SYSCOLUMNS,true,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO Test escaped numeric functions - JDBC 3.0 C.1 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ABS(-25.67) } -- = >25.67< << Executing VALUES { fn SQRT(6.22) } -- = >2.49< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ACOS(1.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13. Executing VALUES { fn ASIN(1.21) } -- SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13. Executing VALUES { fn ATAN(0.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN" at line 1, column 13. Executing VALUES { fn ATAN2(0.56, 1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN2" at line 1, column 13. Executing VALUES { fn CEILING(3.45) } -- SQLSTATE(42X01): Syntax error: Encountered "CEILING" at line 1, column 13. Executing VALUES { fn COS(1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "COS" at line 1, column 13. Executing VALUES { fn COT(3.4) } -- SQLSTATE(42X01): Syntax error: Encountered "COT" at line 1, column 13. Executing VALUES { fn DEGREES(2.1) } -- SQLSTATE(42X01): Syntax error: Encountered "DEGREES" at line 1, column 13. Executing VALUES { fn EXP(2.3) } -- SQLSTATE(42X01): Syntax error: Encountered "EXP" at line 1, column 13. Executing VALUES { fn FLOOR(3.22) } -- SQLSTATE(42X01): Syntax error: Encountered "FLOOR" at line 1, column 13. Executing VALUES { fn LOG(34.1) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG" at line 1, column 13. Executing VALUES { fn LOG10(18.7) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG10" at line 1, column 13. Executing VALUES { fn MOD(124, 7) } -- = >5< << FAIL function works but not declared in list: MOD Executing VALUES { fn PI() } -- SQLSTATE(42X01): Syntax error: Encountered "PI" at line 1, column 13. Executing VALUES { fn POWER(2, 3) } -- SQLSTATE(42X01): Syntax error: Encountered "POWER" at line 1, column 13. Executing VALUES { fn RADIANS(54) } -- SQLSTATE(42X01): Syntax error: Encountered "RADIANS" at line 1, column 13. Executing VALUES { fn RAND(17) } -- SQLSTATE(42X01): Syntax error: Encountered "RAND" at line 1, column 13. Executing VALUES { fn ROUND(345.345, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "ROUND" at line 1, column 13. Executing VALUES { fn SIGN(-34) } -- SQLSTATE(42X01): Syntax error: Encountered "SIGN" at line 1, column 13. Executing VALUES { fn SIN(0.32) } -- SQLSTATE(42X01): Syntax error: Encountered "SIN" at line 1, column 13. Executing VALUES { fn TAN(0.57) } -- SQLSTATE(42X01): Syntax error: Encountered "TAN" at line 1, column 13. Executing VALUES { fn TRUNCATE(345.395, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "TRUNCATE" at line 1, column 13. Test escaped string functions - JDBC 3.0 C.2 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn LENGTH('four ') } -- = >4< << FAIL Non-JDBC spec function in list: LOWER Executing VALUES { fn LTRIM(' left trim ') } -- = >left trim < << Executing VALUES { fn RTRIM(' right trim ') } -- = > right trim< << FAIL Non-JDBC spec function in list: SUBSTR Executing VALUES { fn SUBSTRING('Ruby the Rubicon Jeep', 10, 7) } -- = >Rubicon< << FAIL Non-JDBC spec function in list: UPPER TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ASCII('Yellow') } -- SQLSTATE(42X01): Syntax error: Encountered "ASCII" at line 1, column 13. Executing VALUES { fn CHAR(65) } -- = >65 < << FAIL function works but not declared in list: CHAR Executing VALUES { fn CONCAT('hello', 'there') } -- = >hellothere< << FAIL function works but not declared in list: CONCAT Executing VALUES { fn DIFFERENCE('Pires', 'Piers') } -- SQLSTATE(42X01): Syntax error: Encountered "DIFFERENCE" at line 1, column 13. Executing VALUES { fn INSERT('Bill Clinton', 4, 'William') } -- SQLSTATE(42X01): Syntax error: Encountered "INSERT" at line 1, column 13. Executing VALUES { fn LCASE('Fernando Alonso') } -- = >fernando alonso< << FAIL function works but not declared in list: LCASE Executing VALUES { fn LEFT('Bonjour', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "LEFT" at line 1, column 13. Executing VALUES { fn LOCATE('jour', 'Bonjour') } -- = >4< << FAIL function works but not declared in list: LOCATE Executing VALUES { fn REPEAT('echo', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "REPEAT" at line 1, column 13. Executing VALUES { fn REPLACE('to be or not to be', 'be', 'England') } -- SQLSTATE(42X01): Syntax error: Encountered "REPLACE" at line 1, column 13. Executing VALUES { fn SOUNDEX('Derby') } -- SQLSTATE(42X01): Syntax error: Encountered "SOUNDEX" at line 1, column 13. Executing VALUES { fn SPACE(12) } -- SQLSTATE(42X01): Syntax error: Encountered "SPACE" at line 1, column 13. Executing VALUES { fn UCASE('Fernando Alonso') } -- = >FERNANDO ALONSO< << FAIL function works but not declared in list: UCASE Test escaped date time functions - JDBC 3.0 C.3 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END -- = >OK< << Executing VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END -- = >OK< << FAIL Non-JDBC spec function in list: CURRENT_DATE FAIL Non-JDBC spec function in list: CURRENT_TIME FAIL Non-JDBC spec function in list: CURRENT_TIMESTAMP FAIL Non-JDBC spec function in list: EXTRACT TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DAYNAME({d '1995-12-19'h}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYNAME" at line 1, column 13. Executing VALUES { fn DAYOFMONTH({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFMONTH" at line 1, column 13. Executing VALUES { fn DAYOFWEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFWEEK" at line 1, column 13. Executing VALUES { fn DAYOFYEAR({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFYEAR" at line 1, column 13. Executing VALUES { fn HOUR({t '16:13:03'}) } -- = >16< << FAIL function works but not declared in list: HOUR Executing VALUES { fn MINUTE({t '16:13:03'}) } -- = >13< << FAIL function works but not declared in list: MINUTE Executing VALUES { fn MONTH({d '1995-12-19'}) } -- = >12< << FAIL function works but not declared in list: MONTH Executing VALUES { fn MONTHNAME({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "MONTHNAME" at line 1, column 13. Executing VALUES CASE WHEN { fn NOW()} = CURRENT_TIMESTAMP THEN 'OK' ELSE 'wrong' END -- SQLSTATE(42X01): Syntax error: Encountered "NOW" at line 1, column 23. Executing VALUES { fn QUARTER({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "QUARTER" at line 1, column 13. Executing VALUES { fn SECOND({t '16:13:03'}) } -- = >3< << FAIL function works but not declared in list: SECOND Executing VALUES { fn TIMESTAMPADD(SQL_TSI_DAY, 7, {ts '1995-12-19 12:15:54'}) } -- = >1995-12-26 12:15:54.0< << FAIL function works but not declared in list: TIMESTAMPADD Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts '1995-12-19 12:15:54'}, {ts '1997-11-02 00:15:23'}) } -- = >683< << FAIL function works but not declared in list: TIMESTAMPDIFF Executing VALUES { fn WEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "WEEK" at line 1, column 13. Executing VALUES { fn YEAR({d '1995-12-19'}) } -- = >1995< << FAIL function works but not declared in list: YEAR Test escaped system functions - JDBC 3.0 C.4 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST FAIL Non-JDBC spec function in list: CURRENT_USER FAIL Non-JDBC spec function in list: getCurrentConnection FAIL Non-JDBC spec function in list: runTimeStatistics FAIL Non-JDBC spec function in list: SESSION_USER Executing VALUES { fn USER() } -- = >APP< << FAIL Non-JDBC spec function in list: CURRENT SCHEMA TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DATABASE() } -- SQLSTATE(42X01): Syntax error: Encountered "DATABASE" at line 1, column 13. Executing VALUES { fn IFNULL('this', 'that') } -- SQLSTATE(42X01): Syntax error: Encountered "IFNULL" at line 1, column 13. --------------------------------------- Referential action values RESTRICT = 1 NO ACTION = 3 CASCADE = 0 SETNULL = 2 SETDEFAULT = 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[VARCHAR],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,SQL051211105504340,SQL051211105504060,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[VARCHAR],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,SQL051211105504700,SQL051211105504060,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[VARCHAR],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,SQL051211105505020,SQL051211105504060,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[VARCHAR],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,SQL051211105505480,SQL051211105504060,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[VARCHAR],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,SQL051211105505900,SQL051211105504060,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[VARCHAR],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,SQL051211105506230,SQL051211105504060,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[VARCHAR],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,SQL051211105506530,SQL051211105504060,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[VARCHAR],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,SQL051211105505480,SQL051211105504060,7 ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,SQL051211105505020,SQL051211105504060,7 ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,SQL051211105504340,SQL051211105504060,7 ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,SQL051211105504700,SQL051211105504060,7 ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,SQL051211105505900,SQL051211105504060,7 ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,SQL051211105506530,SQL051211105504060,7 ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,SQL051211105506230,SQL051211105504060,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 END - PASS - phase CREATE db version 10.1 START - phase SOFT UPGRADE db version 10.1 jdbc url is jdbc:derby:updtest_10_1/su_10_1 Engine Apache Derby 10.2.0.0 alpha Pre-release Software - derby.database.allowPreReleaseUpgrade=true complete caseConnectionCheck - passed true complete caseInitialize - passed true complete caseProcedures - passed true Test metadata starting Column display size of the union result is: 13 dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL dec(10,2) -- precision: 10 scale: 2 display size: 13 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 type name: DOUBLE dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE result row: 11.10 11.10 14.4 -6.699999999999999 6.699999999999999 Column result scale after division is: 23 dc / 2 = 5.55000000000000000000000 dc / 2 = 5.55500000000000000000000 JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.2 (10.2.0.0 alpha) The URL is: jdbc:derby:updtest_10_1/su_10_1 allTablesAreSelectable(): true maxColumnNameLength(): 128 getSchemas(): TABLE_SCHEM[VARCHAR] APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT getCatalogs(): TABLE_CAT[CHAR] getSearchStringEscape(): getSQLKeywords(): ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATISTICS,TIMING,WAIT getDefaultTransactionIsolation(): 2 getProcedures(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],RESERVED1[INTEGER],RESERVED2[INTEGER],RESERVED3[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.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST3B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST4A,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4a,1 ,APP,GETPCTEST4B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 ,APP,GETPCTEST4BX,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 getUDTs() with user-named types null : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('DISTINCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT', 'STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] allProceduresAreCallable(): true getUserName(): APP isReadOnly(): false nullsAreSortedHigh(): true nullsAreSortedLow(): false nullsAreSortedAtStart(): false nullsAreSortedAtEnd(): false getDatabaseProductName(): Apache Derby getDatabaseProductVersion(): 10.2.0.0 alpha getDriverVersion(): 10.2.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,MOD,SQRT getStringFunctions(): CONCAT,LENGTH,LCASE,LOCATE,LTRIM,RTRIM,SUBSTRING,UCASE getSystemFunctions(): USER getTimeDateFunctions(): CURDATE,CURTIME,HOUR,MINUTE,MONTH,SECOND,TIMESTAMPADD,TIMESTAMPDIFF,YEAR getExtraNameCharacters(): 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(): false supportsANSI92IntermediateSQL(): false supportsANSI92FullSQL(): false supportsIntegrityEnhancementFacility(): false supportsOuterJoins(): true supportsFullOuterJoins(): false supportsLimitedOuterJoins(): true getSchemaTerm(): SCHEMA getProcedureTerm(): PROCEDURE getCatalogTerm(): CATALOG isCatalogAtStart(): false getCatalogSeparator(): 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(): 128 getMaxIndexLength(): 0 getMaxSchemaNameLength(): 128 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): true supportsDataDefinitionAndDataManipulationTransactions(): true supportsDataManipulationTransactionsOnly(): false dataDefinitionCausesTransactionCommit(): false dataDefinitionIgnoredInTransactions(): false Test the metadata calls related to visibility of changes made by others for different resultset types Since Derby materializes a forward only ResultSet incrementally, it is possible to see changes made by others and hence following 3 metadata calls will return true for forward only ResultSets. othersUpdatesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true Scroll insensitive ResultSet by their definition do not see changes made by others and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false Derby does not yet implement scroll sensitive resultsets and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false getConnection(): same connection getProcedureColumns(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],COLUMN_TYPE[SMALLINT],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],PRECISION[INTEGER],LENGTH[INTEGER],SCALE[SMALLINT],RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],METHOD_ID[SMALLINT],PARAMETER_ID[SMALLINT] null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,6,null,null,1,null,12,0 null,APP,GETPCTEST1,A,1,12,VARCHAR,3,6,null,null,1,null,12,1 null,APP,GETPCTEST1,B,1,2,NUMERIC,5,14,0,10,1,null,12,2 null,APP,GETPCTEST1,C,1,5,SMALLINT,5,2,0,10,1,null,12,3 null,APP,GETPCTEST1,E,1,5,SMALLINT,5,2,0,10,1,null,12,4 null,APP,GETPCTEST1,F,1,4,INTEGER,10,4,0,10,1,null,12,5 null,APP,GETPCTEST1,G,1,-5,BIGINT,19,40,0,10,1,null,12,6 null,APP,GETPCTEST1,H,1,8,DOUBLE,52,8,null,2,1,null,12,7 null,APP,GETPCTEST1,I,1,8,DOUBLE,52,8,null,2,1,null,12,8 null,APP,GETPCTEST1,K,1,91,DATE,10,6,0,10,1,null,12,9 null,APP,GETPCTEST1,L,1,92,TIME,8,6,0,10,1,null,12,10 null,APP,GETPCTEST1,T,1,93,TIMESTAMP,26,16,6,10,1,null,12,11 null,APP,GETPCTEST2,PA,1,4,INTEGER,10,4,0,10,1,null,2,0 null,APP,GETPCTEST2,PB,1,-5,BIGINT,19,40,0,10,1,null,2,1 null,APP,GETPCTEST3A,STRING1,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3A,STRING2,4,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,1,0 getTables() with TABLE_TYPE in ('SYSTEM TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],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[VARCHAR],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,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTables() with TABLE_TYPE in ('VIEW','TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR] ,APP,ALLTYPES,TABLE, ,APP,INFLIGHT,TABLE, ,APP,LOUIE,TABLE, ,APP,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTableTypes(): TABLE_TYPE[VARCHAR] SYSTEM TABLE TABLE VIEW getColumns(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO getColumns('ALLTYPES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,ALLTYPES,SMALLINTCOL,5,SMALLINT,5,null,0,10,1,,null,null,null,null,1,YES ,APP,ALLTYPES,INTCOL,4,INTEGER,10,null,0,10,1,,20,null,null,null,2,YES ,APP,ALLTYPES,BIGINTCOL,-5,BIGINT,19,null,0,10,1,,null,null,null,null,3,YES ,APP,ALLTYPES,REALCOL,7,REAL,23,null,null,2,1,,null,null,null,null,4,YES ,APP,ALLTYPES,DOUBLEPRECCOL,8,DOUBLE,52,null,null,2,1,,10,null,null,null,5,YES ,APP,ALLTYPES,FLOATCOL,8,DOUBLE,52,null,null,2,1,,8.8,null,null,null,6,YES ,APP,ALLTYPES,DECIMALCOL10P4S,3,DECIMAL,10,null,4,10,1,,null,null,null,null,7,YES ,APP,ALLTYPES,NUMERICCOL20P2S,2,NUMERIC,20,null,2,10,1,,null,null,null,null,8,YES ,APP,ALLTYPES,CHAR8COL___,1,CHAR,8,null,null,null,1,,null,null,null,16,9,YES ,APP,ALLTYPES,CHAR8FORBITCOL___,-2,CHAR () FOR BIT DATA,8,null,null,null,1,,null,null,null,null,10,YES ,APP,ALLTYPES,VARCHAR9COL,12,VARCHAR,9,null,null,null,1,,null,null,null,18,11,YES ,APP,ALLTYPES,VARCHAR9BITCOL,-3,VARCHAR () FOR BIT DATA,9,null,null,null,1,,null,null,null,null,12,YES ,APP,ALLTYPES,LONGVARCHARCOL,-1,LONG VARCHAR,32700,null,null,null,1,,null,null,null,null,13,YES ,APP,ALLTYPES,LONGVARBINARYCOL,-4,LONG VARCHAR FOR BIT DATA,32700,null,null,null,1,,null,null,null,null,14,YES ,APP,ALLTYPES,BLOBCOL,2004,BLOB,3072,null,null,null,1,,null,null,null,null,15,YES ,APP,ALLTYPES,CLOBCOL,2005,CLOB,3072,null,null,null,1,,null,null,null,null,16,YES ,APP,ALLTYPES,DATECOL,91,DATE,10,null,0,10,1,,null,null,null,null,17,YES ,APP,ALLTYPES,TIMECOL,92,TIME,8,null,0,10,1,,null,null,null,null,18,YES ,APP,ALLTYPES,TSCOL,93,TIMESTAMP,26,null,6,10,1,,null,null,null,null,19,YES getColumns('LOUIE'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,LOUIE,I,4,INTEGER,10,null,0,10,0,,10,null,null,null,1,NO ,APP,LOUIE,S,5,SMALLINT,5,null,0,10,0,,null,null,null,null,2,NO ,APP,LOUIE,C30,1,CHAR,30,null,null,null,0,,null,null,null,60,3,NO ,APP,LOUIE,VC10,12,VARCHAR,10,null,null,null,0,,'asdf',null,null,20,4,NO ,APP,LOUIE,AI,-5,BIGINT,19,null,0,10,0,,AUTOINCREMENT: start -10 increment 2001,null,null,null,5,NO getColumns('INFLIGHT'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,INFLIGHT,FLT_NUM,1,CHAR,20,null,null,null,0,,null,null,null,40,1,NO ,APP,INFLIGHT,FLT_ORIGIN,1,CHAR,6,null,null,null,1,,null,null,null,12,2,YES ,APP,INFLIGHT,FLT_DEST,1,CHAR,6,null,null,null,1,,null,null,null,12,3,YES ,APP,INFLIGHT,FLT_AIRCRAFT,1,CHAR,20,null,null,null,1,,null,null,null,40,4,YES ,APP,INFLIGHT,FLT_FLYING_TIME,12,VARCHAR,22,null,null,null,1,,null,null,null,44,5,YES ,APP,INFLIGHT,FLT_DEPT_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,6,YES ,APP,INFLIGHT,FLT_ARR_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,7,YES ,APP,INFLIGHT,FLT_NOTES,12,VARCHAR,510,null,null,null,1,,null,null,null,1020,8,YES ,APP,INFLIGHT,FLT_DAYS_OF_WK,1,CHAR,14,null,null,null,1,,null,null,null,28,9,YES ,APP,INFLIGHT,FLT_CRAFT_PIC,12,VARCHAR,32672,null,null,null,1,,null,null,null,65344,10,YES getColumnPrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],GRANTOR[VARCHAR],GRANTEE[VARCHAR],PRIVILEGE[VARCHAR],IS_GRANTABLE[VARCHAR] getTablePrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],GRANTOR[VARCHAR],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],PSEUDO_COLUMN[SMALLINT] 2,I,4,INTEGER,4,null,10,1 2,VC10,12,VARCHAR,10,null,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],PSEUDO_COLUMN[SMALLINT] 2,TABLEID,1,CHAR,36,null,null,1 getVersionColumns(): SCOPE[INTEGER],COLUMN_NAME[VARCHAR],DATA_TYPE[INTEGER],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],PSEUDO_COLUMN[INTEGER] getPrimaryKeys(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[INTEGER],CASE_SENSITIVE[BOOLEAN],SEARCHABLE[INTEGER],UNSIGNED_ATTRIBUTE[BOOLEAN],FIXED_PREC_SCALE[BOOLEAN],AUTO_INCREMENT[BOOLEAN],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[INTEGER],MAXIMUM_SCALE[INTEGER],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],NUM_PREC_RADIX[INTEGER] BIGINT,-5,19,null,null,null,1,false,2,false,false,true,BIGINT,0,0,null,null,10 LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,false,2,true,false,false,LONG VARCHAR FOR BIT DATA,null,null,null,null,null VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,false,2,true,false,false,VARCHAR () FOR BIT DATA,null,null,null,null,null CHAR () FOR BIT DATA,-2,254,X',',length,1,false,2,true,false,false,CHAR () FOR BIT DATA,null,null,null,null,null LONG VARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG VARCHAR,null,null,null,null,null LONG NVARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG NVARCHAR,null,null,null,null,null CHAR,1,254,',',length,1,true,3,true,false,false,CHAR,null,null,null,null,null NATIONAL CHAR,1,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR,null,null,null,null,null NUMERIC,2,31,null,null,precision,scale,1,false,2,false,true,false,NUMERIC,0,32767,null,null,10 DECIMAL,3,31,null,null,precision,scale,1,false,2,false,true,false,DECIMAL,0,32767,null,null,10 INTEGER,4,10,null,null,null,1,false,2,false,false,true,INTEGER,0,0,null,null,10 SMALLINT,5,5,null,null,null,1,false,2,false,false,true,SMALLINT,0,0,null,null,10 FLOAT,6,52,null,null,precision,1,false,2,false,false,false,FLOAT,null,null,null,null,2 REAL,7,23,null,null,null,1,false,2,false,false,false,REAL,null,null,null,null,2 DOUBLE,8,52,null,null,null,1,false,2,false,false,false,DOUBLE,null,null,null,null,2 VARCHAR,12,32672,',',length,1,true,3,true,false,false,VARCHAR,null,null,null,null,null NATIONAL CHAR VARYING,12,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR VARYING,null,null,null,null,null DATE,91,10,DATE',',null,1,false,2,true,false,false,DATE,0,0,null,null,10 TIME,92,8,TIME',',null,1,false,2,true,false,false,TIME,0,0,null,null,10 TIMESTAMP,93,26,TIMESTAMP',',null,1,false,2,true,false,false,TIMESTAMP,0,6,null,null,10 BLOB,2004,2147483647,null,null,length,1,false,1,null,false,null,BLOB,null,null,null,null,null CLOB,2005,2147483647,',',length,1,true,1,null,false,null,CLOB,null,null,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null ,SYS,SYSCOLUMNS,true,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO Test escaped numeric functions - JDBC 3.0 C.1 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ABS(-25.67) } -- = >25.67< << Executing VALUES { fn MOD(124, 7) } -- = >5< << Executing VALUES { fn SQRT(6.22) } -- = >2.49< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ACOS(1.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13. Executing VALUES { fn ASIN(1.21) } -- SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13. Executing VALUES { fn ATAN(0.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN" at line 1, column 13. Executing VALUES { fn ATAN2(0.56, 1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN2" at line 1, column 13. Executing VALUES { fn CEILING(3.45) } -- SQLSTATE(42X01): Syntax error: Encountered "CEILING" at line 1, column 13. Executing VALUES { fn COS(1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "COS" at line 1, column 13. Executing VALUES { fn COT(3.4) } -- SQLSTATE(42X01): Syntax error: Encountered "COT" at line 1, column 13. Executing VALUES { fn DEGREES(2.1) } -- SQLSTATE(42X01): Syntax error: Encountered "DEGREES" at line 1, column 13. Executing VALUES { fn EXP(2.3) } -- SQLSTATE(42X01): Syntax error: Encountered "EXP" at line 1, column 13. Executing VALUES { fn FLOOR(3.22) } -- SQLSTATE(42X01): Syntax error: Encountered "FLOOR" at line 1, column 13. Executing VALUES { fn LOG(34.1) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG" at line 1, column 13. Executing VALUES { fn LOG10(18.7) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG10" at line 1, column 13. Executing VALUES { fn PI() } -- SQLSTATE(42X01): Syntax error: Encountered "PI" at line 1, column 13. Executing VALUES { fn POWER(2, 3) } -- SQLSTATE(42X01): Syntax error: Encountered "POWER" at line 1, column 13. Executing VALUES { fn RADIANS(54) } -- SQLSTATE(42X01): Syntax error: Encountered "RADIANS" at line 1, column 13. Executing VALUES { fn RAND(17) } -- SQLSTATE(42X01): Syntax error: Encountered "RAND" at line 1, column 13. Executing VALUES { fn ROUND(345.345, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "ROUND" at line 1, column 13. Executing VALUES { fn SIGN(-34) } -- SQLSTATE(42X01): Syntax error: Encountered "SIGN" at line 1, column 13. Executing VALUES { fn SIN(0.32) } -- SQLSTATE(42X01): Syntax error: Encountered "SIN" at line 1, column 13. Executing VALUES { fn TAN(0.57) } -- SQLSTATE(42X01): Syntax error: Encountered "TAN" at line 1, column 13. Executing VALUES { fn TRUNCATE(345.395, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "TRUNCATE" at line 1, column 13. Test escaped string functions - JDBC 3.0 C.2 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn CONCAT('hello', 'there') } -- = >hellothere< << Executing VALUES { fn LENGTH('four ') } -- = >4< << Executing VALUES { fn LCASE('Fernando Alonso') } -- = >fernando alonso< << Executing VALUES { fn LOCATE('jour', 'Bonjour') } -- = >4< << Executing VALUES { fn LTRIM(' left trim ') } -- = >left trim < << Executing VALUES { fn RTRIM(' right trim ') } -- = > right trim< << Executing VALUES { fn SUBSTRING('Ruby the Rubicon Jeep', 10, 7) } -- = >Rubicon< << Executing VALUES { fn UCASE('Fernando Alonso') } -- = >FERNANDO ALONSO< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ASCII('Yellow') } -- SQLSTATE(42X01): Syntax error: Encountered "ASCII" at line 1, column 13. Executing VALUES { fn CHAR(65) } -- = >65 < << FAIL function works but not declared in list: CHAR Executing VALUES { fn DIFFERENCE('Pires', 'Piers') } -- SQLSTATE(42X01): Syntax error: Encountered "DIFFERENCE" at line 1, column 13. Executing VALUES { fn INSERT('Bill Clinton', 4, 'William') } -- SQLSTATE(42X01): Syntax error: Encountered "INSERT" at line 1, column 13. Executing VALUES { fn LEFT('Bonjour', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "LEFT" at line 1, column 13. Executing VALUES { fn REPEAT('echo', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "REPEAT" at line 1, column 13. Executing VALUES { fn REPLACE('to be or not to be', 'be', 'England') } -- SQLSTATE(42X01): Syntax error: Encountered "REPLACE" at line 1, column 13. Executing VALUES { fn SOUNDEX('Derby') } -- SQLSTATE(42X01): Syntax error: Encountered "SOUNDEX" at line 1, column 13. Executing VALUES { fn SPACE(12) } -- SQLSTATE(42X01): Syntax error: Encountered "SPACE" at line 1, column 13. Test escaped date time functions - JDBC 3.0 C.3 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END -- = >OK< << Executing VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END -- = >OK< << Executing VALUES { fn HOUR({t '16:13:03'}) } -- = >16< << Executing VALUES { fn MINUTE({t '16:13:03'}) } -- = >13< << Executing VALUES { fn MONTH({d '1995-12-19'}) } -- = >12< << Executing VALUES { fn SECOND({t '16:13:03'}) } -- = >3< << Executing VALUES { fn TIMESTAMPADD(SQL_TSI_DAY, 7, {ts '1995-12-19 12:15:54'}) } -- = >1995-12-26 12:15:54.0< << Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts '1995-12-19 12:15:54'}, {ts '1997-11-02 00:15:23'}) } -- = >683< << Executing VALUES { fn YEAR({d '1995-12-19'}) } -- = >1995< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DAYNAME({d '1995-12-19'h}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYNAME" at line 1, column 13. Executing VALUES { fn DAYOFMONTH({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFMONTH" at line 1, column 13. Executing VALUES { fn DAYOFWEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFWEEK" at line 1, column 13. Executing VALUES { fn DAYOFYEAR({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFYEAR" at line 1, column 13. Executing VALUES { fn MONTHNAME({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "MONTHNAME" at line 1, column 13. Executing VALUES CASE WHEN { fn NOW()} = CURRENT_TIMESTAMP THEN 'OK' ELSE 'wrong' END -- SQLSTATE(42X01): Syntax error: Encountered "NOW" at line 1, column 23. Executing VALUES { fn QUARTER({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "QUARTER" at line 1, column 13. Executing VALUES { fn WEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "WEEK" at line 1, column 13. Test escaped system functions - JDBC 3.0 C.4 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn USER() } -- = >APP< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DATABASE() } -- SQLSTATE(42X01): Syntax error: Encountered "DATABASE" at line 1, column 13. Executing VALUES { fn IFNULL('this', 'that') } -- SQLSTATE(42X01): Syntax error: Encountered "IFNULL" at line 1, column 13. --------------------------------------- Referential action values RESTRICT = 1 NO ACTION = 3 CASCADE = 0 SETNULL = 2 SETDEFAULT = 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[VARCHAR],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,SQL051211105524870,SQL051211105524470,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[VARCHAR],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,SQL051211105525210,SQL051211105524470,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[VARCHAR],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,SQL051211105525510,SQL051211105524470,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[VARCHAR],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,SQL051211105526030,SQL051211105524470,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[VARCHAR],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,SQL051211105526400,SQL051211105524470,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[VARCHAR],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,SQL051211105526890,SQL051211105524470,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[VARCHAR],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,SQL051211105527230,SQL051211105524470,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[VARCHAR],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,SQL051211105526030,SQL051211105524470,7 ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,SQL051211105525510,SQL051211105524470,7 ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,SQL051211105524870,SQL051211105524470,7 ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,SQL051211105525210,SQL051211105524470,7 ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,SQL051211105526400,SQL051211105524470,7 ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,SQL051211105527230,SQL051211105524470,7 ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,SQL051211105526890,SQL051211105524470,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 END - PASS - phase SOFT UPGRADE db version 10.1 START - phase POST SOFT UPGRADE db version 10.1 jdbc url is jdbc:derby:updtest_10_1/su_10_1 Engine Apache Derby 10.1.2.2 complete caseConnectionCheck - passed true complete caseInitialize - passed true complete caseProcedures - passed true Test metadata starting Column display size of the union result is: 13 dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL dec(10,2) -- precision: 10 scale: 2 display size: 13 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 type name: DOUBLE dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE result row: 11.10 11.10 14.4 -6.699999999999999 6.699999999999999 Column result scale after division is: 23 dc / 2 = 5.55000000000000000000000 dc / 2 = 5.55500000000000000000000 JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.1 (10.1.2.2) The URL is: jdbc:derby:updtest_10_1/su_10_1 allTablesAreSelectable(): true maxColumnNameLength(): 128 getSchemas(): TABLE_SCHEM[VARCHAR] APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT getCatalogs(): TABLE_CAT[CHAR] getSearchStringEscape(): getSQLKeywords(): ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATISTICS,TIMING,WAIT getDefaultTransactionIsolation(): 2 getProcedures(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],RESERVED1[INTEGER],RESERVED2[INTEGER],RESERVED3[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.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST3B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST4A,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4a,1 ,APP,GETPCTEST4B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 ,APP,GETPCTEST4BX,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 getUDTs() with user-named types null : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('DISTINCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT', 'STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] allProceduresAreCallable(): true getUserName(): APP isReadOnly(): false nullsAreSortedHigh(): true nullsAreSortedLow(): false nullsAreSortedAtStart(): false nullsAreSortedAtEnd(): false getDatabaseProductName(): Apache Derby getDatabaseProductVersion(): 10.1.2.2 getDriverVersion(): 10.1.2.2 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(): 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(): false supportsANSI92IntermediateSQL(): false supportsANSI92FullSQL(): false supportsIntegrityEnhancementFacility(): false supportsOuterJoins(): true supportsFullOuterJoins(): false supportsLimitedOuterJoins(): true getSchemaTerm(): SCHEMA getProcedureTerm(): PROCEDURE getCatalogTerm(): CATALOG isCatalogAtStart(): false getCatalogSeparator(): 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(): 128 getMaxIndexLength(): 0 getMaxSchemaNameLength(): 128 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): true supportsDataDefinitionAndDataManipulationTransactions(): true supportsDataManipulationTransactionsOnly(): false dataDefinitionCausesTransactionCommit(): false dataDefinitionIgnoredInTransactions(): false Test the metadata calls related to visibility of changes made by others for different resultset types Since Derby materializes a forward only ResultSet incrementally, it is possible to see changes made by others and hence following 3 metadata calls will return true for forward only ResultSets. othersUpdatesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true Scroll insensitive ResultSet by their definition do not see changes made by others and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false Derby does not yet implement scroll sensitive resultsets and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false getConnection(): same connection getProcedureColumns(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],COLUMN_TYPE[SMALLINT],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],PRECISION[INTEGER],LENGTH[INTEGER],SCALE[SMALLINT],RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],METHOD_ID[SMALLINT],PARAMETER_ID[SMALLINT] null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,6,null,null,1,null,12,0 null,APP,GETPCTEST1,A,1,12,VARCHAR,3,6,null,null,1,null,12,1 null,APP,GETPCTEST1,B,1,2,NUMERIC,5,14,0,10,1,null,12,2 null,APP,GETPCTEST1,C,1,5,SMALLINT,5,2,0,10,1,null,12,3 null,APP,GETPCTEST1,E,1,5,SMALLINT,5,2,0,10,1,null,12,4 null,APP,GETPCTEST1,F,1,4,INTEGER,10,4,0,10,1,null,12,5 null,APP,GETPCTEST1,G,1,-5,BIGINT,19,40,0,10,1,null,12,6 null,APP,GETPCTEST1,H,1,8,DOUBLE,52,8,null,2,1,null,12,7 null,APP,GETPCTEST1,I,1,8,DOUBLE,52,8,null,2,1,null,12,8 null,APP,GETPCTEST1,K,1,91,DATE,10,6,0,10,1,null,12,9 null,APP,GETPCTEST1,L,1,92,TIME,8,6,0,10,1,null,12,10 null,APP,GETPCTEST1,T,1,93,TIMESTAMP,26,16,6,10,1,null,12,11 null,APP,GETPCTEST2,PA,1,4,INTEGER,10,4,0,10,1,null,2,0 null,APP,GETPCTEST2,PB,1,-5,BIGINT,19,40,0,10,1,null,2,1 null,APP,GETPCTEST3A,STRING1,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3A,STRING2,4,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,1,0 getTables() with TABLE_TYPE in ('SYSTEM TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],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[VARCHAR],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,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTables() with TABLE_TYPE in ('VIEW','TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR] ,APP,ALLTYPES,TABLE, ,APP,INFLIGHT,TABLE, ,APP,LOUIE,TABLE, ,APP,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTableTypes(): TABLE_TYPE[VARCHAR] SYSTEM TABLE TABLE VIEW getColumns(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO getColumns('ALLTYPES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,ALLTYPES,SMALLINTCOL,5,SMALLINT,5,null,0,10,1,,null,null,null,null,1,YES ,APP,ALLTYPES,INTCOL,4,INTEGER,10,null,0,10,1,,20,null,null,null,2,YES ,APP,ALLTYPES,BIGINTCOL,-5,BIGINT,19,null,0,10,1,,null,null,null,null,3,YES ,APP,ALLTYPES,REALCOL,7,REAL,23,null,null,2,1,,null,null,null,null,4,YES ,APP,ALLTYPES,DOUBLEPRECCOL,8,DOUBLE,52,null,null,2,1,,10,null,null,null,5,YES ,APP,ALLTYPES,FLOATCOL,8,DOUBLE,52,null,null,2,1,,8.8,null,null,null,6,YES ,APP,ALLTYPES,DECIMALCOL10P4S,3,DECIMAL,10,null,4,10,1,,null,null,null,null,7,YES ,APP,ALLTYPES,NUMERICCOL20P2S,2,NUMERIC,20,null,2,10,1,,null,null,null,null,8,YES ,APP,ALLTYPES,CHAR8COL___,1,CHAR,8,null,null,null,1,,null,null,null,16,9,YES ,APP,ALLTYPES,CHAR8FORBITCOL___,-2,CHAR () FOR BIT DATA,8,null,null,null,1,,null,null,null,null,10,YES ,APP,ALLTYPES,VARCHAR9COL,12,VARCHAR,9,null,null,null,1,,null,null,null,18,11,YES ,APP,ALLTYPES,VARCHAR9BITCOL,-3,VARCHAR () FOR BIT DATA,9,null,null,null,1,,null,null,null,null,12,YES ,APP,ALLTYPES,LONGVARCHARCOL,-1,LONG VARCHAR,32700,null,null,null,1,,null,null,null,null,13,YES ,APP,ALLTYPES,LONGVARBINARYCOL,-4,LONG VARCHAR FOR BIT DATA,32700,null,null,null,1,,null,null,null,null,14,YES ,APP,ALLTYPES,BLOBCOL,2004,BLOB,3072,null,null,null,1,,null,null,null,null,15,YES ,APP,ALLTYPES,CLOBCOL,2005,CLOB,3072,null,null,null,1,,null,null,null,null,16,YES ,APP,ALLTYPES,DATECOL,91,DATE,10,null,0,10,1,,null,null,null,null,17,YES ,APP,ALLTYPES,TIMECOL,92,TIME,8,null,0,10,1,,null,null,null,null,18,YES ,APP,ALLTYPES,TSCOL,93,TIMESTAMP,26,null,6,10,1,,null,null,null,null,19,YES getColumns('LOUIE'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,LOUIE,I,4,INTEGER,10,null,0,10,0,,10,null,null,null,1,NO ,APP,LOUIE,S,5,SMALLINT,5,null,0,10,0,,null,null,null,null,2,NO ,APP,LOUIE,C30,1,CHAR,30,null,null,null,0,,null,null,null,60,3,NO ,APP,LOUIE,VC10,12,VARCHAR,10,null,null,null,0,,'asdf',null,null,20,4,NO ,APP,LOUIE,AI,-5,BIGINT,19,null,0,10,0,,AUTOINCREMENT: start -10 increment 2001,null,null,null,5,NO getColumns('INFLIGHT'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,INFLIGHT,FLT_NUM,1,CHAR,20,null,null,null,0,,null,null,null,40,1,NO ,APP,INFLIGHT,FLT_ORIGIN,1,CHAR,6,null,null,null,1,,null,null,null,12,2,YES ,APP,INFLIGHT,FLT_DEST,1,CHAR,6,null,null,null,1,,null,null,null,12,3,YES ,APP,INFLIGHT,FLT_AIRCRAFT,1,CHAR,20,null,null,null,1,,null,null,null,40,4,YES ,APP,INFLIGHT,FLT_FLYING_TIME,12,VARCHAR,22,null,null,null,1,,null,null,null,44,5,YES ,APP,INFLIGHT,FLT_DEPT_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,6,YES ,APP,INFLIGHT,FLT_ARR_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,7,YES ,APP,INFLIGHT,FLT_NOTES,12,VARCHAR,510,null,null,null,1,,null,null,null,1020,8,YES ,APP,INFLIGHT,FLT_DAYS_OF_WK,1,CHAR,14,null,null,null,1,,null,null,null,28,9,YES ,APP,INFLIGHT,FLT_CRAFT_PIC,12,VARCHAR,32672,null,null,null,1,,null,null,null,65344,10,YES getColumnPrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],GRANTOR[VARCHAR],GRANTEE[VARCHAR],PRIVILEGE[VARCHAR],IS_GRANTABLE[VARCHAR] getTablePrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],GRANTOR[VARCHAR],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],PSEUDO_COLUMN[SMALLINT] 2,I,4,INTEGER,4,null,10,1 2,VC10,12,VARCHAR,10,null,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],PSEUDO_COLUMN[SMALLINT] 2,TABLEID,1,CHAR,36,null,null,1 getVersionColumns(): SCOPE[INTEGER],COLUMN_NAME[VARCHAR],DATA_TYPE[INTEGER],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],PSEUDO_COLUMN[INTEGER] getPrimaryKeys(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[INTEGER],CASE_SENSITIVE[BOOLEAN],SEARCHABLE[INTEGER],UNSIGNED_ATTRIBUTE[BOOLEAN],FIXED_PREC_SCALE[BOOLEAN],AUTO_INCREMENT[BOOLEAN],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[INTEGER],MAXIMUM_SCALE[INTEGER],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],NUM_PREC_RADIX[INTEGER] BIGINT,-5,19,null,null,null,1,false,2,false,false,true,BIGINT,0,0,null,null,10 LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,false,2,true,false,false,LONG VARCHAR FOR BIT DATA,null,null,null,null,null VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,false,2,true,false,false,VARCHAR () FOR BIT DATA,null,null,null,null,null CHAR () FOR BIT DATA,-2,254,X',',length,1,false,2,true,false,false,CHAR () FOR BIT DATA,null,null,null,null,null LONG VARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG VARCHAR,null,null,null,null,null LONG NVARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG NVARCHAR,null,null,null,null,null CHAR,1,254,',',length,1,true,3,true,false,false,CHAR,null,null,null,null,null NATIONAL CHAR,1,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR,null,null,null,null,null NUMERIC,2,31,null,null,precision,scale,1,false,2,false,true,false,NUMERIC,0,32767,null,null,10 DECIMAL,3,31,null,null,precision,scale,1,false,2,false,true,false,DECIMAL,0,32767,null,null,10 INTEGER,4,10,null,null,null,1,false,2,false,false,true,INTEGER,0,0,null,null,10 SMALLINT,5,5,null,null,null,1,false,2,false,false,true,SMALLINT,0,0,null,null,10 FLOAT,6,52,null,null,precision,1,false,2,false,false,false,FLOAT,null,null,null,null,2 REAL,7,23,null,null,null,1,false,2,false,false,false,REAL,null,null,null,null,2 DOUBLE,8,52,null,null,null,1,false,2,false,false,false,DOUBLE,null,null,null,null,2 VARCHAR,12,32672,',',length,1,true,3,true,false,false,VARCHAR,null,null,null,null,null NATIONAL CHAR VARYING,12,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR VARYING,null,null,null,null,null DATE,91,10,DATE',',null,1,false,2,true,false,false,DATE,0,0,null,null,10 TIME,92,8,TIME',',null,1,false,2,true,false,false,TIME,0,0,null,null,10 TIMESTAMP,93,26,TIMESTAMP',',null,1,false,2,true,false,false,TIMESTAMP,0,6,null,null,10 BLOB,2004,2147483647,null,null,length,1,false,1,null,false,null,BLOB,null,null,null,null,null CLOB,2005,2147483647,',',length,1,true,1,null,false,null,CLOB,null,null,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null ,SYS,SYSCOLUMNS,true,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO Test escaped numeric functions - JDBC 3.0 C.1 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ABS(-25.67) } -- = >25.67< << Executing VALUES { fn SQRT(6.22) } -- = >2.49< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ACOS(1.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13. Executing VALUES { fn ASIN(1.21) } -- SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13. Executing VALUES { fn ATAN(0.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN" at line 1, column 13. Executing VALUES { fn ATAN2(0.56, 1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN2" at line 1, column 13. Executing VALUES { fn CEILING(3.45) } -- SQLSTATE(42X01): Syntax error: Encountered "CEILING" at line 1, column 13. Executing VALUES { fn COS(1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "COS" at line 1, column 13. Executing VALUES { fn COT(3.4) } -- SQLSTATE(42X01): Syntax error: Encountered "COT" at line 1, column 13. Executing VALUES { fn DEGREES(2.1) } -- SQLSTATE(42X01): Syntax error: Encountered "DEGREES" at line 1, column 13. Executing VALUES { fn EXP(2.3) } -- SQLSTATE(42X01): Syntax error: Encountered "EXP" at line 1, column 13. Executing VALUES { fn FLOOR(3.22) } -- SQLSTATE(42X01): Syntax error: Encountered "FLOOR" at line 1, column 13. Executing VALUES { fn LOG(34.1) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG" at line 1, column 13. Executing VALUES { fn LOG10(18.7) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG10" at line 1, column 13. Executing VALUES { fn MOD(124, 7) } -- = >5< << FAIL function works but not declared in list: MOD Executing VALUES { fn PI() } -- SQLSTATE(42X01): Syntax error: Encountered "PI" at line 1, column 13. Executing VALUES { fn POWER(2, 3) } -- SQLSTATE(42X01): Syntax error: Encountered "POWER" at line 1, column 13. Executing VALUES { fn RADIANS(54) } -- SQLSTATE(42X01): Syntax error: Encountered "RADIANS" at line 1, column 13. Executing VALUES { fn RAND(17) } -- SQLSTATE(42X01): Syntax error: Encountered "RAND" at line 1, column 13. Executing VALUES { fn ROUND(345.345, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "ROUND" at line 1, column 13. Executing VALUES { fn SIGN(-34) } -- SQLSTATE(42X01): Syntax error: Encountered "SIGN" at line 1, column 13. Executing VALUES { fn SIN(0.32) } -- SQLSTATE(42X01): Syntax error: Encountered "SIN" at line 1, column 13. Executing VALUES { fn TAN(0.57) } -- SQLSTATE(42X01): Syntax error: Encountered "TAN" at line 1, column 13. Executing VALUES { fn TRUNCATE(345.395, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "TRUNCATE" at line 1, column 13. Test escaped string functions - JDBC 3.0 C.2 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn LENGTH('four ') } -- = >4< << FAIL Non-JDBC spec function in list: LOWER Executing VALUES { fn LTRIM(' left trim ') } -- = >left trim < << Executing VALUES { fn RTRIM(' right trim ') } -- = > right trim< << FAIL Non-JDBC spec function in list: SUBSTR Executing VALUES { fn SUBSTRING('Ruby the Rubicon Jeep', 10, 7) } -- = >Rubicon< << FAIL Non-JDBC spec function in list: UPPER TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ASCII('Yellow') } -- SQLSTATE(42X01): Syntax error: Encountered "ASCII" at line 1, column 13. Executing VALUES { fn CHAR(65) } -- = >65 < << FAIL function works but not declared in list: CHAR Executing VALUES { fn CONCAT('hello', 'there') } -- = >hellothere< << FAIL function works but not declared in list: CONCAT Executing VALUES { fn DIFFERENCE('Pires', 'Piers') } -- SQLSTATE(42X01): Syntax error: Encountered "DIFFERENCE" at line 1, column 13. Executing VALUES { fn INSERT('Bill Clinton', 4, 'William') } -- SQLSTATE(42X01): Syntax error: Encountered "INSERT" at line 1, column 13. Executing VALUES { fn LCASE('Fernando Alonso') } -- = >fernando alonso< << FAIL function works but not declared in list: LCASE Executing VALUES { fn LEFT('Bonjour', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "LEFT" at line 1, column 13. Executing VALUES { fn LOCATE('jour', 'Bonjour') } -- = >4< << FAIL function works but not declared in list: LOCATE Executing VALUES { fn REPEAT('echo', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "REPEAT" at line 1, column 13. Executing VALUES { fn REPLACE('to be or not to be', 'be', 'England') } -- SQLSTATE(42X01): Syntax error: Encountered "REPLACE" at line 1, column 13. Executing VALUES { fn SOUNDEX('Derby') } -- SQLSTATE(42X01): Syntax error: Encountered "SOUNDEX" at line 1, column 13. Executing VALUES { fn SPACE(12) } -- SQLSTATE(42X01): Syntax error: Encountered "SPACE" at line 1, column 13. Executing VALUES { fn UCASE('Fernando Alonso') } -- = >FERNANDO ALONSO< << FAIL function works but not declared in list: UCASE Test escaped date time functions - JDBC 3.0 C.3 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END -- = >OK< << Executing VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END -- = >OK< << FAIL Non-JDBC spec function in list: CURRENT_DATE FAIL Non-JDBC spec function in list: CURRENT_TIME FAIL Non-JDBC spec function in list: CURRENT_TIMESTAMP FAIL Non-JDBC spec function in list: EXTRACT TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DAYNAME({d '1995-12-19'h}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYNAME" at line 1, column 13. Executing VALUES { fn DAYOFMONTH({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFMONTH" at line 1, column 13. Executing VALUES { fn DAYOFWEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFWEEK" at line 1, column 13. Executing VALUES { fn DAYOFYEAR({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFYEAR" at line 1, column 13. Executing VALUES { fn HOUR({t '16:13:03'}) } -- = >16< << FAIL function works but not declared in list: HOUR Executing VALUES { fn MINUTE({t '16:13:03'}) } -- = >13< << FAIL function works but not declared in list: MINUTE Executing VALUES { fn MONTH({d '1995-12-19'}) } -- = >12< << FAIL function works but not declared in list: MONTH Executing VALUES { fn MONTHNAME({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "MONTHNAME" at line 1, column 13. Executing VALUES CASE WHEN { fn NOW()} = CURRENT_TIMESTAMP THEN 'OK' ELSE 'wrong' END -- SQLSTATE(42X01): Syntax error: Encountered "NOW" at line 1, column 23. Executing VALUES { fn QUARTER({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "QUARTER" at line 1, column 13. Executing VALUES { fn SECOND({t '16:13:03'}) } -- = >3< << FAIL function works but not declared in list: SECOND Executing VALUES { fn TIMESTAMPADD(SQL_TSI_DAY, 7, {ts '1995-12-19 12:15:54'}) } -- = >1995-12-26 12:15:54.0< << FAIL function works but not declared in list: TIMESTAMPADD Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts '1995-12-19 12:15:54'}, {ts '1997-11-02 00:15:23'}) } -- = >683< << FAIL function works but not declared in list: TIMESTAMPDIFF Executing VALUES { fn WEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "WEEK" at line 1, column 13. Executing VALUES { fn YEAR({d '1995-12-19'}) } -- = >1995< << FAIL function works but not declared in list: YEAR Test escaped system functions - JDBC 3.0 C.4 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST FAIL Non-JDBC spec function in list: CURRENT_USER FAIL Non-JDBC spec function in list: getCurrentConnection FAIL Non-JDBC spec function in list: runTimeStatistics FAIL Non-JDBC spec function in list: SESSION_USER Executing VALUES { fn USER() } -- = >APP< << FAIL Non-JDBC spec function in list: CURRENT SCHEMA TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DATABASE() } -- SQLSTATE(42X01): Syntax error: Encountered "DATABASE" at line 1, column 13. Executing VALUES { fn IFNULL('this', 'that') } -- SQLSTATE(42X01): Syntax error: Encountered "IFNULL" at line 1, column 13. --------------------------------------- Referential action values RESTRICT = 1 NO ACTION = 3 CASCADE = 0 SETNULL = 2 SETDEFAULT = 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[VARCHAR],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,SQL051211105550630,SQL051211105550280,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[VARCHAR],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,SQL051211105551130,SQL051211105550280,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[VARCHAR],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,SQL051211105551570,SQL051211105550280,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[VARCHAR],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,SQL051211105551960,SQL051211105550280,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[VARCHAR],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,SQL051211105552390,SQL051211105550280,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[VARCHAR],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,SQL051211105553350,SQL051211105550280,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[VARCHAR],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,SQL051211105554360,SQL051211105550280,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[VARCHAR],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,SQL051211105551960,SQL051211105550280,7 ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,SQL051211105551570,SQL051211105550280,7 ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,SQL051211105550630,SQL051211105550280,7 ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,SQL051211105551130,SQL051211105550280,7 ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,SQL051211105552390,SQL051211105550280,7 ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,SQL051211105554360,SQL051211105550280,7 ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,SQL051211105553350,SQL051211105550280,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 END - PASS - phase POST SOFT UPGRADE db version 10.1 START - phase UPGRADE db version 10.1 jdbc url is jdbc:derby:updtest_10_1/su_10_1;upgrade=true Engine Apache Derby 10.2.0.0 alpha Pre-release Software - derby.database.allowPreReleaseUpgrade=true complete caseConnectionCheck - passed true complete caseInitialize - passed true complete caseProcedures - passed true Test metadata starting Column display size of the union result is: 13 dec(10,2) -- precision: 10 scale: 2 display size: 13 type name: DECIMAL dec(10,2) -- precision: 10 scale: 2 display size: 13 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 type name: DOUBLE dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE result row: 11.10 11.10 14.4 -6.699999999999999 6.699999999999999 Column result scale after division is: 23 dc / 2 = 5.55000000000000000000000 dc / 2 = 5.55500000000000000000000 JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.2 (10.2.0.0 alpha) The URL is: jdbc:derby:updtest_10_1/su_10_1 allTablesAreSelectable(): true maxColumnNameLength(): 128 getSchemas(): TABLE_SCHEM[VARCHAR] APP NULLID SQLJ SYS SYSCAT SYSCS_DIAG SYSCS_UTIL SYSFUN SYSIBM SYSPROC SYSSTAT getCatalogs(): TABLE_CAT[CHAR] getSearchStringEscape(): getSQLKeywords(): ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATISTICS,TIMING,WAIT getDefaultTransactionIsolation(): 2 getProcedures(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],RESERVED1[INTEGER],RESERVED2[INTEGER],RESERVED3[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.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST3B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1 ,APP,GETPCTEST4A,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4a,1 ,APP,GETPCTEST4B,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 ,APP,GETPCTEST4BX,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc4b,1 getUDTs() with user-named types null : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('DISTINCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] getUDTs() with user-named types in ('JAVA_OBJECT', 'STRUCT') : TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR] allProceduresAreCallable(): true getUserName(): APP isReadOnly(): false nullsAreSortedHigh(): true nullsAreSortedLow(): false nullsAreSortedAtStart(): false nullsAreSortedAtEnd(): false getDatabaseProductName(): Apache Derby getDatabaseProductVersion(): 10.2.0.0 alpha getDriverVersion(): 10.2.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,MOD,SQRT getStringFunctions(): CONCAT,LENGTH,LCASE,LOCATE,LTRIM,RTRIM,SUBSTRING,UCASE getSystemFunctions(): USER getTimeDateFunctions(): CURDATE,CURTIME,HOUR,MINUTE,MONTH,SECOND,TIMESTAMPADD,TIMESTAMPDIFF,YEAR getExtraNameCharacters(): 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(): false supportsANSI92IntermediateSQL(): false supportsANSI92FullSQL(): false supportsIntegrityEnhancementFacility(): false supportsOuterJoins(): true supportsFullOuterJoins(): false supportsLimitedOuterJoins(): true getSchemaTerm(): SCHEMA getProcedureTerm(): PROCEDURE getCatalogTerm(): CATALOG isCatalogAtStart(): false getCatalogSeparator(): 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(): 128 getMaxIndexLength(): 0 getMaxSchemaNameLength(): 128 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): true supportsDataDefinitionAndDataManipulationTransactions(): true supportsDataManipulationTransactionsOnly(): false dataDefinitionCausesTransactionCommit(): false dataDefinitionIgnoredInTransactions(): false Test the metadata calls related to visibility of changes made by others for different resultset types Since Derby materializes a forward only ResultSet incrementally, it is possible to see changes made by others and hence following 3 metadata calls will return true for forward only ResultSets. othersUpdatesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersDeletesAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true othersInsertsAreVisible(ResultSet.TYPE_FORWARD_ONLY)? true Scroll insensitive ResultSet by their definition do not see changes made by others and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_INSENSITIVE)? false Derby does not yet implement scroll sensitive resultsets and hence following metadata calls return false othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersDeletesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false othersInsertsAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE)? false getConnection(): same connection getProcedureColumns(): PROCEDURE_CAT[VARCHAR],PROCEDURE_SCHEM[VARCHAR],PROCEDURE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],COLUMN_TYPE[SMALLINT],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],PRECISION[INTEGER],LENGTH[INTEGER],SCALE[SMALLINT],RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],METHOD_ID[SMALLINT],PARAMETER_ID[SMALLINT] null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,6,null,null,1,null,12,0 null,APP,GETPCTEST1,A,1,12,VARCHAR,3,6,null,null,1,null,12,1 null,APP,GETPCTEST1,B,1,2,NUMERIC,5,14,0,10,1,null,12,2 null,APP,GETPCTEST1,C,1,5,SMALLINT,5,2,0,10,1,null,12,3 null,APP,GETPCTEST1,E,1,5,SMALLINT,5,2,0,10,1,null,12,4 null,APP,GETPCTEST1,F,1,4,INTEGER,10,4,0,10,1,null,12,5 null,APP,GETPCTEST1,G,1,-5,BIGINT,19,40,0,10,1,null,12,6 null,APP,GETPCTEST1,H,1,8,DOUBLE,52,8,null,2,1,null,12,7 null,APP,GETPCTEST1,I,1,8,DOUBLE,52,8,null,2,1,null,12,8 null,APP,GETPCTEST1,K,1,91,DATE,10,6,0,10,1,null,12,9 null,APP,GETPCTEST1,L,1,92,TIME,8,6,0,10,1,null,12,10 null,APP,GETPCTEST1,T,1,93,TIMESTAMP,26,16,6,10,1,null,12,11 null,APP,GETPCTEST2,PA,1,4,INTEGER,10,4,0,10,1,null,2,0 null,APP,GETPCTEST2,PB,1,-5,BIGINT,19,40,0,10,1,null,2,1 null,APP,GETPCTEST3A,STRING1,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3A,STRING2,4,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,10,null,null,1,null,2,0 null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,10,null,null,1,null,2,1 null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,1,0 getTables() with TABLE_TYPE in ('SYSTEM TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],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[VARCHAR],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,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTables() with TABLE_TYPE in ('VIEW','TABLE') : TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR] ,APP,ALLTYPES,TABLE, ,APP,INFLIGHT,TABLE, ,APP,LOUIE,TABLE, ,APP,PHASE,TABLE, ,APP,REFTAB,TABLE, ,APP,REFTAB2,TABLE, ,APP,T,TABLE, ,APP,TABLE1,TABLE, ,APP,SCREWIE,VIEW, getTableTypes(): TABLE_TYPE[VARCHAR] SYSTEM TABLE TABLE VIEW getColumns(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO getColumns('ALLTYPES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,ALLTYPES,SMALLINTCOL,5,SMALLINT,5,null,0,10,1,,null,null,null,null,1,YES ,APP,ALLTYPES,INTCOL,4,INTEGER,10,null,0,10,1,,20,null,null,null,2,YES ,APP,ALLTYPES,BIGINTCOL,-5,BIGINT,19,null,0,10,1,,null,null,null,null,3,YES ,APP,ALLTYPES,REALCOL,7,REAL,23,null,null,2,1,,null,null,null,null,4,YES ,APP,ALLTYPES,DOUBLEPRECCOL,8,DOUBLE,52,null,null,2,1,,10,null,null,null,5,YES ,APP,ALLTYPES,FLOATCOL,8,DOUBLE,52,null,null,2,1,,8.8,null,null,null,6,YES ,APP,ALLTYPES,DECIMALCOL10P4S,3,DECIMAL,10,null,4,10,1,,null,null,null,null,7,YES ,APP,ALLTYPES,NUMERICCOL20P2S,2,NUMERIC,20,null,2,10,1,,null,null,null,null,8,YES ,APP,ALLTYPES,CHAR8COL___,1,CHAR,8,null,null,null,1,,null,null,null,16,9,YES ,APP,ALLTYPES,CHAR8FORBITCOL___,-2,CHAR () FOR BIT DATA,8,null,null,null,1,,null,null,null,null,10,YES ,APP,ALLTYPES,VARCHAR9COL,12,VARCHAR,9,null,null,null,1,,null,null,null,18,11,YES ,APP,ALLTYPES,VARCHAR9BITCOL,-3,VARCHAR () FOR BIT DATA,9,null,null,null,1,,null,null,null,null,12,YES ,APP,ALLTYPES,LONGVARCHARCOL,-1,LONG VARCHAR,32700,null,null,null,1,,null,null,null,null,13,YES ,APP,ALLTYPES,LONGVARBINARYCOL,-4,LONG VARCHAR FOR BIT DATA,32700,null,null,null,1,,null,null,null,null,14,YES ,APP,ALLTYPES,BLOBCOL,2004,BLOB,3072,null,null,null,1,,null,null,null,null,15,YES ,APP,ALLTYPES,CLOBCOL,2005,CLOB,3072,null,null,null,1,,null,null,null,null,16,YES ,APP,ALLTYPES,DATECOL,91,DATE,10,null,0,10,1,,null,null,null,null,17,YES ,APP,ALLTYPES,TIMECOL,92,TIME,8,null,0,10,1,,null,null,null,null,18,YES ,APP,ALLTYPES,TSCOL,93,TIMESTAMP,26,null,6,10,1,,null,null,null,null,19,YES getColumns('LOUIE'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,LOUIE,I,4,INTEGER,10,null,0,10,0,,10,null,null,null,1,NO ,APP,LOUIE,S,5,SMALLINT,5,null,0,10,0,,null,null,null,null,2,NO ,APP,LOUIE,C30,1,CHAR,30,null,null,null,0,,null,null,null,60,3,NO ,APP,LOUIE,VC10,12,VARCHAR,10,null,null,null,0,,'asdf',null,null,20,4,NO ,APP,LOUIE,AI,-5,BIGINT,19,null,0,10,0,,AUTOINCREMENT: start -10 increment 2001,null,null,null,5,NO getColumns('INFLIGHT'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,APP,INFLIGHT,FLT_NUM,1,CHAR,20,null,null,null,0,,null,null,null,40,1,NO ,APP,INFLIGHT,FLT_ORIGIN,1,CHAR,6,null,null,null,1,,null,null,null,12,2,YES ,APP,INFLIGHT,FLT_DEST,1,CHAR,6,null,null,null,1,,null,null,null,12,3,YES ,APP,INFLIGHT,FLT_AIRCRAFT,1,CHAR,20,null,null,null,1,,null,null,null,40,4,YES ,APP,INFLIGHT,FLT_FLYING_TIME,12,VARCHAR,22,null,null,null,1,,null,null,null,44,5,YES ,APP,INFLIGHT,FLT_DEPT_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,6,YES ,APP,INFLIGHT,FLT_ARR_TIME,1,CHAR,8,null,null,null,1,,null,null,null,16,7,YES ,APP,INFLIGHT,FLT_NOTES,12,VARCHAR,510,null,null,null,1,,null,null,null,1020,8,YES ,APP,INFLIGHT,FLT_DAYS_OF_WK,1,CHAR,14,null,null,null,1,,null,null,null,28,9,YES ,APP,INFLIGHT,FLT_CRAFT_PIC,12,VARCHAR,32672,null,null,null,1,,null,null,null,65344,10,YES getColumnPrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],GRANTOR[VARCHAR],GRANTEE[VARCHAR],PRIVILEGE[VARCHAR],IS_GRANTABLE[VARCHAR] getTablePrivileges(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],GRANTOR[VARCHAR],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],PSEUDO_COLUMN[SMALLINT] 2,I,4,INTEGER,4,null,10,1 2,VC10,12,VARCHAR,10,null,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],PSEUDO_COLUMN[SMALLINT] 2,TABLEID,1,CHAR,36,null,null,1 getVersionColumns(): SCOPE[INTEGER],COLUMN_NAME[VARCHAR],DATA_TYPE[INTEGER],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],PSEUDO_COLUMN[INTEGER] getPrimaryKeys(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],KEY_SEQ[INTEGER],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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[VARCHAR],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],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[INTEGER],CASE_SENSITIVE[BOOLEAN],SEARCHABLE[INTEGER],UNSIGNED_ATTRIBUTE[BOOLEAN],FIXED_PREC_SCALE[BOOLEAN],AUTO_INCREMENT[BOOLEAN],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[INTEGER],MAXIMUM_SCALE[INTEGER],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],NUM_PREC_RADIX[INTEGER] BIGINT,-5,19,null,null,null,1,false,2,false,false,true,BIGINT,0,0,null,null,10 LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,false,2,true,false,false,LONG VARCHAR FOR BIT DATA,null,null,null,null,null VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,false,2,true,false,false,VARCHAR () FOR BIT DATA,null,null,null,null,null CHAR () FOR BIT DATA,-2,254,X',',length,1,false,2,true,false,false,CHAR () FOR BIT DATA,null,null,null,null,null LONG VARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG VARCHAR,null,null,null,null,null LONG NVARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG NVARCHAR,null,null,null,null,null CHAR,1,254,',',length,1,true,3,true,false,false,CHAR,null,null,null,null,null NATIONAL CHAR,1,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR,null,null,null,null,null NUMERIC,2,31,null,null,precision,scale,1,false,2,false,true,false,NUMERIC,0,32767,null,null,10 DECIMAL,3,31,null,null,precision,scale,1,false,2,false,true,false,DECIMAL,0,32767,null,null,10 INTEGER,4,10,null,null,null,1,false,2,false,false,true,INTEGER,0,0,null,null,10 SMALLINT,5,5,null,null,null,1,false,2,false,false,true,SMALLINT,0,0,null,null,10 FLOAT,6,52,null,null,precision,1,false,2,false,false,false,FLOAT,null,null,null,null,2 REAL,7,23,null,null,null,1,false,2,false,false,false,REAL,null,null,null,null,2 DOUBLE,8,52,null,null,null,1,false,2,false,false,false,DOUBLE,null,null,null,null,2 VARCHAR,12,32672,',',length,1,true,3,true,false,false,VARCHAR,null,null,null,null,null NATIONAL CHAR VARYING,12,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR VARYING,null,null,null,null,null DATE,91,10,DATE',',null,1,false,2,true,false,false,DATE,0,0,null,null,10 TIME,92,8,TIME',',null,1,false,2,true,false,false,TIME,0,0,null,null,10 TIMESTAMP,93,26,TIMESTAMP',',null,1,false,2,true,false,false,TIMESTAMP,0,6,null,null,10 BLOB,2004,2147483647,null,null,length,1,false,1,null,false,null,BLOB,null,null,null,null,null CLOB,2005,2147483647,',',length,1,true,1,null,false,null,CLOB,null,null,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null ,SYS,SYSCOLUMNS,true,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null getIndexInfo(): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR] ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null ,SYS,SYSTABLES,false,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null getColumns('SYSTABLES'): TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR] ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO Test escaped numeric functions - JDBC 3.0 C.1 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ABS(-25.67) } -- = >25.67< << Executing VALUES { fn MOD(124, 7) } -- = >5< << Executing VALUES { fn SQRT(6.22) } -- = >2.49< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ACOS(1.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13. Executing VALUES { fn ASIN(1.21) } -- SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13. Executing VALUES { fn ATAN(0.34) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN" at line 1, column 13. Executing VALUES { fn ATAN2(0.56, 1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "ATAN2" at line 1, column 13. Executing VALUES { fn CEILING(3.45) } -- SQLSTATE(42X01): Syntax error: Encountered "CEILING" at line 1, column 13. Executing VALUES { fn COS(1.2) } -- SQLSTATE(42X01): Syntax error: Encountered "COS" at line 1, column 13. Executing VALUES { fn COT(3.4) } -- SQLSTATE(42X01): Syntax error: Encountered "COT" at line 1, column 13. Executing VALUES { fn DEGREES(2.1) } -- SQLSTATE(42X01): Syntax error: Encountered "DEGREES" at line 1, column 13. Executing VALUES { fn EXP(2.3) } -- SQLSTATE(42X01): Syntax error: Encountered "EXP" at line 1, column 13. Executing VALUES { fn FLOOR(3.22) } -- SQLSTATE(42X01): Syntax error: Encountered "FLOOR" at line 1, column 13. Executing VALUES { fn LOG(34.1) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG" at line 1, column 13. Executing VALUES { fn LOG10(18.7) } -- SQLSTATE(42X01): Syntax error: Encountered "LOG10" at line 1, column 13. Executing VALUES { fn PI() } -- SQLSTATE(42X01): Syntax error: Encountered "PI" at line 1, column 13. Executing VALUES { fn POWER(2, 3) } -- SQLSTATE(42X01): Syntax error: Encountered "POWER" at line 1, column 13. Executing VALUES { fn RADIANS(54) } -- SQLSTATE(42X01): Syntax error: Encountered "RADIANS" at line 1, column 13. Executing VALUES { fn RAND(17) } -- SQLSTATE(42X01): Syntax error: Encountered "RAND" at line 1, column 13. Executing VALUES { fn ROUND(345.345, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "ROUND" at line 1, column 13. Executing VALUES { fn SIGN(-34) } -- SQLSTATE(42X01): Syntax error: Encountered "SIGN" at line 1, column 13. Executing VALUES { fn SIN(0.32) } -- SQLSTATE(42X01): Syntax error: Encountered "SIN" at line 1, column 13. Executing VALUES { fn TAN(0.57) } -- SQLSTATE(42X01): Syntax error: Encountered "TAN" at line 1, column 13. Executing VALUES { fn TRUNCATE(345.395, 1) } -- SQLSTATE(42X01): Syntax error: Encountered "TRUNCATE" at line 1, column 13. Test escaped string functions - JDBC 3.0 C.2 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn CONCAT('hello', 'there') } -- = >hellothere< << Executing VALUES { fn LENGTH('four ') } -- = >4< << Executing VALUES { fn LCASE('Fernando Alonso') } -- = >fernando alonso< << Executing VALUES { fn LOCATE('jour', 'Bonjour') } -- = >4< << Executing VALUES { fn LTRIM(' left trim ') } -- = >left trim < << Executing VALUES { fn RTRIM(' right trim ') } -- = > right trim< << Executing VALUES { fn SUBSTRING('Ruby the Rubicon Jeep', 10, 7) } -- = >Rubicon< << Executing VALUES { fn UCASE('Fernando Alonso') } -- = >FERNANDO ALONSO< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn ASCII('Yellow') } -- SQLSTATE(42X01): Syntax error: Encountered "ASCII" at line 1, column 13. Executing VALUES { fn CHAR(65) } -- = >65 < << FAIL function works but not declared in list: CHAR Executing VALUES { fn DIFFERENCE('Pires', 'Piers') } -- SQLSTATE(42X01): Syntax error: Encountered "DIFFERENCE" at line 1, column 13. Executing VALUES { fn INSERT('Bill Clinton', 4, 'William') } -- SQLSTATE(42X01): Syntax error: Encountered "INSERT" at line 1, column 13. Executing VALUES { fn LEFT('Bonjour', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "LEFT" at line 1, column 13. Executing VALUES { fn REPEAT('echo', 3) } -- SQLSTATE(42X01): Syntax error: Encountered "REPEAT" at line 1, column 13. Executing VALUES { fn REPLACE('to be or not to be', 'be', 'England') } -- SQLSTATE(42X01): Syntax error: Encountered "REPLACE" at line 1, column 13. Executing VALUES { fn SOUNDEX('Derby') } -- SQLSTATE(42X01): Syntax error: Encountered "SOUNDEX" at line 1, column 13. Executing VALUES { fn SPACE(12) } -- SQLSTATE(42X01): Syntax error: Encountered "SPACE" at line 1, column 13. Test escaped date time functions - JDBC 3.0 C.3 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END -- = >OK< << Executing VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END -- = >OK< << Executing VALUES { fn HOUR({t '16:13:03'}) } -- = >16< << Executing VALUES { fn MINUTE({t '16:13:03'}) } -- = >13< << Executing VALUES { fn MONTH({d '1995-12-19'}) } -- = >12< << Executing VALUES { fn SECOND({t '16:13:03'}) } -- = >3< << Executing VALUES { fn TIMESTAMPADD(SQL_TSI_DAY, 7, {ts '1995-12-19 12:15:54'}) } -- = >1995-12-26 12:15:54.0< << Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts '1995-12-19 12:15:54'}, {ts '1997-11-02 00:15:23'}) } -- = >683< << Executing VALUES { fn YEAR({d '1995-12-19'}) } -- = >1995< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DAYNAME({d '1995-12-19'h}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYNAME" at line 1, column 13. Executing VALUES { fn DAYOFMONTH({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFMONTH" at line 1, column 13. Executing VALUES { fn DAYOFWEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFWEEK" at line 1, column 13. Executing VALUES { fn DAYOFYEAR({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "DAYOFYEAR" at line 1, column 13. Executing VALUES { fn MONTHNAME({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "MONTHNAME" at line 1, column 13. Executing VALUES CASE WHEN { fn NOW()} = CURRENT_TIMESTAMP THEN 'OK' ELSE 'wrong' END -- SQLSTATE(42X01): Syntax error: Encountered "NOW" at line 1, column 23. Executing VALUES { fn QUARTER({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "QUARTER" at line 1, column 13. Executing VALUES { fn WEEK({d '1995-12-19'}) } -- SQLSTATE(42X01): Syntax error: Encountered "WEEK" at line 1, column 13. Test escaped system functions - JDBC 3.0 C.4 TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn USER() } -- = >APP< << TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST Executing VALUES { fn DATABASE() } -- SQLSTATE(42X01): Syntax error: Encountered "DATABASE" at line 1, column 13. Executing VALUES { fn IFNULL('this', 'that') } -- SQLSTATE(42X01): Syntax error: Encountered "IFNULL" at line 1, column 13. --------------------------------------- Referential action values RESTRICT = 1 NO ACTION = 3 CASCADE = 0 SETNULL = 2 SETDEFAULT = 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[VARCHAR],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,SQL051211105627120,SQL051211105626870,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[VARCHAR],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,SQL051211105627510,SQL051211105626870,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[VARCHAR],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,SQL051211105628200,SQL051211105626870,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[VARCHAR],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,SQL051211105629140,SQL051211105626870,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[VARCHAR],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,SQL051211105629940,SQL051211105626870,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[VARCHAR],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,SQL051211105630400,SQL051211105626870,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[VARCHAR],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,SQL051211105630770,SQL051211105626870,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[VARCHAR],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,SQL051211105629140,SQL051211105626870,7 ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,SQL051211105628200,SQL051211105626870,7 ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,SQL051211105627120,SQL051211105626870,7 ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,SQL051211105627510,SQL051211105626870,7 ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,SQL051211105629940,SQL051211105626870,7 ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,SQL051211105630770,SQL051211105626870,7 ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,SQL051211105630400,SQL051211105626870,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 END - PASS - phase UPGRADE db version 10.1 START - phase POST UPGRADE db version 10.1 jdbc url is jdbc:derby:updtest_10_1/su_10_1 SQL Exception: Failed to start database 'updtest_10_1/su_10_1', see the next exception for details. SQL Exception: Database at C:\p4clients\main\systest\out142\updtest_10_1\su_10_1 is at version 10.2 beta. Beta databases cannot be upgraded, Engine Apache Derby 10.1.2.2 complete caseConnectionCheck - passed true END - PASS - phase POST UPGRADE db version 10.1