db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r498840 [3/3] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ master/DerbyNetClient/ tests/jdbcapi/
Date Mon, 22 Jan 2007 22:51:48 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out?view=diff&rev=498840&r1=498839&r2=498840
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out Mon Jan 22 14:51:46 2007
@@ -14,22 +14,6 @@
 dc / 2 = 5.55000000000000000000000
 dc / 2 = 5.55500000000000000000000
 JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.3 (10.3.0.0 alpha -(EXPECTED SUBVERSION INFO))
-DatabaseMetaData.getURL test passed
-allTablesAreSelectable(): true
-maxColumnNameLength(): 128
-getSchemas():
-TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
-APP,null
-NULLID,null
-SQLJ,null
-SYS,null
-SYSCAT,null
-SYSCS_DIAG,null
-SYSCS_UTIL,null
-SYSFUN,null
-SYSIBM,null
-SYSPROC,null
-SYSSTAT,null
 getSchemas(String, String):
 TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
 APP,null
@@ -55,11 +39,6 @@
 TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
 APP,null
 TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
-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],SPECIFIC_NAME[VARCHAR]
 ,APP,GETPCTEST1,null,null,null,org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getpc,1,xxxxGENERATED-IDxxxx
@@ -141,117 +120,7 @@
 TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR],BASE_TYPE[SMALLINT]
 getClientInfoProperties():
 NAME[VARCHAR],MAX_LEN[INTEGER],DEFAULT_VALUE[VARCHAR],DESCRIPTION[VARCHAR]
-allProceduresAreCallable(): true
-getUserName(): APP
-isReadOnly(): false
-nullsAreSortedHigh(): true
-nullsAreSortedLow(): false
-nullsAreSortedAtStart(): false
-nullsAreSortedAtEnd(): false
-getDatabaseProductName(): Apache Derby
-getDatabaseProductVersion(): 10.3.0.0 alpha -(EXPECTED SUBVERSION INFO)
-getDriverVersion(): 10.3.0.0 alpha -(EXPECTED SUBVERSION INFO)
-usesLocalFiles(): true
-usesLocalFilePerTable(): true
-supportsMixedCaseIdentifiers(): false
-storesUpperCaseIdentifiers(): true
-storesLowerCaseIdentifiers(): false
-storesMixedCaseIdentifiers(): false
-supportsMixedCaseQuotedIdentifiers(): true
-storesUpperCaseQuotedIdentifiers(): false
-storesLowerCaseQuotedIdentifiers(): false
-storesMixedCaseQuotedIdentifiers(): true
-getIdentifierQuoteString(): "
-getNumericFunctions(): ABS,ACOS,ASIN,ATAN,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MOD,PI,RADIANS,RAND,SIGN,SIN,SQRT,TAN
-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(): true
-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
-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.
@@ -295,7 +164,6 @@
 SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_UPDATABLE: true
 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[INTEGER],TYPE_NAME[VARCHAR],PRECISION[INTEGER],LENGTH[INTEGER],SCALE[SMALLINT],RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR],SPECIFIC_NAME[VARCHAR],METHOD_ID[SMALLINT],PARAMETER_ID[SMALLINT]
 null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,6,null,null,1,null,null,null,null,6,1,YES,xxxxGENERATED-IDxxxx,12,0
@@ -317,70 +185,6 @@
 null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,10,null,null,1,null,null,null,null,10,1,YES,xxxxGENERATED-IDxxxx,2,0
 null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,10,null,null,1,null,null,null,null,10,2,YES,xxxxGENERATED-IDxxxx,2,1
 null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,null,null,null,null,1,YES,xxxxGENERATED-IDxxxx,1,0
-getTables() with TABLE_TYPE in ('SYSTEM TABLE') :
-TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR],TYPE_CAT[VARCHAR],TYPE_SCHEM[VARCHAR],TYPE_NAME[VARCHAR],SELF_REFERENCING_COL_NAME[VARCHAR],REF_GENERATION[VARCHAR]
-,SYS,SYSALIASES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCHECKS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLUMNS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONGLOMERATES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONSTRAINTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSDEPENDS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFILES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFOREIGNKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSROUTINEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSCHEMAS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATEMENTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATISTICS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTRIGGERS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSVIEWS,SYSTEM TABLE,,null,null,null,null,null
-,SYSIBM,SYSDUMMY1,SYSTEM TABLE,,null,null,null,null,null
-getTables() with no types:
-TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR],TYPE_CAT[VARCHAR],TYPE_SCHEM[VARCHAR],TYPE_NAME[VARCHAR],SELF_REFERENCING_COL_NAME[VARCHAR],REF_GENERATION[VARCHAR]
-,SYS,SYSALIASES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCHECKS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLUMNS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONGLOMERATES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONSTRAINTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSDEPENDS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFILES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFOREIGNKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSROUTINEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSCHEMAS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATEMENTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATISTICS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTRIGGERS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSVIEWS,SYSTEM TABLE,,null,null,null,null,null
-,SYSIBM,SYSDUMMY1,SYSTEM TABLE,,null,null,null,null,null
-,APP,ALLTYPES,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,REFTAB,TABLE,,null,null,null,null,null
-,APP,REFTAB2,TABLE,,null,null,null,null,null
-,APP,T,TABLE,,null,null,null,null,null
-,APP,SCREWIE,VIEW,,null,null,null,null,null
-getTables() with TABLE_TYPE in ('VIEW','TABLE') :
-TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR],TYPE_CAT[VARCHAR],TYPE_SCHEM[VARCHAR],TYPE_NAME[VARCHAR],SELF_REFERENCING_COL_NAME[VARCHAR],REF_GENERATION[VARCHAR]
-,APP,ALLTYPES,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,REFTAB,TABLE,,null,null,null,null,null
-,APP,REFTAB2,TABLE,,null,null,null,null,null
-,APP,T,TABLE,,null,null,null,null,null
-,APP,SCREWIE,VIEW,,null,null,null,null,null
-getTableTypes():
-TABLE_TYPE[VARCHAR]
-SYNONYM
-SYSTEM TABLE
-TABLE
-VIEW
 getColumns():
 TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[INTEGER],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],SCOPE_CATLOG[VARCHAR],SCOPE_SCHEMA[VARCHAR],SCOPE_TABLE[VARCHAR],SOURCE_DATA_TYPE[SMALLINT],IS_AUTOINCREMENT[VARCHAR]
 getColumns('SYSTABLES'):
