odbc_metadata.out

derby database source code.good for you.

=============== Begin ODBC 3.0 Compliance Tests =================
SQLProcedures:
==> ODBC type/name checking done.
SQLProcedureColumns:
==> ODBC type/name checking done.
SQLTables:
==> ODBC type/name checking done.
SQLColumns:
==> ODBC type/name checking done.
SQLColumnPrivileges:
==> ODBC type/name checking done.
SQLTablePrivileges:
==> ODBC type/name checking done.
SQLSpecialColumns: getBestRowIdentifier
==> ODBC type/name checking done.
SQLSpecialColumns: getVersionColumns
==> ODBC type/name checking done.
SQLPrimaryKeys:
==> ODBC type/name checking done.
SQLForeignKeys: getImportedKeys
==> ODBC type/name checking done.
SQLForeignKeys: getExportedKeys
==> ODBC type/name checking done.
SQLForeignKeys: getCrossReference
==> ODBC type/name checking done.
SQLGetTypeInfo
==> ODBC type/name checking done.
SQLStatistics:
==> ODBC type/name checking done.
=============== End ODBC 3.0 Compliance Tests =================
Test metadata starting
Column display size of the union result is: 12
dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
dec(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
real + dec(10,2) -- precision: 7 scale: 0 display size: 13 type name: REAL
double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 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 'IBM DB2 JDBC Universal Driver Architecture', version (EXPECTED VERSION)
The URL is: jdbc:derby:net://localhost:1527/wombat;create=true
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],NUM_INPUT_PARAMS[INTEGER],NUM_OUTPUT_PARAMS[INTEGER],NUM_RESULT_SETS[INTEGER],REMARKS[VARCHAR],PROCEDURE_TYPE[SMALLINT]
,APP,GETPCTEST1,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1
,APP,GETPCTEST2,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1
,APP,GETPCTEST3A,null,null,null,org.apache.derbyTesting.functionTests.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
allProceduresAreCallable(): true
getUserName(): APP
isReadOnly(): false
nullsAreSortedHigh(): true
nullsAreSortedLow(): false
nullsAreSortedAtStart(): false
nullsAreSortedAtEnd(): false
getDatabaseProductName(): Apache Derby
getDatabaseProductVersion(): 10.1.3.1
getDriverVersion(): EXPECTED VERSION
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(): true
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