You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by dj...@apache.org on 2007/01/22 23:51:48 UTC
svn commit: r498840 [2/3] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/ master/DerbyNetClient/ tests/jdbcapi/
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_3.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_3.out?view=diff&rev=498840&r1=498839&r2=498840
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_3.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Upgrade_10_1_10_3.out Mon Jan 22 14:51:46 2007
@@ -28,29 +28,7 @@
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
dc / 2 = 5.55500000000000000000000
-DatabaseMetaData.getURL test passed
-allTablesAreSelectable(): true
-maxColumnNameLength(): 128
-getSchemas():
-TABLE_SCHEM[VARCHAR]
-APP
-D438
-NULLID
-SQLJ
-SYS
-SYSCAT
-SYSCS_DIAG
-SYSCS_UTIL
-SYSFUN
-SYSIBM
-SYSPROC
-SYSSTAT
DatabaseMetaData.getSchemas(String, String) is not available.
-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
@@ -71,115 +49,7 @@
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]
DatabaseMetaData.getClientInfoProperties() is not available.
-allProceduresAreCallable(): true
-getUserName(): APP
-isReadOnly(): false
-nullsAreSortedHigh(): true
-nullsAreSortedLow(): false
-nullsAreSortedAtStart(): false
-nullsAreSortedAtEnd(): false
-getDatabaseProductName(): Apache Derby
-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.
@@ -223,7 +93,6 @@
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
@@ -245,79 +114,6 @@
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,CASE606,TABLE,
-,APP,CT1,TABLE,
-,APP,GR_TAB,TABLE,
-,APP,INFLIGHT,TABLE,
-,APP,LOUIE,TABLE,
-,APP,PHASE,TABLE,
-,APP,REFTAB,TABLE,
-,APP,REFTAB2,TABLE,
-,APP,T,TABLE,
-,APP,TABLE1,TABLE,
-,D438,T438,TABLE,
-,D438,T438_T1,TABLE,
-,D438,T438_T2,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,CASE606,TABLE,
-,APP,CT1,TABLE,
-,APP,GR_TAB,TABLE,
-,APP,INFLIGHT,TABLE,
-,APP,LOUIE,TABLE,
-,APP,PHASE,TABLE,
-,APP,REFTAB,TABLE,
-,APP,REFTAB2,TABLE,
-,APP,T,TABLE,
-,APP,TABLE1,TABLE,
-,D438,T438,TABLE,
-,D438,T438_T1,TABLE,
-,D438,T438_T2,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'):
@@ -462,30 +258,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],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
@@ -507,143 +279,6 @@
,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(0.0707) } --
-SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13.
-Executing VALUES { fn ASIN(0.997) } --
-SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13.
-Executing VALUES { fn ATAN(14.10) } --
-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 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } -- = >xxxxxxFILTERED-TIMESTAMPxxxxx< <<
-FAIL function works but not declared in list: TIMESTAMPADD
-Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } -- = >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
@@ -743,23 +378,6 @@
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
dc / 2 = 5.55500000000000000000000
-DatabaseMetaData.getURL test passed
-allTablesAreSelectable(): true
-maxColumnNameLength(): 128
-getSchemas():
-TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
-APP,null
-D438,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
@@ -786,11 +404,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
@@ -872,115 +485,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
-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.
@@ -1024,7 +529,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
@@ -1046,80 +550,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,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,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,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,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,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,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,CASE606,TABLE,,null,null,null,null,null
-,APP,CT1,TABLE,,null,null,null,null,null
-,APP,GR_TAB,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,PHASE,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,TABLE1,TABLE,,null,null,null,null,null
-,D438,T438,TABLE,,null,null,null,null,null
-,D438,T438_T1,TABLE,,null,null,null,null,null
-,D438,T438_T2,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,CASE606,TABLE,,null,null,null,null,null
-,APP,CT1,TABLE,,null,null,null,null,null
-,APP,GR_TAB,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,PHASE,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,TABLE1,TABLE,,null,null,null,null,null
-,D438,T438,TABLE,,null,null,null,null,null
-,D438,T438_T1,TABLE,,null,null,null,null,null
-,D438,T438_T2,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'):
@@ -1264,30 +694,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
@@ -1309,102 +715,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
@@ -1500,29 +810,7 @@
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
dc / 2 = 5.55500000000000000000000
-DatabaseMetaData.getURL test passed
-allTablesAreSelectable(): true
-maxColumnNameLength(): 128
-getSchemas():
-TABLE_SCHEM[VARCHAR]
-APP
-D438
-NULLID
-SQLJ
-SYS
-SYSCAT
-SYSCS_DIAG
-SYSCS_UTIL
-SYSFUN
-SYSIBM
-SYSPROC
-SYSSTAT
DatabaseMetaData.getSchemas(String, String) is not available.
-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
@@ -1543,115 +831,7 @@
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]
DatabaseMetaData.getClientInfoProperties() is not available.
-allProceduresAreCallable(): true
-getUserName(): APP
-isReadOnly(): false
-nullsAreSortedHigh(): true
-nullsAreSortedLow(): false
-nullsAreSortedAtStart(): false
-nullsAreSortedAtEnd(): false
-getDatabaseProductName(): Apache Derby
-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.
@@ -1695,7 +875,6 @@
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
@@ -1717,79 +896,6 @@
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,CASE606,TABLE,
-,APP,CT1,TABLE,
-,APP,GR_TAB,TABLE,
-,APP,INFLIGHT,TABLE,
-,APP,LOUIE,TABLE,
-,APP,PHASE,TABLE,
-,APP,REFTAB,TABLE,
-,APP,REFTAB2,TABLE,
-,APP,T,TABLE,
-,APP,TABLE1,TABLE,
-,D438,T438,TABLE,
-,D438,T438_T1,TABLE,
-,D438,T438_T2,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,CASE606,TABLE,
-,APP,CT1,TABLE,
-,APP,GR_TAB,TABLE,
-,APP,INFLIGHT,TABLE,
-,APP,LOUIE,TABLE,
-,APP,PHASE,TABLE,
-,APP,REFTAB,TABLE,
-,APP,REFTAB2,TABLE,
-,APP,T,TABLE,
-,APP,TABLE1,TABLE,
-,D438,T438,TABLE,
-,D438,T438_T1,TABLE,
-,D438,T438_T2,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'):
@@ -1934,30 +1040,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],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
@@ -1979,143 +1061,6 @@
,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(0.0707) } --
-SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13.
-Executing VALUES { fn ASIN(0.997) } --
-SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13.
-Executing VALUES { fn ATAN(14.10) } --
-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 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } -- = >xxxxxxFILTERED-TIMESTAMPxxxxx< <<
-FAIL function works but not declared in list: TIMESTAMPADD
-Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } -- = >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
@@ -2236,23 +1181,6 @@
Column result scale after division is: 23
dc / 2 = 5.55000000000000000000000
dc / 2 = 5.55500000000000000000000
-DatabaseMetaData.getURL test passed
-allTablesAreSelectable(): true
-maxColumnNameLength(): 128
-getSchemas():
-TABLE_SCHEM[VARCHAR],TABLE_CATALOG[VARCHAR]
-APP,null
-D438,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
@@ -2279,11 +1207,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
@@ -2365,115 +1288,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
-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.
@@ -2517,7 +1332,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
@@ -2539,86 +1353,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,CASE606,TABLE,,null,null,null,null,null
-,APP,CT1,TABLE,,null,null,null,null,null
-,APP,GR_TAB,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,PHASE,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,TABLE1,TABLE,,null,null,null,null,null
-,D438,T438,TABLE,,null,null,null,null,null
-,D438,T438_T1,TABLE,,null,null,null,null,null
-,D438,T438_T2,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,CASE606,TABLE,,null,null,null,null,null
-,APP,CT1,TABLE,,null,null,null,null,null
-,APP,GR_TAB,TABLE,,null,null,null,null,null
-,APP,INFLIGHT,TABLE,,null,null,null,null,null
-,APP,LOUIE,TABLE,,null,null,null,null,null
-,APP,PHASE,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,TABLE1,TABLE,,null,null,null,null,null
-,D438,T438,TABLE,,null,null,null,null,null
-,D438,T438_T1,TABLE,,null,null,null,null,null
-,D438,T438_T2,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'):
@@ -2763,30 +1497,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
@@ -2808,102 +1518,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