@@ -525,30 +329,6 @@
 ,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[INTEGER],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[SMALLINT],CASE_SENSITIVE[BOOLEAN],SEARCHABLE[SMALLINT],UNSIGNED_ATTRIBUTE[BOOLEAN],FIXED_PREC_SCALE[BOOLEAN],AUTO_INCREMENT[BOOLEAN],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[SMALLINT],MAXIMUM_SCALE[SMALLINT],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[SMALLINT],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
@@ -570,102 +350,6 @@
 ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO,null,null,null,null,NO
 ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO,null,null,null,null,NO
 ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO,null,null,null,null,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 ACOS(0.0707) } --   = >1.50<  << 
-Executing VALUES { fn ASIN(0.997) } --   = >1.49<  << 
-Executing VALUES { fn ATAN(14.10) } --   = >1.49<  << 
-Executing VALUES { fn CEILING(3.45) } --   = >4.0<  << 
-Executing VALUES { fn COS(1.2) } --   = >0.36<  << 
-Executing VALUES { fn COT(3.4) } --   = >3.78<  << 
-Executing VALUES { fn DEGREES(2.1) } --   = >120.<  << 
-Executing VALUES { fn EXP(2.3) } --   = >9.97<  << 
-Executing VALUES { fn FLOOR(3.22) } --   = >3.0<  << 
-Executing VALUES { fn LOG(34.1) } --   = >3.52<  << 
-Executing VALUES { fn LOG10(18.7) } --   = >1.27<  << 
-Executing VALUES { fn MOD(124, 7) } --   = >5<  << 
-Executing VALUES { fn PI() } --   = >3.14<  << 
-Executing VALUES { fn RADIANS(54) } --   = >0.94<  << 
-Executing VALUES { fn RAND(17) } --   = >0.73<  << 
-Executing VALUES { fn SIGN(-34) } --   = >-1<  << 
-Executing VALUES { fn SIN(0.32) } --   = >0.31<  << 
-Executing VALUES { fn SQRT(6.22) } --   = >2.49<  << 
-Executing VALUES { fn TAN(0.57) } --   = >0.64<  << 
-TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
-Executing VALUES { fn ATAN2(0.56, 1.2) } -- 
-SQLSTATE(42X01): Syntax error: Encountered "ATAN2" 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 ROUND(345.345, 1) } -- 
-SQLSTATE(42X01): Syntax error: Encountered "ROUND" 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 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } --   = >xxxxxxFILTERED-TIMESTAMPxxxxx<  << 
-Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } --   = >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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out?view=diff&rev=498840&r1=498839&r2=498840
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out Mon Jan 22 14:51:46 2007
@@ -44,22 +44,6 @@
 dc / 2 = 5.55000000000000000000000
 dc / 2 = 5.55500000000000000000000
 JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.3 (10.3.0.0 alpha -(EXPECTED SUBVERSION INFO))
-DatabaseMetaData.getURL test passed
-allTablesAreSelectable(): true
-maxColumnNameLength(): 128
-getSchemas():
-TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
-APP,null
-NULLID,null
-SQLJ,null
-SYS,null
-SYSCAT,null
-SYSCS_DIAG,null
-SYSCS_UTIL,null
-SYSFUN,null
-SYSIBM,null
-SYSPROC,null
-SYSSTAT,null
 getSchemas(String, String):
 TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
 APP,null
@@ -85,11 +69,6 @@
 TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
 APP,null
 TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
-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
@@ -171,117 +150,7 @@
 TYPE_CAT[CHAR],TYPE_SCHEM[CHAR],TYPE_NAME[VARCHAR],CLASS_NAME[LONG VARCHAR],DATA_TYPE[INTEGER],REMARKS[CHAR],BASE_TYPE[SMALLINT]
 getClientInfoProperties():
 NAME[VARCHAR],MAX_LEN[INTEGER],DEFAULT_VALUE[VARCHAR],DESCRIPTION[VARCHAR]
-allProceduresAreCallable(): true
-getUserName(): APP
-isReadOnly(): false
-nullsAreSortedHigh(): true
-nullsAreSortedLow(): false
-nullsAreSortedAtStart(): false
-nullsAreSortedAtEnd(): false
-getDatabaseProductName(): Apache Derby
-getDatabaseProductVersion(): 10.3.0.0 alpha -(EXPECTED SUBVERSION INFO)
-getDriverVersion(): 10.3.0.0 alpha -(EXPECTED SUBVERSION INFO)
-usesLocalFiles(): true
-usesLocalFilePerTable(): true
-supportsMixedCaseIdentifiers(): false
-storesUpperCaseIdentifiers(): true
-storesLowerCaseIdentifiers(): false
-storesMixedCaseIdentifiers(): false
-supportsMixedCaseQuotedIdentifiers(): true
-storesUpperCaseQuotedIdentifiers(): false
-storesLowerCaseQuotedIdentifiers(): false
-storesMixedCaseQuotedIdentifiers(): true
-getIdentifierQuoteString(): "
-getNumericFunctions(): ABS,ACOS,ASIN,ATAN,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MOD,PI,RADIANS,RAND,SIGN,SIN,SQRT,TAN
-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(): true
-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
-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.
@@ -325,7 +194,6 @@
 SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_UPDATABLE: true
 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],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_DATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR],METHOD_ID[SMALLINT],PARAMETER_ID[SMALLINT]
 null,APP,GETPCTEST1,OUTB,4,12,VARCHAR,3,6,null,null,1,null,null,12,null,6,1,YES,12,0
