You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2006/01/25 17:54:11 UTC
[jira] Closed: (DERBY-829) jdbcapi/metadata.java and
lang/syscat.sql fail on jdk 1.5 with DerbyNet and DerbyNetClient frameworks
[ http://issues.apache.org/jira/browse/DERBY-829?page=all ]
Kathey Marsden closed DERBY-829:
--------------------------------
fixed
> jdbcapi/metadata.java and lang/syscat.sql fail on jdk 1.5 with DerbyNet and DerbyNetClient frameworks
> -----------------------------------------------------------------------------------------------------
>
> Key: DERBY-829
> URL: http://issues.apache.org/jira/browse/DERBY-829
> Project: Derby
> Type: Test
> Components: Test
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Andrew McIntyre
> Priority: Critical
> Fix For: 10.2.0.0
>
> As of build 370210 these tests are failing on Sun jdk 1.5:
> See: http://www.multinet.no/~solberg/public/Apache/Derby/Limited/testSummary-370210.html
> Andrew McIntyre posted that it was related to this check in. He said jdk 1.5 was not picking up the right master.
> He is working on it.
> r369956 | fuzzylogic | 2006-01-18 00:19:09 +0100 (Wed, 18 Jan 2006) | 4 lines
> DERBY-499: Fix metadata.java and syscat.sql in jdk131 vms.
> Committed for Rick Hillegas <ri...@sun.com>
> ------------------------------------------------------------------------
> derbynetclientmats fail *************************************************************
> derbynetclientmats/derbynetmats/derbynetmats.fail:jdbcapi/metadata.java
> derbynetclientmats/derbynetmats/derbynetmats.fail:lang/syscat.sql
> derbynetclientmats diff -------------------------------------------------------------
> ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/metadata.diff
> *** Start: metadata jdk1.5.0_04 DerbyNetClient derbynetmats:derbynetmats 2006-01-19 04:49:13 ***
> 410 del
> < TYPE_NAME[VARCHAR],DATA_TYPE[SMALLINT],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[INTEGER],CASE_SENSITIVE[SMALLINT],SEARCHABLE[INTEGER],UNSIGNED_ATTRIBUTE[SMALLINT],FIXED_PREC_SCALE[SMALLINT],AUTO_INCREMENT[SMALLINT],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[INTEGER],MAXIMUM_SCALE[INTEGER],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],NUM_PREC_RADIX[INTEGER]
> 411 del
> < BIGINT,-5,19,null,null,null,1,0,2,0,0,1,BIGINT,0,0,null,null,10
> 412 del
> < LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,0,2,1,0,0,LONG VARCHAR FOR BIT DATA,null,null,null,null,null
> 413 del
> < VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,0,2,1,0,0,VARCHAR () FOR BIT DATA,null,null,null,null,null
> 414 del
> < CHAR () FOR BIT DATA,-2,254,X',',length,1,0,2,1,0,0,CHAR () FOR BIT DATA,null,null,null,null,null
> 415 del
> < LONG VARCHAR,-1,32700,',',null,1,1,3,1,0,0,LONG VARCHAR,null,null,null,null,null
> 416 del
> < LONG NVARCHAR,-1,32700,',',null,1,1,3,1,0,0,LONG NVARCHAR,null,null,null,null,null
> 417 del
> < CHAR,1,254,',',length,1,1,3,1,0,0,CHAR,null,null,null,null,null
> 418 del
> < NATIONAL CHAR,1,2147483647,',',length,1,1,3,1,0,0,NATIONAL CHAR,null,null,null,null,null
> 419 del
> < NUMERIC,2,31,null,null,precision,scale,1,0,2,0,1,0,NUMERIC,0,32767,null,null,10
> 420 del
> < DECIMAL,3,31,null,null,precision,scale,1,0,2,0,1,0,DECIMAL,0,32767,null,null,10
> 421 del
> < INTEGER,4,10,null,null,null,1,0,2,0,0,1,INTEGER,0,0,null,null,10
> 422 del
> < SMALLINT,5,5,null,null,null,1,0,2,0,0,1,SMALLINT,0,0,null,null,10
> 423 del
> < FLOAT,6,52,null,null,precision,1,0,2,0,0,0,FLOAT,null,null,null,null,2
> 424 del
> < REAL,7,23,null,null,null,1,0,2,0,0,0,REAL,null,null,null,null,2
> 425 del
> < DOUBLE,8,52,null,null,null,1,0,2,0,0,0,DOUBLE,null,null,null,null,2
> 426 del
> < VARCHAR,12,32672,',',length,1,1,3,1,0,0,VARCHAR,null,null,null,null,null
> 427 del
> < NATIONAL CHAR VARYING,12,2147483647,',',length,1,1,3,1,0,0,NATIONAL CHAR VARYING,null,null,null,null,null
> 428 del
> < DATE,91,10,DATE',',null,1,0,2,1,0,0,DATE,0,0,null,null,10
> 429 del
> < TIME,92,8,TIME',',null,1,0,2,1,0,0,TIME,0,0,null,null,10
> 430 del
> < TIMESTAMP,93,26,TIMESTAMP',',null,1,0,2,1,0,0,TIMESTAMP,0,6,null,null,10
> 431 del
> < BLOB,2004,2147483647,null,null,length,1,0,1,null,0,null,BLOB,null,null,null,null,null
> 432 del
> < CLOB,2005,2147483647,',',length,1,1,1,null,0,null,CLOB,null,null,null,null,null
> 433 del
> < getIndexInfo():
> 434 del
> < TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMALLINT],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]
> 435 del
> < ,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null
> 436 del
> < ,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null
> 437 del
> < getIndexInfo():
> 438 del
> < TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMALLINT],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]
> 439 del
> < ,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null
> 440 del
> < ,SYS,SYSCOLUMNS,0,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null
> 441 del
> < ,SYS,SYSCOLUMNS,1,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null
> 442 del
> < getIndexInfo():
> 443 del
> < TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[SMALLINT],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]
> 444 del
> < ,SYS,SYSTABLES,0,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null
> 445 del
> < ,SYS,SYSTABLES,0,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null
> 446 del
> < ,SYS,SYSTABLES,0,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null
> 447 del
> < getColumns('SYSTABLES'):
> 448 del
> < 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]
> 449 del
> < ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO
> 450 del
> < ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO
> 451 del
> < ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO
> 452 del
> < ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO
> 453 del
> < ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO
> 454 del
> < Test escaped numeric functions - JDBC 3.0 C.1
> 455 del
> < TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> 456 del
> < Executing VALUES { fn ABS(-25.67) } -- = >25.67< <<
> 457 del
> < Executing VALUES { fn MOD(124, 7) } -- = >5< <<
> 458 del
> < Executing VALUES { fn SQRT(6.22) } -- = >2.49< <<
> 459 del
> < TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
> 460 del
> < Executing VALUES { fn ACOS(1.34) } --
> 461 del
> < SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13.
> 462 del
> < Executing VALUES { fn ASIN(1.21) } --
> 463 del
> < SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13.
> 464 del
> < Executing VALUES { fn ATAN(0.34) } --
> 465 del
> < SQLSTATE(42X01): Syntax error: Encountered "ATAN" at line 1, column 13.
> 466 del
> < Executing VALUES { fn ATAN2(0.56, 1.2) } --
> 467 del
> < SQLSTATE(42X01): Syntax error: Encountered "ATAN2" at line 1, column 13.
> 468 del
> < Executing VALUES { fn CEILING(3.45) } --
> 469 del
> < SQLSTATE(42X01): Syntax error: Encountered "CEILING" at line 1, column 13.
> 470 del
> < Executing VALUES { fn COS(1.2) } --
> 471 del
> < SQLSTATE(42X01): Syntax error: Encountered "COS" at line 1, column 13.
> 472 del
> < Executing VALUES { fn COT(3.4) } --
> 473 del
> < SQLSTATE(42X01): Syntax error: Encountered "COT" at line 1, column 13.
> 474 del
> < Executing VALUES { fn DEGREES(2.1) } --
> 475 del
> < SQLSTATE(42X01): Syntax error: Encountered "DEGREES" at line 1, column 13.
> 476 del
> < Executing VALUES { fn EXP(2.3) } --
> 477 del
> < SQLSTATE(42X01): Syntax error: Encountered "EXP" at line 1, column 13.
> 478 del
> < Executing VALUES { fn FLOOR(3.22) } --
> 479 del
> < SQLSTATE(42X01): Syntax error: Encountered "FLOOR" at line 1, column 13.
> 480 del
> < Executing VALUES { fn LOG(34.1) } --
> 481 del
> < SQLSTATE(42X01): Syntax error: Encountered "LOG" at line 1, column 13.
> 482 del
> < Executing VALUES { fn LOG10(18.7) } --
> 483 del
> < SQLSTATE(42X01): Syntax error: Encountered "LOG10" at line 1, column 13.
> 484 del
> < Executing VALUES { fn PI() } --
> 485 del
> < SQLSTATE(42X01): Syntax error: Encountered "PI" at line 1, column 13.
> 486 del
> < Executing VALUES { fn POWER(2, 3) } --
> 487 del
> < SQLSTATE(42X01): Syntax error: Encountered "POWER" at line 1, column 13.
> 488 del
> < Executing VALUES { fn RADIANS(54) } --
> 489 del
> < SQLSTATE(42X01): Syntax error: Encountered "RADIANS" at line 1, column 13.
> 490 del
> < Executing VALUES { fn RAND(17) } --
> 491 del
> < SQLSTATE(42X01): Syntax error: Encountered "RAND" at line 1, column 13.
> 492 del
> < Executing VALUES { fn ROUND(345.345, 1) } --
> 493 del
> < SQLSTATE(42X01): Syntax error: Encountered "ROUND" at line 1, column 13.
> 494 del
> < Executing VALUES { fn SIGN(-34) } --
> 495 del
> < SQLSTATE(42X01): Syntax error: Encountered "SIGN" at line 1, column 13.
> 496 del
> < Executing VALUES { fn SIN(0.32) } --
> 497 del
> < SQLSTATE(42X01): Syntax error: Encountered "SIN" at line 1, column 13.
> 498 del
> < Executing VALUES { fn TAN(0.57) } --
> 499 del
> < SQLSTATE(42X01): Syntax error: Encountered "TAN" at line 1, column 13.
> 500 del
> < Executing VALUES { fn TRUNCATE(345.395, 1) } --
> 501 del
> < SQLSTATE(42X01): Syntax error: Encountered "TRUNCATE" at line 1, column 13.
> 502 del
> < Test escaped string functions - JDBC 3.0 C.2
> 503 del
> < TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> 504 del
> < Executing VALUES { fn CONCAT('hello', 'there') } -- = >hellothere< <<
> 505 del
> < Executing VALUES { fn LENGTH('four ') } -- = >4< <<
> 506 del
> < Executing VALUES { fn LCASE('Fernando Alonso') } -- = >fernando alonso< <<
> 507 del
> < Executing VALUES { fn LOCATE('jour', 'Bonjour') } -- = >4< <<
> 508 del
> < Executing VALUES { fn LTRIM(' left trim ') } -- = >left trim < <<
> 509 del
> < Executing VALUES { fn RTRIM(' right trim ') } -- = > right trim< <<
> 510 del
> < Executing VALUES { fn SUBSTRING('Ruby the Rubicon Jeep', 10, 7) } -- = >Rubicon< <<
> 511 del
> < Executing VALUES { fn UCASE('Fernando Alonso') } -- = >FERNANDO ALONSO< <<
> 512 del
> < TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
> 513 del
> < Executing VALUES { fn ASCII('Yellow') } --
> 514 del
> < SQLSTATE(42X01): Syntax error: Encountered "ASCII" at line 1, column 13.
> 515 del
> < Executing VALUES { fn CHAR(65) } -- = >65 < <<
> 516 del
> < FAIL function works but not declared in list: CHAR
> 517 del
> < Executing VALUES { fn DIFFERENCE('Pires', 'Piers') } --
> 518 del
> < SQLSTATE(42X01): Syntax error: Encountered "DIFFERENCE" at line 1, column 13.
> 519 del
> < Executing VALUES { fn INSERT('Bill Clinton', 4, 'William') } --
> 520 del
> < SQLSTATE(42X01): Syntax error: Encountered "INSERT" at line 1, column 13.
> 521 del
> < Executing VALUES { fn LEFT('Bonjour', 3) } --
> 522 del
> < SQLSTATE(42X01): Syntax error: Encountered "LEFT" at line 1, column 13.
> 523 del
> < Executing VALUES { fn REPEAT('echo', 3) } --
> 524 del
> < SQLSTATE(42X01): Syntax error: Encountered "REPEAT" at line 1, column 13.
> 525 del
> < Executing VALUES { fn REPLACE('to be or not to be', 'be', 'England') } --
> 526 del
> < SQLSTATE(42X01): Syntax error: Encountered "REPLACE" at line 1, column 13.
> 527 del
> < Executing VALUES { fn SOUNDEX('Derby') } --
> 528 del
> < SQLSTATE(42X01): Syntax error: Encountered "SOUNDEX" at line 1, column 13.
> 529 del
> < Executing VALUES { fn SPACE(12) } --
> 530 del
> < SQLSTATE(42X01): Syntax error: Encountered "SPACE" at line 1, column 13.
> 531 del
> < Test escaped date time functions - JDBC 3.0 C.3
> 532 del
> < TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> 533 del
> < Executing VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END -- = >OK< <<
> 534 del
> < Executing VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END -- = >OK< <<
> 535 del
> < Executing VALUES { fn HOUR({t '16:13:03'}) } -- = >16< <<
> 536 del
> < Executing VALUES { fn MINUTE({t '16:13:03'}) } -- = >13< <<
> 537 del
> < Executing VALUES { fn MONTH({d '1995-12-19'}) } -- = >12< <<
> 538 del
> < Executing VALUES { fn SECOND({t '16:13:03'}) } -- = >3< <<
> 539 del
> < Executing VALUES { fn TIMESTAMPADD(SQL_TSI_DAY, 7, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } -- = >xxxxxxFILTERED-TIMESTAMPxxxxx< <<
> 540 del
> < Executing VALUES { fn TIMESTAMPDIFF(SQL_TSI_DAY, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}, {ts 'xxxxxxFILTERED-TIMESTAMPxxxxx}) } -- = >683< <<
> 541 del
> < Executing VALUES { fn YEAR({d '1995-12-19'}) } -- = >1995< <<
> 542 del
> < TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
> 543 del
> < Executing VALUES { fn DAYNAME({d '1995-12-19'h}) } --
> 544 del
> < SQLSTATE(42X01): Syntax error: Encountered "DAYNAME" at line 1, column 13.
> 545 del
> < Executing VALUES { fn DAYOFMONTH({d '1995-12-19'}) } --
> 546 del
> < SQLSTATE(42X01): Syntax error: Encountered "DAYOFMONTH" at line 1, column 13.
> 547 del
> < Executing VALUES { fn DAYOFWEEK({d '1995-12-19'}) } --
> 548 del
> < SQLSTATE(42X01): Syntax error: Encountered "DAYOFWEEK" at line 1, column 13.
> 549 del
> < Executing VALUES { fn DAYOFYEAR({d '1995-12-19'}) } --
> 550 del
> < SQLSTATE(42X01): Syntax error: Encountered "DAYOFYEAR" at line 1, column 13.
> 551 del
> < Executing VALUES { fn MONTHNAME({d '1995-12-19'}) } --
> 552 del
> < SQLSTATE(42X01): Syntax error: Encountered "MONTHNAME" at line 1, column 13.
> 553 del
> < Executing VALUES CASE WHEN { fn NOW()} = CURRENT_TIMESTAMP THEN 'OK' ELSE 'wrong' END --
> 554 del
> < SQLSTATE(42X01): Syntax error: Encountered "NOW" at line 1, column 23.
> 555 del
> < Executing VALUES { fn QUARTER({d '1995-12-19'}) } --
> 556 del
> < SQLSTATE(42X01): Syntax error: Encountered "QUARTER" at line 1, column 13.
> 557 del
> < Executing VALUES { fn WEEK({d '1995-12-19'}) } --
> 558 del
> < SQLSTATE(42X01): Syntax error: Encountered "WEEK" at line 1, column 13.
> 559 del
> < Test escaped system functions - JDBC 3.0 C.4
> 560 del
> < TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> 561 del
> < Executing VALUES { fn USER() } -- = >APP< <<
> 562 del
> < TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
> 563 del
> < Executing VALUES { fn DATABASE() } --
> 564 del
> < SQLSTATE(42X01): Syntax error: Encountered "DATABASE" at line 1, column 13.
> 565 del
> < Executing VALUES { fn IFNULL('this', 'that') } --
> 566 del
> < SQLSTATE(42X01): Syntax error: Encountered "IFNULL" at line 1, column 13.
> 567 del
> < -----
> 568 del
> < Referential action values
> 569 del
> < RESTRICT = 1
> 570 del
> < NO ACTION = 3
> 571 del
> < CASCADE = 0
> 572 del
> < SETNULL = 2
> 573 del
> < SETDEFAULT = 4
> 574 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTIONNONE' ):
> 575 del
> < 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]
> 576 del
> < ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 577 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTRESTRICT' ):
> 578 del
> < 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]
> 579 del
> < ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 580 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTNOACTION' ):
> 581 del
> < 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]
> 582 del
> < ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 583 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTCASCADE' ):
> 584 del
> < 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]
> 585 del
> < ,APP,REFACTION1,A,,APP,REFACTCASCADE,A,1,3,0,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 586 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTSETNULL' ):
> 587 del
> < 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]
> 588 del
> < ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 589 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTUPDRESTRICT' ):
> 590 del
> < 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]
> 591 del
> < ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 592 del
> < getCrossReference('','APP','REFACTION1','','APP','REFACTUPDNOACTION' ):
> 593 del
> < 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]
> 594 del
> < ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 595 del
> < getImportedKeys - none update Passed
> 596 del
> < getImportedKeys - none delete Passed
> 597 del
> < getImportedKeys - delete Restrict Passed
> 598 del
> < getImportedKeys - delete NO ACTION Passed
> 599 del
> < getImportedKeys - delete CASCADE Passed
> 600 del
> < getImportedKeys - delete SET NULL Passed
> 601 del
> < getImportedKeys - update Restrict Passed
> 602 del
> < getImportedKeys - update NO ACTION Passed
> 603 del
> < getExportedKeys('',null,null,'','APP','REFACTION1' ):
> 604 del
> < 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]
> 605 del
> < ,APP,REFACTION1,A,,APP,REFACTCASCADE,A,1,3,0,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 606 del
> < ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 607 del
> < ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 608 del
> < ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 609 del
> < ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 610 del
> < ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 611 del
> < ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> 612 del
> < -----
> 613 del
> < getColumns for 'T1'
> 614 del
> < Next line is real null.
> 615 del
> < defval for col C1 type INTEGER DEFAULT 'null' wasnull true
> 616 del
> < Next line is real null.
> 617 del
> < defval for col C2 type INTEGER DEFAULT 'null' wasnull true
> 618 del
> < defval for col C3 type INTEGER DEFAULT 'NULL' wasnull false
> 619 del
> < Next line is real null.
> 620 del
> < defval for col C4 type CHAR DEFAULT 'null' wasnull true
> 621 del
> < defval for col C5 type CHAR DEFAULT 'NULL' wasnull false
> 622 del
> < defval for col C6 type CHAR DEFAULT ''NULL'' wasnull false
> 623 del
> < defval for col C7 type INTEGER DEFAULT '88' wasnull false
> 624 del
> < Test metadata finished
> 624 add
> > TYPE_NAME[VARCHAR],DATA_TYPE[SMALLINT],PRECISION[INTEGER],LITERAL_PREFIX[VARCHAR],LITERAL_SUFFIX[VARCHAR],CREATE_PARAMS[VARCHAR],NULLABLE[INTEGER],CASE_SENSITIVE[BOOLEAN],SEARCHABLE[INTEGER],UNSIGNED_ATTRIBUTE[BOOLEAN],FIXED_PREC_SCALE[BOOLEAN],AUTO_INCREMENT[BOOLEAN],LOCAL_TYPE_NAME[VARCHAR],MINIMUM_SCALE[INTEGER],MAXIMUM_SCALE[INTEGER],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],NUM_PREC_RADIX[INTEGER]
> > BIGINT,-5,19,null,null,null,1,false,2,false,false,true,BIGINT,0,0,null,null,10
> > LONG VARCHAR FOR BIT DATA,-4,32700,X',',null,1,false,2,true,false,false,LONG VARCHAR FOR BIT DATA,null,null,null,null,null
> > VARCHAR () FOR BIT DATA,-3,32762,X',',length,1,false,2,true,false,false,VARCHAR () FOR BIT DATA,null,null,null,null,null
> > CHAR () FOR BIT DATA,-2,254,X',',length,1,false,2,true,false,false,CHAR () FOR BIT DATA,null,null,null,null,null
> > LONG VARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG VARCHAR,null,null,null,null,null
> > LONG NVARCHAR,-1,32700,',',null,1,true,3,true,false,false,LONG NVARCHAR,null,null,null,null,null
> > CHAR,1,254,',',length,1,true,3,true,false,false,CHAR,null,null,null,null,null
> > NATIONAL CHAR,1,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR,null,null,null,null,null
> > NUMERIC,2,31,null,null,precision,scale,1,false,2,false,true,false,NUMERIC,0,32767,null,null,10
> > DECIMAL,3,31,null,null,precision,scale,1,false,2,false,true,false,DECIMAL,0,32767,null,null,10
> > INTEGER,4,10,null,null,null,1,false,2,false,false,true,INTEGER,0,0,null,null,10
> > SMALLINT,5,5,null,null,null,1,false,2,false,false,true,SMALLINT,0,0,null,null,10
> > FLOAT,6,52,null,null,precision,1,false,2,false,false,false,FLOAT,null,null,null,null,2
> > REAL,7,23,null,null,null,1,false,2,false,false,false,REAL,null,null,null,null,2
> > DOUBLE,8,52,null,null,null,1,false,2,false,false,false,DOUBLE,null,null,null,null,2
> > VARCHAR,12,32672,',',length,1,true,3,true,false,false,VARCHAR,null,null,null,null,null
> > NATIONAL CHAR VARYING,12,2147483647,',',length,1,true,3,true,false,false,NATIONAL CHAR VARYING,null,null,null,null,null
> > DATE,91,10,DATE',',null,1,false,2,true,false,false,DATE,0,0,null,null,10
> > TIME,92,8,TIME',',null,1,false,2,true,false,false,TIME,0,0,null,null,10
> > TIMESTAMP,93,26,TIMESTAMP',',null,1,false,2,true,false,false,TIMESTAMP,0,6,null,null,10
> > BLOB,2004,2147483647,null,null,length,1,false,1,null,false,null,BLOB,null,null,null,null,null
> > CLOB,2005,2147483647,',',length,1,true,1,null,false,null,CLOB,null,null,null,null,null
> > getIndexInfo():
> > TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR]
> > ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null
> > ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null
> > getIndexInfo():
> > TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR]
> > ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,1,REFERENCEID,A,null,null,null
> > ,SYS,SYSCOLUMNS,false,,SYSCOLUMNS_INDEX1,3,2,COLUMNNAME,A,null,null,null
> > ,SYS,SYSCOLUMNS,true,,SYSCOLUMNS_INDEX2,3,1,COLUMNDEFAULTID,A,null,null,null
> > getIndexInfo():
> > TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],NON_UNIQUE[BOOLEAN],INDEX_QUALIFIER[VARCHAR],INDEX_NAME[VARCHAR],TYPE[SMALLINT],ORDINAL_POSITION[INTEGER],COLUMN_NAME[VARCHAR],ASC_OR_DESC[CHAR],CARDINALITY[INTEGER],PAGES[INTEGER],FILTER_CONDITION[VARCHAR]
> > ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,1,TABLENAME,A,null,null,null
> > ,SYS,SYSTABLES,false,,SYSTABLES_INDEX1,3,2,SCHEMAID,A,null,null,null
> > ,SYS,SYSTABLES,false,,SYSTABLES_INDEX2,3,1,TABLEID,A,null,null,null
> > getColumns('SYSTABLES'):
> > TABLE_CAT[VARCHAR],TABLE_SCHEM[VARCHAR],TABLE_NAME[VARCHAR],COLUMN_NAME[VARCHAR],DATA_TYPE[SMALLINT],TYPE_NAME[VARCHAR],COLUMN_SIZE[INTEGER],BUFFER_LENGTH[INTEGER],DECIMAL_DIGITS[INTEGER],NUM_PREC_RADIX[INTEGER],NULLABLE[INTEGER],REMARKS[VARCHAR],COLUMN_DEF[VARCHAR],SQL_DATA_TYPE[INTEGER],SQL_DATETIME_SUB[INTEGER],CHAR_OCTET_LENGTH[INTEGER],ORDINAL_POSITION[INTEGER],IS_NULLABLE[VARCHAR]
> > ,SYS,SYSTABLES,TABLEID,1,CHAR,36,null,null,null,0,,null,null,null,72,1,NO
> > ,SYS,SYSTABLES,TABLENAME,12,VARCHAR,128,null,null,null,0,,null,null,null,256,2,NO
> > ,SYS,SYSTABLES,TABLETYPE,1,CHAR,1,null,null,null,0,,null,null,null,2,3,NO
> > ,SYS,SYSTABLES,SCHEMAID,1,CHAR,36,null,null,null,0,,null,null,null,72,4,NO
> > ,SYS,SYSTABLES,LOCKGRANULARITY,1,CHAR,1,null,null,null,0,,null,null,null,2,5,NO
> > Test escaped numeric functions - JDBC 3.0 C.1
> > TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> > Executing VALUES { fn ABS(-25.67) } -- = >25.67< <<
> > Executing VALUES { fn MOD(124, 7) } -- = >5< <<
> > Executing VALUES { fn SQRT(6.22) } -- = >2.49< <<
> > TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
> > Executing VALUES { fn ACOS(1.34) } --
> > SQLSTATE(42X01): Syntax error: Encountered "ACOS" at line 1, column 13.
> > Executing VALUES { fn ASIN(1.21) } --
> > SQLSTATE(42X01): Syntax error: Encountered "ASIN" at line 1, column 13.
> > Executing VALUES { fn ATAN(0.34) } --
> > SQLSTATE(42X01): Syntax error: Encountered "ATAN" at line 1, column 13.
> > Executing VALUES { fn ATAN2(0.56, 1.2) } --
> > SQLSTATE(42X01): Syntax error: Encountered "ATAN2" at line 1, column 13.
> > Executing VALUES { fn CEILING(3.45) } --
> > SQLSTATE(42X01): Syntax error: Encountered "CEILING" at line 1, column 13.
> > Executing VALUES { fn COS(1.2) } --
> > SQLSTATE(42X01): Syntax error: Encountered "COS" at line 1, column 13.
> > Executing VALUES { fn COT(3.4) } --
> > SQLSTATE(42X01): Syntax error: Encountered "COT" at line 1, column 13.
> > Executing VALUES { fn DEGREES(2.1) } --
> > SQLSTATE(42X01): Syntax error: Encountered "DEGREES" at line 1, column 13.
> > Executing VALUES { fn EXP(2.3) } --
> > SQLSTATE(42X01): Syntax error: Encountered "EXP" at line 1, column 13.
> > Executing VALUES { fn FLOOR(3.22) } --
> > SQLSTATE(42X01): Syntax error: Encountered "FLOOR" at line 1, column 13.
> > Executing VALUES { fn LOG(34.1) } --
> > SQLSTATE(42X01): Syntax error: Encountered "LOG" at line 1, column 13.
> > Executing VALUES { fn LOG10(18.7) } --
> > SQLSTATE(42X01): Syntax error: Encountered "LOG10" at line 1, column 13.
> > Executing VALUES { fn PI() } --
> > SQLSTATE(42X01): Syntax error: Encountered "PI" at line 1, column 13.
> > Executing VALUES { fn POWER(2, 3) } --
> > SQLSTATE(42X01): Syntax error: Encountered "POWER" at line 1, column 13.
> > Executing VALUES { fn RADIANS(54) } --
> > SQLSTATE(42X01): Syntax error: Encountered "RADIANS" at line 1, column 13.
> > Executing VALUES { fn RAND(17) } --
> > SQLSTATE(42X01): Syntax error: Encountered "RAND" at line 1, column 13.
> > Executing VALUES { fn ROUND(345.345, 1) } --
> > SQLSTATE(42X01): Syntax error: Encountered "ROUND" at line 1, column 13.
> > Executing VALUES { fn SIGN(-34) } --
> > SQLSTATE(42X01): Syntax error: Encountered "SIGN" at line 1, column 13.
> > Executing VALUES { fn SIN(0.32) } --
> > SQLSTATE(42X01): Syntax error: Encountered "SIN" at line 1, column 13.
> > Executing VALUES { fn TAN(0.57) } --
> > SQLSTATE(42X01): Syntax error: Encountered "TAN" at line 1, column 13.
> > Executing VALUES { fn TRUNCATE(345.395, 1) } --
> > SQLSTATE(42X01): Syntax error: Encountered "TRUNCATE" at line 1, column 13.
> > Test escaped string functions - JDBC 3.0 C.2
> > TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> > Executing VALUES { fn CONCAT('hello', 'there') } -- = >hellothere< <<
> > Executing VALUES { fn LENGTH('four ') } -- = >4< <<
> > Executing VALUES { fn LCASE('Fernando Alonso') } -- = >fernando alonso< <<
> > Executing VALUES { fn LOCATE('jour', 'Bonjour') } -- = >4< <<
> > Executing VALUES { fn LTRIM(' left trim ') } -- = >left trim < <<
> > Executing VALUES { fn RTRIM(' right trim ') } -- = > right trim< <<
> > Executing VALUES { fn SUBSTRING('Ruby the Rubicon Jeep', 10, 7) } -- = >Rubicon< <<
> > Executing VALUES { fn UCASE('Fernando Alonso') } -- = >FERNANDO ALONSO< <<
> > TEST FUNCTIONS NOT DECLARED IN DATABASEMETADATA LIST
> > Executing VALUES { fn ASCII('Yellow') } --
> > SQLSTATE(42X01): Syntax error: Encountered "ASCII" at line 1, column 13.
> > Executing VALUES { fn CHAR(65) } -- = >65 < <<
> > FAIL function works but not declared in list: CHAR
> > Executing VALUES { fn DIFFERENCE('Pires', 'Piers') } --
> > SQLSTATE(42X01): Syntax error: Encountered "DIFFERENCE" at line 1, column 13.
> > Executing VALUES { fn INSERT('Bill Clinton', 4, 'William') } --
> > SQLSTATE(42X01): Syntax error: Encountered "INSERT" at line 1, column 13.
> > Executing VALUES { fn LEFT('Bonjour', 3) } --
> > SQLSTATE(42X01): Syntax error: Encountered "LEFT" at line 1, column 13.
> > Executing VALUES { fn REPEAT('echo', 3) } --
> > SQLSTATE(42X01): Syntax error: Encountered "REPEAT" at line 1, column 13.
> > Executing VALUES { fn REPLACE('to be or not to be', 'be', 'England') } --
> > SQLSTATE(42X01): Syntax error: Encountered "REPLACE" at line 1, column 13.
> > Executing VALUES { fn SOUNDEX('Derby') } --
> > SQLSTATE(42X01): Syntax error: Encountered "SOUNDEX" at line 1, column 13.
> > Executing VALUES { fn SPACE(12) } --
> > SQLSTATE(42X01): Syntax error: Encountered "SPACE" at line 1, column 13.
> > Test escaped date time functions - JDBC 3.0 C.3
> > TEST FUNCTIONS DECLARED IN DATABASEMETADATA LIST
> > Executing VALUES CASE WHEN { fn CURDATE()} = CURRENT_DATE THEN 'OK' ELSE 'wrong' END -- = >OK< <<
> > Executing VALUES CASE WHEN { fn CURTIME()} = CURRENT_TIME THEN 'OK' ELSE 'wrong' END -- = >OK< <<
> > Executing VALUES { fn HOUR({t '16:13:03'}) } -- = >16< <<
> > Executing VALUES { fn MINUTE({t '16:13:03'}) } -- = >13< <<
> > Executing VALUES { fn MONTH({d '1995-12-19'}) } -- = >12< <<
> > Executing VALUES { fn SECOND({t '16:13:03'}) } -- = >3< <<
> > Executing VALUES { fn TIMESTAMPADD(SQL_TSI_DAY, 7, {ts '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
> > NO ACTION = 3
> > CASCADE = 0
> > SETNULL = 2
> > SETDEFAULT = 4
> > getCrossReference('','APP','REFACTION1','','APP','REFACTIONNONE' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getCrossReference('','APP','REFACTION1','','APP','REFACTRESTRICT' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getCrossReference('','APP','REFACTION1','','APP','REFACTNOACTION' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getCrossReference('','APP','REFACTION1','','APP','REFACTCASCADE' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTCASCADE,A,1,3,0,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getCrossReference('','APP','REFACTION1','','APP','REFACTSETNULL' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getCrossReference('','APP','REFACTION1','','APP','REFACTUPDRESTRICT' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getCrossReference('','APP','REFACTION1','','APP','REFACTUPDNOACTION' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > getImportedKeys - none update Passed
> > getImportedKeys - none delete Passed
> > getImportedKeys - delete Restrict Passed
> > getImportedKeys - delete NO ACTION Passed
> > getImportedKeys - delete CASCADE Passed
> > getImportedKeys - delete SET NULL Passed
> > getImportedKeys - update Restrict Passed
> > getImportedKeys - update NO ACTION Passed
> > getExportedKeys('',null,null,'','APP','REFACTION1' ):
> > PKTABLE_CAT[VARCHAR],PKTABLE_SCHEM[VARCHAR],PKTABLE_NAME[VARCHAR],PKCOLUMN_NAME[VARCHAR],FKTABLE_CAT[VARCHAR],FKTABLE_SCHEM[VARCHAR],FKTABLE_NAME[VARCHAR],FKCOLUMN_NAME[VARCHAR],KEY_SEQ[SMALLINT],UPDATE_RULE[SMALLINT],DELETE_RULE[SMALLINT],FK_NAME[VARCHAR],PK_NAME[VARCHAR],DEFERRABILITY[SMALLINT]
> > ,APP,REFACTION1,A,,APP,REFACTCASCADE,A,1,3,0,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > ,APP,REFACTION1,A,,APP,REFACTNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > ,APP,REFACTION1,A,,APP,REFACTNONE,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > ,APP,REFACTION1,A,,APP,REFACTRESTRICT,A,1,3,1,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > ,APP,REFACTION1,A,,APP,REFACTSETNULL,A,1,3,2,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > ,APP,REFACTION1,A,,APP,REFACTUPDNOACTION,A,1,3,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > ,APP,REFACTION1,A,,APP,REFACTUPDRESTRICT,A,1,1,3,xxxxGENERATED-IDxxxx,xxxxGENERATED-IDxxxx,7
> > -----
> > getColumns for 'T1'
> > Next line is real null.
> > defval for col C1 type INTEGER DEFAULT 'null' wasnull true
> > Next line is real null.
> > defval for col C2 type INTEGER DEFAULT 'null' wasnull true
> > defval for col C3 type INTEGER DEFAULT 'NULL' wasnull false
> > Next line is real null.
> > defval for col C4 type CHAR DEFAULT 'null' wasnull true
> > defval for col C5 type CHAR DEFAULT 'NULL' wasnull false
> > defval for col C6 type CHAR DEFAULT ''NULL'' wasnull false
> > defval for col C7 type INTEGER DEFAULT '88' wasnull false
> > Test metadata finished
> Test Failed.
> *** End: metadata jdk1.5.0_04 DerbyNetClient derbynetmats:derbynetmats 2006-01-19 04:49:26 ***
> ********* Diff file derbynetclientmats/derbynetmats/DerbyNetClient/derbynetmats/syscat.diff
> *** Start: syscat jdk1.5.0_04 DerbyNetClient derbynetmats:derbynetmats 2006-01-19 04:52:48 ***
> 269 del
> < TABLENAME |ISIND&
> 269a269
> > TABLENAME |ISIN&
> 271 del
> < SYSALIASES |0
> 272 del
> < SYSALIASES |1
> 273 del
> < SYSALIASES |1
> 274 del
> < SYSALIASES |1
> 275 del
> < SYSCHECKS |0
> 276 del
> < SYSCHECKS |1
> 277 del
> < SYSCOLPERMS |0
> 278 del
> < SYSCOLPERMS |1
> 279 del
> < SYSCOLUMNS |0
> 280 del
> < SYSCOLUMNS |1
> 281 del
> < SYSCOLUMNS |1
> 282 del
> < SYSCONGLOMERATES |0
> 283 del
> < SYSCONGLOMERATES |1
> 284 del
> < SYSCONGLOMERATES |1
> 285 del
> < SYSCONGLOMERATES |1
> 286 del
> < SYSCONSTRAINTS |0
> 287 del
> < SYSCONSTRAINTS |1
> 288 del
> < SYSCONSTRAINTS |1
> 289 del
> < SYSCONSTRAINTS |1
> 290 del
> < SYSDEPENDS |0
> 291 del
> < SYSDEPENDS |1
> 292 del
> < SYSDEPENDS |1
> 293 del
> < SYSDUMMY1 |0
> 294 del
> < SYSFILES |0
> 295 del
> < SYSFILES |1
> 296 del
> < SYSFILES |1
> 297 del
> < SYSFOREIGNKEYS |0
> 298 del
> < SYSFOREIGNKEYS |1
> 299 del
> < SYSFOREIGNKEYS |1
> 300 del
> < SYSKEYS |0
> 301 del
> < SYSKEYS |1
> 302 del
> < SYSREQUIREDPERM |0
> 303 del
> < SYSREQUIREDPERM |1
> 304 del
> < SYSROUTINEPERMS |0
> 305 del
> < SYSROUTINEPERMS |1
> 306 del
> < SYSSCHEMAS |0
> 307 del
> < SYSSCHEMAS |1
> 308 del
> < SYSSCHEMAS |1
> 309 del
> < SYSSTATEMENTS |0
> 310 del
> < SYSSTATEMENTS |1
> 311 del
> < SYSSTATEMENTS |1
> 312 del
> < SYSSTATISTICS |0
> 313 del
> < SYSSTATISTICS |1
> 314 del
> < SYSTABLEPERMS |0
> 315 del
> < SYSTABLEPERMS |1
> 316 del
> < SYSTABLES |0
> 317 del
> < SYSTABLES |1
> 318 del
> < SYSTABLES |1
> 319 del
> < SYSTRIGGERS |0
> 320 del
> < SYSTRIGGERS |1
> 321 del
> < SYSTRIGGERS |1
> 322 del
> < SYSTRIGGERS |1
> 323 del
> < SYSVIEWS |0
> 324 del
> < SYSVIEWS |1
> 325 del
> < ij> create table t (i int, s smallint);
> 326 del
> < 0 rows inserted/updated/deleted
> 327 del
> < ij> select TABLENAME, TABLETYPE from sys.systables order by tablename;
> 328 del
> < TABLENAME |&
> 329 del
> < -----
> 330 del
> < SYSALIASES |S
> 331 del
> < SYSCHECKS |S
> 332 del
> < SYSCOLPERMS |S
> 333 del
> < SYSCOLUMNS |S
> 334 del
> < SYSCONGLOMERATES |S
> 335 del
> < SYSCONSTRAINTS |S
> 336 del
> < SYSDEPENDS |S
> 337 del
> < SYSDUMMY1 |S
> 338 del
> < SYSFILES |S
> 339 del
> < SYSFOREIGNKEYS |S
> 340 del
> < SYSKEYS |S
> 341 del
> < SYSREQUIREDPERM |S
> 342 del
> < SYSROUTINEPERMS |S
> 343 del
> < SYSSCHEMAS |S
> 344 del
> < SYSSTATEMENTS |S
> 345 del
> < SYSSTATISTICS |S
> 346 del
> < SYSTABLEPERMS |S
> 347 del
> < SYSTABLES |S
> 348 del
> < SYSTRIGGERS |S
> 349 del
> < SYSVIEWS |S
> 350 del
> < T |T
> 351 del
> < ij> select TABLENAME,
> 352 del
> < COLUMNNAME, COLUMNNUMBER,
> 353 del
> < columndatatype
> 354 del
> < from sys.systables t, sys.syscolumns c
> 355 del
> < where t.TABLEID=c.REFERENCEID
> 356 del
> < order by TABLENAME, COLUMNNAME;
> 357 del
> < TABLENAME |COLUMNNAME |COLUMNNUMB& |COLUMNDATATYPE
> 358 del
> < -----
> 359 del
> < SYSALIASES |ALIAS |2 |VARCHAR(128) NOT NULL
> 360 del
> < SYSALIASES |ALIASID |1 |CHAR(36) NOT NULL
> 361 del
> < SYSALIASES |ALIASINFO |8 |org.apache.derby.catalog.AliasInfo
> 362 del
> < SYSALIASES |ALIASTYPE |5 |CHAR(1) NOT NULL
> 363 del
> < SYSALIASES |JAVACLASSNAME |4 |LONG VARCHAR NOT NULL
> 364 del
> < SYSALIASES |NAMESPACE |6 |CHAR(1) NOT NULL
> 365 del
> < SYSALIASES |SCHEMAID |3 |CHAR(36)
> 366 del
> < SYSALIASES |SPECIFICNAME |9 |VARCHAR(128) NOT NULL
> 367 del
> < SYSALIASES |SYSTEMALIAS |7 |BOOLEAN NOT NULL
> 368 del
> < SYSCHECKS |CHECKDEFINITION |2 |LONG VARCHAR NOT NULL
> 369 del
> < SYSCHECKS |CONSTRAINTID |1 |CHAR(36) NOT NULL
> 370 del
> < SYSCHECKS |REFERENCEDCOLUMNS |3 |org.apache.derby.catalog.ReferencedColumns NOT NULL
> 371 del
> < SYSCOLPERMS |COLUMNS |5 |org.apache.derby.iapi.services.io.FormatableBitSet NOT NULL
> 372 del
> < SYSCOLPERMS |GRANTEE |1 |VARCHAR(30) NOT NULL
> 373 del
> < SYSCOLPERMS |GRANTOR |2 |VARCHAR(30) NOT NULL
> 374 del
> < SYSCOLPERMS |TABLEID |3 |CHAR(36) NOT NULL
> 375 del
> < SYSCOLPERMS |TYPE |4 |CHAR(1) NOT NULL
> 376 del
> < SYSCOLUMNS |AUTOINCREMENTINC |9 |BIGINT
> 377 del
> < SYSCOLUMNS |AUTOINCREMENTSTART |8 |BIGINT
> 378 del
> < SYSCOLUMNS |AUTOINCREMENTVALUE |7 |BIGINT
> 379 del
> < SYSCOLUMNS |COLUMNDATATYPE |4 |org.apache.derby.catalog.TypeDescriptor NOT NULL
> 380 del
> < SYSCOLUMNS |COLUMNDEFAULT |5 |java.io.Serializable
> 381 del
> < SYSCOLUMNS |COLUMNDEFAULTID |6 |CHAR(36)
> 382 del
> < SYSCOLUMNS |COLUMNNAME |2 |VARCHAR(128) NOT NULL
> 383 del
> < SYSCOLUMNS |COLUMNNUMBER |3 |INTEGER NOT NULL
> 384 del
> < SYSCOLUMNS |REFERENCEID |1 |CHAR(36) NOT NULL
> 385 del
> < SYSCONGLOMERATES |CONGLOMERATEID |8 |CHAR(36) NOT NULL
> 386 del
> < SYSCONGLOMERATES |CONGLOMERATENAME |4 |VARCHAR(128)
> 387 del
> < SYSCONGLOMERATES |CONGLOMERATENUMBER |3 |BIGINT NOT NULL
> 388 del
> < SYSCONGLOMERATES |DESCRIPTOR |6 |org.apache.derby.catalog.IndexDescriptor
> 389 del
> < SYSCONGLOMERATES |ISCONSTRAINT |7 |BOOLEAN
> 390 del
> < SYSCONGLOMERATES |ISINDEX |5 |BOOLEAN NOT NULL
> 391 del
> < SYSCONGLOMERATES |SCHEMAID |1 |CHAR(36) NOT NULL
> 392 del
> < SYSCONGLOMERATES |TABLEID |2 |CHAR(36) NOT NULL
> 393 del
> < SYSCONSTRAINTS |CONSTRAINTID |1 |CHAR(36) NOT NULL
> 394 del
> < SYSCONSTRAINTS |CONSTRAINTNAME |3 |VARCHAR(128) NOT NULL
> 395 del
> < SYSCONSTRAINTS |REFERENCECOUNT |7 |INTEGER NOT NULL
> 396 del
> < SYSCONSTRAINTS |SCHEMAID |5 |CHAR(36) NOT NULL
> 397 del
> < SYSCONSTRAINTS |STATE |6 |CHAR(1) NOT NULL
> 398 del
> < SYSCONSTRAINTS |TABLEID |2 |CHAR(36) NOT NULL
> 399 del
> < SYSCONSTRAINTS |TYPE |4 |CHAR(1) NOT NULL
> 400 del
> < SYSDEPENDS |DEPENDENTFINDER |2 |org.apache.derby.catalog.DependableFinder NOT NULL
> 401 del
> < SYSDEPENDS |DEPENDENTID |1 |CHAR(36) NOT NULL
> 402 del
> < SYSDEPENDS |PROVIDERFINDER |4 |org.apache.derby.catalog.DependableFinder NOT NULL
> 403 del
> < SYSDEPENDS |PROVIDERID |3 |CHAR(36) NOT NULL
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira