metadata.out

derby database source code.good for you.

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.3.1)
The URL is: jdbc:derby:wombat
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
allProceduresAreCallable(): true
getUserName(): APP
isReadOnly(): false
nullsAreSortedHigh(): true
nullsAreSortedLow(): false
nullsAreSortedAtStart(): false
nullsAreSortedAtEnd(): false
getDatabaseProductName(): Apache Derby
getDatabaseProductVersion(): 10.1.3.1
getDriverVersion(): 10.1.3.1
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
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