@@ -347,70 +215,6 @@
 null,APP,GETPCTEST3B,STRING3,1,12,VARCHAR,5,10,null,null,1,null,null,12,null,10,1,YES,2,0
 null,APP,GETPCTEST3B,STRING4,2,12,VARCHAR,5,10,null,null,1,null,null,12,null,10,2,YES,2,1
 null,APP,GETPCTEST4BX,RETPARAM,4,4,INTEGER,10,4,0,10,1,null,null,4,null,null,1,YES,1,0
-getTables() with TABLE_TYPE in ('SYSTEM TABLE') :
-TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR],TYPE_CAT[VARCHAR],TYPE_SCHEM[VARCHAR],TYPE_NAME[VARCHAR],SELF_REFERENCING_COL_NAME[VARCHAR],REF_GENERATION[VARCHAR]
-,SYS,SYSALIASES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCHECKS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLUMNS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONGLOMERATES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONSTRAINTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSDEPENDS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFILES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFOREIGNKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSROUTINEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSCHEMAS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATEMENTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATISTICS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTRIGGERS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSVIEWS,SYSTEM TABLE,,null,null,null,null,null
-,SYSIBM,SYSDUMMY1,SYSTEM TABLE,,null,null,null,null,null
-getTables() with no types:
-TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR],TYPE_CAT[VARCHAR],TYPE_SCHEM[VARCHAR],TYPE_NAME[VARCHAR],SELF_REFERENCING_COL_NAME[VARCHAR],REF_GENERATION[VARCHAR]
-,SYS,SYSALIASES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCHECKS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCOLUMNS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONGLOMERATES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSCONSTRAINTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSDEPENDS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFILES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSFOREIGNKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSKEYS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSROUTINEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSCHEMAS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATEMENTS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSSTATISTICS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLEPERMS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTABLES,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSTRIGGERS,SYSTEM TABLE,,null,null,null,null,null
-,SYS,SYSVIEWS,SYSTEM TABLE,,null,null,null,null,null
-,SYSIBM,SYSDUMMY1,SYSTEM TABLE,,null,null,null,null,null
-,APP,ALLTYPES,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,REFTAB,TABLE,,null,null,null,null,null
-,APP,REFTAB2,TABLE,,null,null,null,null,null
-,APP,T,TABLE,,null,null,null,null,null
-,APP,SCREWIE,VIEW,,null,null,null,null,null
-getTables() with TABLE_TYPE in ('VIEW','TABLE') :
-TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],TABLE_TYPE[VARCHAR],REMARKS[VARCHAR],TYPE_CAT[VARCHAR],TYPE_SCHEM[VARCHAR],TYPE_NAME[VARCHAR],SELF_REFERENCING_COL_NAME[VARCHAR],REF_GENERATION[VARCHAR]
-,APP,ALLTYPES,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,REFTAB,TABLE,,null,null,null,null,null
-,APP,REFTAB2,TABLE,,null,null,null,null,null
-,APP,T,TABLE,,null,null,null,null,null
-,APP,SCREWIE,VIEW,,null,null,null,null,null
-getTableTypes():
-TABLE_TYPE[VARCHAR]
-SYNONYM
-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[SMALLINT],NUM_PREC_RADIX[SMALLINT],NULLABLE[SMALLINT],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[SMALLINT],SQL_DATETIME_SUB[SMALLINT],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR],SCOPE_CATLOG[VARCHAR],SCOPE_SCHEMA[VARCHAR],SCOPE_TABLE[VARCHAR],SOURCE_DATA_TYPE[SMALLINT],IS_AUTOINCREMENT[VARCHAR]
 getColumns('SYSTABLES'):
@@ -555,30 +359,6 @@
 ,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],COLUMN_SIZE[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[SMALLINT],CASE_SENSITIVE[SMALLINT],SEARCHABLE[SMALLINT],UNSIGNED_ATTRIBUTE[SMALLINT],FIXED_PREC_SCALE[SMALLINT],AUTO_UNIQUE_VAL[SMALLINT],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[SMALLINT],MAXIMUM_SCALE[SMALLINT],SQL_DATA_TYPE[SMALLINT],SQL_DATETIME_SUB[SMALLINT],NUM_PREC_RADIX[INTEGER],INTERVAL_PRECISION[SMALLINT]
-BIGINT,-5,19,null,null,null,1,0,2,0,0,1,BIGINT,0,0,-5,null,10,null
-LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,0,2,null,0,null,LONG VARCHAR FOR BIT DATA,null,null,-4,null,null,null
-VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,0,2,null,0,null,VARCHAR () FOR BIT DATA,null,null,-3,null,null,null
-CHAR () FOR BIT DATA,-2,254,X',',length,1,0,2,null,0,null,CHAR () FOR BIT DATA,null,null,-2,null,null,null
-LONG VARCHAR,-1,32700,',',null,1,1,3,null,0,null,LONG VARCHAR,null,null,-1,null,null,null
-LONG NVARCHAR,-1,32700,',',null,1,1,3,null,0,null,LONG NVARCHAR,null,null,-1,null,null,null
-CHAR,1,254,',',length,1,1,3,null,0,null,CHAR,null,null,1,null,null,null
-NATIONAL CHAR,1,2147483647,',',length,1,1,3,null,0,null,NATIONAL CHAR,null,null,1,null,null,null
-NUMERIC,2,31,null,null,precision,scale,1,0,2,0,1,0,NUMERIC,0,32767,2,null,10,null
-DECIMAL,3,31,null,null,precision,scale,1,0,2,0,1,0,DECIMAL,0,32767,3,null,10,null
-INTEGER,4,10,null,null,null,1,0,2,0,0,1,INTEGER,0,0,4,null,10,null
-SMALLINT,5,5,null,null,null,1,0,2,0,0,1,SMALLINT,0,0,5,null,10,null
-FLOAT,6,52,null,null,precision,1,0,2,0,0,0,FLOAT,null,null,6,null,2,null
-REAL,7,23,null,null,null,1,0,2,0,0,0,REAL,null,null,7,null,2,null
-DOUBLE,8,52,null,null,null,1,0,2,0,0,0,DOUBLE,null,null,8,null,2,null
-VARCHAR,12,32672,',',length,1,1,3,null,0,null,VARCHAR,null,null,12,null,null,null
-NATIONAL CHAR VARYING,12,2147483647,',',length,1,1,3,null,0,null,NATIONAL CHAR VARYING,null,null,12,null,null,null
-DATE,91,10,DATE',',null,1,0,2,1,0,0,DATE,0,0,9,1,2,null
-TIME,92,8,TIME',',null,1,0,2,1,0,0,TIME,0,0,9,2,2,null
-TIMESTAMP,93,26,TIMESTAMP',',null,1,0,2,1,0,0,TIMESTAMP,0,6,9,3,2,null
-BLOB,2004,2147483647,null,null,length,1,0,1,null,0,null,BLOB,null,null,2004,null,null,null
-CLOB,2005,2147483647,',',length,1,1,1,null,0,null,CLOB,null,null,2005,null,null,null
 getIndexInfo():
 TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMALLINT],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[SMALLINT],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR]
 ,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null
@@ -601,102 +381,6 @@
 ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,72,null,null,0,,null,1,null,72,4,NO,null,null,null,null,NO
 ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,2,null,null,0,,null,1,null,2,5,NO,null,null,null,null,NO
 OK -- user result set closed by intervening OBDC getColumns request; this was expected because of the way the test works.
-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 ACOS(0.0707) } --   = >1.50<  << 
-Executing VALUES { fn ASIN(0.997) } --   = >1.49<  << 
-Executing VALUES { fn ATAN(14.10) } --   = >1.49<  << 
-Executing VALUES { fn CEILING(3.45) } --   = >4.0<  << 
-Executing VALUES { fn COS(1.2) } --   = >0.36<  << 
-Executing VALUES { fn COT(3.4) } --   = >3.78<  << 
-Executing VALUES { fn DEGREES(2.1) } --   = >120.<  << 
-Executing VALUES { fn EXP(2.3) } --   = >9.97<  << 
-Executing VALUES { fn FLOOR(3.22) } --   = >3.0<  << 
-Executing VALUES { fn LOG(34.1) } --   = >3.52<  << 
-Executing VALUES { fn LOG10(18.7) } --   = >1.27<  << 
-Executing VALUES { fn MOD(124, 7) } --   = >5<  << 
-Executing VALUES { fn PI() } --   = >3.14<  << 
-Executing VALUES { fn RADIANS(54) } --   = >0.94<  << 
-Executing VALUES { fn RAND(17) } --   = >0.73<  << 
-Executing VALUES { fn SIGN(-34) } --   = >-1<  << 
-Executing VALUES { fn SIN(0.32) } --   = >0.31<  << 
-Executing VALUES { fn SQRT(6.22) } --   = >2.49<  << 
-Executing VALUES { fn TAN(0.57) } --   = >0.64<  << 
-TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
-Executing VALUES { fn ATAN2(0.56, 1.2) } -- 
-SQLSTATE(42X01): Syntax error: Encountered "ATAN2" 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 ROUND(345.345, 1) } -- 
-SQLSTATE(42X01): Syntax error: Encountered "ROUND" 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 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } --   = >xxxxxxFILTERED-TIMESTAMPxxxxx<  << 
-Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } --   = >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

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadata_test.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadata_test.java?view=diff&rev=498840&r1=498839&r2=498840
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadata_test.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/metadata_test.java Mon Jan 22 14:51:46 2007
@@ -94,90 +94,6 @@
 	public Connection con;
 	public static Statement s;
 	
-	/*
-	** Escaped function testing
-	*/
-	private static final String[][] NUMERIC_FUNCTIONS =
-	{
-		// Section C.1 JDBC 3.0 spec.
-		{ "ABS", "-25.67" },
-		{ "ACOS", "0.0707" },
-		{ "ASIN", "0.997" },
-		{ "ATAN", "14.10" },
-		{ "ATAN2", "0.56", "1.2" },
-		{ "CEILING", "3.45" },
-		{ "COS", "1.2" },
-		{ "COT", "3.4" },
-		{ "DEGREES", "2.1" },
-		{ "EXP", "2.3" },
-		{ "FLOOR", "3.22" },
-		{ "LOG", "34.1" },
-		{ "LOG10", "18.7" },
-		{ "MOD", "124", "7" },
-		{ "PI" },
-		{ "POWER", "2", "3" },
-		{ "RADIANS", "54" },
-		{ "RAND", "17" }, 
-		{ "ROUND", "345.345", "1" }, 
-		{ "SIGN", "-34" },
-		{ "SIN", "0.32" },
-		{ "SQRT", "6.22" },
-		{ "TAN", "0.57", },
-		{ "TRUNCATE", "345.395", "1" }
-	};
-	
-	private static final String[][] TIMEDATE_FUNCTIONS =
-	{	
-		// Section C.3 JDBC 3.0 spec.
-		{ "CURDATE" },
-		{ "CURTIME" },
-		{ "DAYNAME", "{d '1995-12-19'h}" },
-		{ "DAYOFMONTH", "{d '1995-12-19'}" },
-		{ "DAYOFWEEK", "{d '1995-12-19'}" },
-		{ "DAYOFYEAR", "{d '1995-12-19'}" },
-		{ "HOUR", "{t '16:13:03'}" },
-		{ "MINUTE", "{t '16:13:03'}" },
-		{ "MONTH", "{d '1995-12-19'}" },
-		{ "MONTHNAME", "{d '1995-12-19'}" },
-		{ "NOW" },
-		{ "QUARTER", "{d '1995-12-19'}" },
-		{ "SECOND", "{t '16:13:03'}" },
-		{ "TIMESTAMPADD", "SQL_TSI_DAY", "7", "{ts '1995-12-19 12:15:54'}" },
-		{ "TIMESTAMPDIFF", "SQL_TSI_DAY", "{ts '1995-12-19 12:15:54'}", "{ts '1997-11-02 00:15:23'}" },
-		{ "WEEK", "{d '1995-12-19'}" },
-		{ "YEAR", "{d '1995-12-19'}" },
-		
-	};
-
-	private static final String[][] SYSTEM_FUNCTIONS =
-	{	
-		// Section C.4 JDBC 3.0 spec.
-		{ "DATABASE" },
-		{ "IFNULL", "'this'", "'that'" },
-		{ "USER"},
-		};	
-	
-	private static final String[][] STRING_FUNCTIONS =
-	{	
-		// Section C.2 JDBC 3.0 spec.
-		{ "ASCII" , "'Yellow'" },
-		{ "CHAR", "65" },
-		{ "CONCAT", "'hello'", "'there'" },
-		{ "DIFFERENCE", "'Pires'", "'Piers'" },
-		{ "INSERT", "'Bill Clinton'", "4", "'William'" },
-		{ "LCASE", "'Fernando Alonso'" },
-		{ "LEFT", "'Bonjour'", "3" },
-		{ "LENGTH", "'four    '" } ,
-		{ "LOCATE", "'jour'", "'Bonjour'" },
-		{ "LTRIM", "'   left trim   '"},
-		{ "REPEAT", "'echo'", "3" },
-		{ "REPLACE", "'to be or not to be'", "'be'", "'England'" },
-		{ "RTRIM", "'  right trim   '"},
-		{ "SOUNDEX", "'Derby'" },
-		{ "SPACE", "12"},
-		{ "SUBSTRING", "'Ruby the Rubicon Jeep'", "10", "7", },
-		{ "UCASE", "'Fernando Alonso'" }
-		};
 
 	public void runTest() {
 
@@ -380,45 +296,8 @@
 							   "." + met.getDriverMinorVersion() +
 							   " (" + met.getDriverVersion() + ")");
 
-			boolean pass = false;
-			try {
-				pass = TestUtil.compareURL(met.getURL());				 
-			}catch (NoSuchMethodError msme) {
-				// DatabaseMetaData.getURL not present - correct for JSR169
-				if(!TestUtil.HAVE_DRIVER_CLASS)
-					pass = true;
-			} catch (Throwable err) {
-			    System.out.println("%%getURL() gave the exception: " + err);
-			}
-			
-			if(pass)
-				System.out.println("DatabaseMetaData.getURL test passed");
-			else
-				System.out.println("FAIL: DatabaseMetaData.getURL test failed");
-
-			System.out.println("allTablesAreSelectable(): " +
-							   met.allTablesAreSelectable());
-			
-			System.out.println("maxColumnNameLength(): " + met.getMaxColumnNameLength());
-
-			System.out.println();
-			System.out.println("getSchemas():");
-			dumpRS(met.getSchemas());
-
 			testGetSchemasWithTwoParams(met);
 
-			System.out.println();
-			System.out.println("getCatalogs():");
-			dumpRS(met.getCatalogs());
-
-			System.out.println("getSearchStringEscape(): " +
-							   met.getSearchStringEscape());
-
-			System.out.println("getSQLKeywords(): " +
-							   met.getSQLKeywords());
-
-			System.out.println("getDefaultTransactionIsolation(): " +
-							   met.getDefaultTransactionIsolation());
 
 			System.out.println("getProcedures():");
 			dumpRS(GET_PROCEDURES, getMetaDataRS(met, GET_PROCEDURES,
@@ -533,230 +412,8 @@
 			 */
 
 
-			System.out.println("allProceduresAreCallable(): " +
-							   met.allProceduresAreCallable());
-			System.out.println("getUserName(): " +
-							   met.getUserName());
-			System.out.println("isReadOnly(): " +
-							   met.isReadOnly());
-			System.out.println("nullsAreSortedHigh(): " +
-							   met.nullsAreSortedHigh());
-			System.out.println("nullsAreSortedLow(): " +
-							   met.nullsAreSortedLow());
-			System.out.println("nullsAreSortedAtStart(): " +
-							   met.nullsAreSortedAtStart());
-			System.out.println("nullsAreSortedAtEnd(): " +
-							   met.nullsAreSortedAtEnd());
-
-
-			System.out.println("getDatabaseProductName(): " + met.getDatabaseProductName());
-
-			String v = met.getDatabaseProductVersion();
-			System.out.println("getDatabaseProductVersion(): " + v);
-			System.out.println("getDriverVersion(): " +
-							   met.getDriverVersion());
-			System.out.println("usesLocalFiles(): " +
-							   met.usesLocalFiles());
-			System.out.println("usesLocalFilePerTable(): " +
-							   met.usesLocalFilePerTable());
-			System.out.println("supportsMixedCaseIdentifiers(): " +
-							   met.supportsMixedCaseIdentifiers());
-			System.out.println("storesUpperCaseIdentifiers(): " +
-							   met.storesUpperCaseIdentifiers());
-			System.out.println("storesLowerCaseIdentifiers(): " +
-							   met.storesLowerCaseIdentifiers());
-			System.out.println("storesMixedCaseIdentifiers(): " +
-							   met.storesMixedCaseIdentifiers());
-			System.out.println("supportsMixedCaseQuotedIdentifiers(): " +
-							   met.supportsMixedCaseQuotedIdentifiers());
-			System.out.println("storesUpperCaseQuotedIdentifiers(): " +
-							   met.storesUpperCaseQuotedIdentifiers());
-			System.out.println("storesLowerCaseQuotedIdentifiers(): " +
-							   met.storesLowerCaseQuotedIdentifiers());
-			System.out.println("storesMixedCaseQuotedIdentifiers(): " +
-							   met.storesMixedCaseQuotedIdentifiers());
-			System.out.println("getIdentifierQuoteString(): " +
-							   met.getIdentifierQuoteString());
-			System.out.println("getNumericFunctions(): " +
-							   met.getNumericFunctions());
-			System.out.println("getStringFunctions(): " +
-							   met.getStringFunctions());
-			System.out.println("getSystemFunctions(): " +
-							   met.getSystemFunctions());
-			System.out.println("getTimeDateFunctions(): " +
-							   met.getTimeDateFunctions());
-			System.out.println("getExtraNameCharacters(): " +
-							   met.getExtraNameCharacters());
-			System.out.println("supportsAlterTableWithAddColumn(): " +
-							   met.supportsAlterTableWithAddColumn());
-			System.out.println("supportsAlterTableWithDropColumn(): " +
-							   met.supportsAlterTableWithDropColumn());
-			System.out.println("supportsColumnAliasing(): " +
-							   met.supportsColumnAliasing());
-			System.out.println("nullPlusNonNullIsNull(): " +
-							   met.nullPlusNonNullIsNull());
-			System.out.println("supportsConvert(): " +
-							   met.supportsConvert());
-			System.out.println("supportsConvert(Types.INTEGER, Types.SMALLINT): " +
-							   met.supportsConvert(Types.INTEGER, Types.SMALLINT));
-			System.out.println("supportsTableCorrelationNames(): " +
-							   met.supportsTableCorrelationNames());
-			System.out.println("supportsDifferentTableCorrelationNames(): " +
-							   met.supportsDifferentTableCorrelationNames());
-			System.out.println("supportsExpressionsInOrderBy(): " +
-							   met.supportsExpressionsInOrderBy());
-			System.out.println("supportsOrderByUnrelated(): " +
-							   met.supportsOrderByUnrelated());
-			System.out.println("supportsGroupBy(): " +
-							   met.supportsGroupBy());
-			System.out.println("supportsGroupByUnrelated(): " +
-							   met.supportsGroupByUnrelated());
-			System.out.println("supportsGroupByBeyondSelect(): " +
-							   met.supportsGroupByBeyondSelect());
-			System.out.println("supportsLikeEscapeClause(): " +
-							   met.supportsLikeEscapeClause());
-			System.out.println("supportsMultipleResultSets(): " +
-							   met.supportsMultipleResultSets());
-			System.out.println("supportsMultipleTransactions(): " +
-							   met.supportsMultipleTransactions());
-			System.out.println("supportsNonNullableColumns(): " +
-							   met.supportsNonNullableColumns());
-			System.out.println("supportsMinimumSQLGrammar(): " +
-							   met.supportsMinimumSQLGrammar());
-			System.out.println("supportsCoreSQLGrammar(): " +
-							   met.supportsCoreSQLGrammar());
-			System.out.println("supportsExtendedSQLGrammar(): " +
-							   met.supportsExtendedSQLGrammar());
-			System.out.println("supportsANSI92EntryLevelSQL(): " +
-							   met.supportsANSI92EntryLevelSQL());
-			System.out.println("supportsANSI92IntermediateSQL(): " +
-							   met.supportsANSI92IntermediateSQL());
-			System.out.println("supportsANSI92FullSQL(): " +
-							   met.supportsANSI92FullSQL());
-			System.out.println("supportsIntegrityEnhancementFacility(): " +
-							   met.supportsIntegrityEnhancementFacility());
-			System.out.println("supportsOuterJoins(): " +
-							   met.supportsOuterJoins());
-			System.out.println("supportsFullOuterJoins(): " +
-							   met.supportsFullOuterJoins());
-			System.out.println("supportsLimitedOuterJoins(): " +
-							   met.supportsLimitedOuterJoins());
-			System.out.println("getSchemaTerm(): " +
-							   met.getSchemaTerm());
-			System.out.println("getProcedureTerm(): " +
-							   met.getProcedureTerm());
-			System.out.println("getCatalogTerm(): " +
-							   met.getCatalogTerm());
-			System.out.println("isCatalogAtStart(): " +
-							   met.isCatalogAtStart());
-			System.out.println("getCatalogSeparator(): " +
-							   met.getCatalogSeparator());
-			System.out.println("supportsSchemasInDataManipulation(): " +
-							   met.supportsSchemasInDataManipulation());
-			System.out.println("supportsSchemasInProcedureCalls(): " +
-							   met.supportsSchemasInProcedureCalls());
-			System.out.println("supportsSchemasInTableDefinitions(): " +
-							   met.supportsSchemasInTableDefinitions());
-			System.out.println("supportsSchemasInIndexDefinitions(): " +
-							   met.supportsSchemasInIndexDefinitions());
-			System.out.println("supportsSchemasInPrivilegeDefinitions(): " +
-							   met.supportsSchemasInPrivilegeDefinitions());
-			System.out.println("supportsCatalogsInDataManipulation(): " +
-							   met.supportsCatalogsInDataManipulation());
-			System.out.println("supportsCatalogsInProcedureCalls(): " +
-							   met.supportsCatalogsInProcedureCalls());
-			System.out.println("supportsCatalogsInTableDefinitions(): " +
-							   met.supportsCatalogsInTableDefinitions());
-			System.out.println("supportsCatalogsInIndexDefinitions(): " +
-							   met.supportsCatalogsInIndexDefinitions());
-			System.out.println("supportsCatalogsInPrivilegeDefinitions(): " +
-							   met.supportsCatalogsInPrivilegeDefinitions());
-			System.out.println("supportsPositionedDelete(): " +
-							   met.supportsPositionedDelete());
-			System.out.println("supportsPositionedUpdate(): " +
-							   met.supportsPositionedUpdate());
-			System.out.println("supportsSelectForUpdate(): " +
-							   met.supportsSelectForUpdate());
-			System.out.println("supportsStoredProcedures(): " +
-							   met.supportsStoredProcedures());
-			System.out.println("supportsSubqueriesInComparisons(): " +
-							   met.supportsSubqueriesInComparisons());
-			System.out.println("supportsSubqueriesInExists(): " +
-							   met.supportsSubqueriesInExists());
-			System.out.println("supportsSubqueriesInIns(): " +
-							   met.supportsSubqueriesInIns());
-			System.out.println("supportsSubqueriesInQuantifieds(): " +
-							   met.supportsSubqueriesInQuantifieds());
-			System.out.println("supportsCorrelatedSubqueries(): " +
-							   met.supportsCorrelatedSubqueries());
-			System.out.println("supportsUnion(): " +
-							   met.supportsUnion());
-			System.out.println("supportsUnionAll(): " +
-							   met.supportsUnionAll());
-			System.out.println("supportsOpenCursorsAcrossCommit(): " +
-							   met.supportsOpenCursorsAcrossCommit());
-			System.out.println("supportsOpenCursorsAcrossRollback(): " +
-							   met.supportsOpenCursorsAcrossRollback());
-			System.out.println("supportsOpenStatementsAcrossCommit(): " +
-							   met.supportsOpenStatementsAcrossCommit());
-			System.out.println("supportsOpenStatementsAcrossRollback(): " +
-							   met.supportsOpenStatementsAcrossRollback());
-			System.out.println("getMaxBinaryLiteralLength(): " +
-							   met.getMaxBinaryLiteralLength());
-			System.out.println("getMaxCharLiteralLength(): " +
-							   met.getMaxCharLiteralLength());
-			System.out.println("getMaxColumnsInGroupBy(): " +
-							   met.getMaxColumnsInGroupBy());
-			System.out.println("getMaxColumnsInIndex(): " +
-							   met.getMaxColumnsInIndex());
-			System.out.println("getMaxColumnsInOrderBy(): " +
-							   met.getMaxColumnsInOrderBy());
-			System.out.println("getMaxColumnsInSelect(): " +
-							   met.getMaxColumnsInSelect());
-			System.out.println("getMaxColumnsInTable(): " +
-							   met.getMaxColumnsInTable());
-			System.out.println("getMaxConnections(): " +
-							   met.getMaxConnections());
-			System.out.println("getMaxCursorNameLength(): " +
-							   met.getMaxCursorNameLength());
-			System.out.println("getMaxIndexLength(): " +
-							   met.getMaxIndexLength());
-			System.out.println("getMaxSchemaNameLength(): " +
-							   met.getMaxSchemaNameLength());
-			System.out.println("getMaxProcedureNameLength(): " +
-							   met.getMaxProcedureNameLength());
-			System.out.println("getMaxCatalogNameLength(): " +
-							   met.getMaxCatalogNameLength());
-			System.out.println("getMaxRowSize(): " +
-							   met.getMaxRowSize());
-			System.out.println("doesMaxRowSizeIncludeBlobs(): " +
-							   met.doesMaxRowSizeIncludeBlobs());
-			System.out.println("getMaxStatementLength(): " +
-							   met.getMaxStatementLength());
-			System.out.println("getMaxStatements(): " +
-							   met.getMaxStatements());
-			System.out.println("getMaxTableNameLength(): " +
-							   met.getMaxTableNameLength());
-			System.out.println("getMaxTablesInSelect(): " +
-							   met.getMaxTablesInSelect());
-			System.out.println("getMaxUserNameLength(): " +
-							   met.getMaxUserNameLength());
-			System.out.println("supportsTransactions(): " +
-							   met.supportsTransactions());
 			System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE): " +
 							   met.supportsTransactionIsolationLevel(Connection.TRANSACTION_NONE));
-			System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ): " +
-							   met.supportsTransactionIsolationLevel(Connection.TRANSACTION_REPEATABLE_READ));
-			System.out.println("supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE): " +
-							   met.supportsTransactionIsolationLevel(Connection.TRANSACTION_SERIALIZABLE));
-			System.out.println("supportsDataDefinitionAndDataManipulationTransactions(): " +
-							   met.supportsDataDefinitionAndDataManipulationTransactions());
-			System.out.println("supportsDataManipulationTransactionsOnly(): " +
-							   met.supportsDataManipulationTransactionsOnly());
-			System.out.println("dataDefinitionCausesTransactionCommit(): " +
-							   met.dataDefinitionCausesTransactionCommit());
-			System.out.println("dataDefinitionIgnoredInTransactions(): " +
-							   met.dataDefinitionIgnoredInTransactions());
 
 			System.out.println("Test the metadata calls related to visibility of changes made by others for different resultset types");
 			System.out.println("Since Derby materializes a forward only ResultSet incrementally, it is possible to see changes");
@@ -824,37 +481,11 @@
 				}
 			}
 
-			System.out.println("getConnection(): "+
-					   ((met.getConnection()==con)?"same connection":"different connection") );
 			System.out.println("getProcedureColumns():");
 			dumpRS(GET_PROCEDURE_COLUMNS, getMetaDataRS(met, GET_PROCEDURE_COLUMNS,
 				new String [] {null, "%", "GETPCTEST%", "%"},
 				null, null, null));
 
- 			System.out.println("getTables() with TABLE_TYPE in ('SYSTEM TABLE') :");
- 			String[] tabTypes = new String[1];
- 			tabTypes[0] = "SYSTEM TABLE";
- 			dumpRS(GET_TABLES, getMetaDataRS(met, GET_TABLES,
-				new String [] {null, null, null},
- 				tabTypes, null, null));
-
-			System.out.println("getTables() with no types:");
- 			dumpRS(GET_TABLES, getMetaDataRS(met, GET_TABLES,
-				new String [] {"", null, "%"},
-				null, null, null));
-
- 			System.out.println("getTables() with TABLE_TYPE in ('VIEW','TABLE') :");
- 			tabTypes = new String[2];
- 			tabTypes[0] = "VIEW";
- 			tabTypes[1] = "TABLE";
- 			dumpRS(GET_TABLES, getMetaDataRS(met, GET_TABLES,
-				new String [] {null, null, null},
- 				tabTypes, null, null));
-
-
-			System.out.println("getTableTypes():");
-			dumpRS(met.getTableTypes());
-
 			System.out.println("getColumns():");
 			dumpRS(GET_COLUMNS, getMetaDataRS(met, GET_COLUMNS,
 				new String [] {"", null, "", ""},
@@ -965,9 +596,6 @@
 				new String [] {"", "BADSCHEMA", "LOUIE", "", "APP", "REFTAB"},
 				null, null, null));
 
-			System.out.println("getTypeInfo():");
-			dumpRS(GET_TYPE_INFO, getMetaDataRS(met, GET_TYPE_INFO, null, null, null, null));
-
 			/* NOTE - we call getIndexInfo() only on system tables here
  			 * so that there will be no diffs due to generated names.
 			 */
@@ -1013,18 +641,6 @@
 			}
 			rs.close();
 			
-			System.out.println("Test escaped numeric functions - JDBC 3.0 C.1");
-			testEscapedFunctions(con, NUMERIC_FUNCTIONS, met.getNumericFunctions());
-			
-			System.out.println("Test escaped string functions - JDBC 3.0 C.2");
-			testEscapedFunctions(con, STRING_FUNCTIONS, met.getStringFunctions());
-
-			System.out.println("Test escaped date time functions - JDBC 3.0 C.3");
-			testEscapedFunctions(con, TIMEDATE_FUNCTIONS, met.getTimeDateFunctions());
-
-			System.out.println("Test escaped system functions - JDBC 3.0 C.4");
-			testEscapedFunctions(con, SYSTEM_FUNCTIONS, met.getSystemFunctions());
-
 			//
 			// Test referential actions on delete
 			//
@@ -1280,133 +896,7 @@
 		System.out.println("Test metadata finished");
     }
 
-	/**
-	 * Test escaped functions. Working from the list of escaped functions defined
-	 * by JDBC, compared to the list returned by the driver.
-	 * <OL>
-	 * <LI> See that all functions defined by the driver are in the spec list
-	 * and that they work.
-	 * <LI> See that only functions defined by the spec are in the driver's list.
-	 * <LI> See that any functions defined by the spec that work are in the driver's list.
-	 * </OL>
-	 * FAIL will be printed for any issues.
-	 * @param conn
-	 * @param specList
-	 * @param metaDataList
-	 * @throws SQLException
-	 */
-	private static void testEscapedFunctions(Connection conn, String[][] specList, String metaDataList)
-	throws SQLException
-	{
-		boolean[] seenFunction = new boolean[specList.length];
-		
-		System.out.println("TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST");
-		StringTokenizer st = new StringTokenizer(metaDataList, ",");
-		while (st.hasMoreTokens())
-		{
-			String function = st.nextToken();
-			
-			// find this function in the list
-			boolean isSpecFunction = false;
-			for (int f = 0; f < specList.length; f++)
-			{
-				String[] specDetails = specList[f];
-				if (function.equals(specDetails[0]))
-				{
-					// Matched spec.
-					if (seenFunction[f])
-						System.out.println("FAIL Function in list twice: " + function);
-					seenFunction[f] = true;
-					isSpecFunction = true;
-					
-					if (!executeEscaped(conn, specDetails))
-						System.out.println("FAIL Function failed to execute "+ function);
-					break;
-				}
-			}
-			
-			if (!isSpecFunction)
-			{
-				System.out.println("FAIL Non-JDBC spec function in list: " + function);
-			}
-		}
-		
-		// Now see if any speced functions are not in the metadata list
-		System.out.println("TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST");
-		for (int f = 0; f < specList.length; f++)
-		{
-			if (seenFunction[f])
-				continue;
-			String[] specDetails = specList[f];
-			if (executeEscaped(conn, specDetails))
-				System.out.println("FAIL function works but not declared in list: " + specDetails[0]);
-			
-		}
-	}
-	
-	private static boolean executeEscaped(Connection conn, String[] specDetails)
-	{
-		
-		String sql = "VALUES { fn " + specDetails[0] + "(";
-		
-		for (int p = 0; p < specDetails.length - 1; p++)
-		{
-			if (p != 0)
-				sql = sql + ", ";
-			
-			sql = sql + specDetails[p + 1];
-		}
-		
-		sql = sql + ") }";
-		
-		// Special processing for functions that return
-		// current date, time or timestamp. This is to
-		// ensure we don't have output that depends on
-		// the time the test is run.
-		if ("CURDATE".equals(specDetails[0]))
-			sql = "VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END";
-		else if ("CURTIME".equals(specDetails[0]))
-			sql = "VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END";
-		else if ("NOW".equals(specDetails[0]))
-			sql = "VALUES CASE WHEN { fn NOW()} = CURRENT_TIMESTAMP THEN 'OK' ELSE 'wrong' END";
-		
-		
-		System.out.print("Executing " + sql + " -- ");
-			
-		try {
-			PreparedStatement ps = conn.prepareStatement(sql);
-			ResultSet rs = ps.executeQuery();
-			
-			while (rs.next())
-			{
-				// truncate numbers to avoid multiple master files
-				// with double values.
-				String res = rs.getString(1);
-				
-				switch (rs.getMetaData().getColumnType(1))
-				{
-				case Types.DOUBLE:
-				case Types.REAL:
-				case Types.FLOAT:
-					if (res.length() > 4)
-						res = res.substring(0, 4);
-					break;
-				default:
-					break;
-				}
-				System.out.print("  = >" + res + "< ");
-			}
-			rs.close();
-			ps.close();
-			System.out.println(" << ");
-			return true;
-		} catch (SQLException e) {
-			System.out.println("");
-			showSQLExceptions(e);
-			return false;
-		}
-		
-	}
+
 
     /**
      * Run tests for <code>getSchemas()</code> with two



Mime
View raw message