"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "hsqldb/src/org/hsqldb/resources/information-schema.sql" between
hsqldb-2.7.1.zip and hsqldb-2.7.2.zip

About: HSQLDB (HyperSQL DataBase) is a SQL relational database engine written in Java. It supports nearly full ANSI-92 SQL (BNF format) and full core SQL:2008.

information-schema.sql  (hsqldb-2.7.1):information-schema.sql  (hsqldb-2.7.2)
-- author Fred Toussi (fredt@users dot sourceforge.net) version 2.7.2
/*system_procedures*/ /*system_procedures*/
SELECT ROUTINE_CATALOG AS PROCEDURE_CAT, ROUTINE_SCHEMA AS PROCEDURE_SCHEM, SELECT ROUTINE_CATALOG AS PROCEDURE_CAT, ROUTINE_SCHEMA AS PROCEDURE_SCHEM,
ROUTINE_NAME AS PROCEDURE_NAME, 0, 0, 0, ROUTINE_NAME AS PROCEDURE_NAME, 0, 0, 0,
CAST( NULL AS VARCHAR(256)) AS REMARKS, CAST( NULL AS VARCHAR(256)) AS REMARKS,
CASE WHEN ROUTINE_TYPE = 'PROCEDURE' THEN 1 ELSE 2 END CASE AS PROCEDURE_TYPE, CASE WHEN ROUTINE_TYPE = 'PROCEDURE' THEN 1 ELSE 2 END CASE AS PROCEDURE_TYPE,
SPECIFIC_NAME FROM INFORMATION_SCHEMA.ROUTINES SPECIFIC_NAME FROM INFORMATION_SCHEMA.ROUTINES
/*data_type_privileges*/ /*data_type_privileges*/
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
'TABLE', DTD_IDENTIFIER 'TABLE', DTD_IDENTIFIER
skipping to change at line 536 skipping to change at line 536
('T620', 'WINDOW clause: GROUPS option', '', '', 'NO', NULL, ''), ('T620', 'WINDOW clause: GROUPS option', '', '', 'NO', NULL, ''),
('T621', 'Enhanced numeric functions', '', '', 'YES', NULL, ''), ('T621', 'Enhanced numeric functions', '', '', 'YES', NULL, ''),
('T631', 'IN predicate with one list element', '', '', 'YES', NULL, ''), ('T631', 'IN predicate with one list element', '', '', 'YES', NULL, ''),
('T641', 'Multiple column assignment', '', '', 'YES', NULL, ''), ('T641', 'Multiple column assignment', '', '', 'YES', NULL, ''),
('T651', 'SQL-schema statements in SQL routines', '', '', 'NO', NULL, ''), ('T651', 'SQL-schema statements in SQL routines', '', '', 'NO', NULL, ''),
('T652', 'SQL-dynamic statements in SQL routines', '', '', 'NO', NULL, ''), ('T652', 'SQL-dynamic statements in SQL routines', '', '', 'NO', NULL, ''),
('T653', 'SQL-schema statements in external routines', '', '', 'NO', NULL, ''), ('T653', 'SQL-schema statements in external routines', '', '', 'NO', NULL, ''),
('T654', 'SQL-dynamic statements in external routines', '', '', 'YES', NULL, '') , ('T654', 'SQL-dynamic statements in external routines', '', '', 'YES', NULL, '') ,
('T655', 'Cyclically dependent routines', '', '', 'YES', NULL, ''), ('T655', 'Cyclically dependent routines', '', '', 'YES', NULL, ''),
('T811', 'Basic SQL/JSON constructor functions', '', '', 'YES', NULL, ''), ('T811', 'Basic SQL/JSON constructor functions', '', '', 'YES', NULL, ''),
('T812', 'SQL/JSON: JSON_OBJECTAGG with no <JSON key uniqueness constraint', '', '', 'YES', NULL, ''), ('T812', 'SQL/JSON: JSON_OBJECTAGG with no <JSON key uniqueness constraint>', '' , '', 'YES', NULL, ''),
('T813', 'SQL/JSON: JSON_ARRAYAGG with ORDER BY', '', '', 'YES', NULL, ''), ('T813', 'SQL/JSON: JSON_ARRAYAGG with ORDER BY', '', '', 'YES', NULL, ''),
('T814', 'Colon in JSON_OBJECT or JSON_OBJECTAGG', '', '', 'YES', NULL, ''), ('T814', 'Colon in JSON_OBJECT or JSON_OBJECTAGG', '', '', 'YES', NULL, ''),
('T830', 'Enforcing unique keys in SQL/JSON constructor functions', '', '', 'YES ', NULL, ''); ('T830', 'Enforcing unique keys in SQL/JSON constructor functions', '', '', 'YES ', NULL, '');
/*sql_packages*/ /*sql_packages*/
VALUES VALUES
( 'PKG001', 'Enhanced datetime facilities','YES', CAST(NULL AS CHARACTER), '' ), ( 'PKG001', 'Enhanced datetime facilities','YES', CAST(NULL AS CHARACTER), '' ),
( 'PKG002', 'Enhanced integrity management','YES', NULL, 'Without F521' ), ( 'PKG002', 'Enhanced integrity management','YES', NULL, 'Without F521' ),
( 'PKG004', 'PSM', 'YES', NULL, 'Without P001' ), ( 'PKG004', 'PSM', 'YES', NULL, 'Without P001' ),
( 'PKG006', 'Basic object support', 'NO', NULL, '' ), ( 'PKG006', 'Basic object support', 'NO', NULL, '' ),
skipping to change at line 594 skipping to change at line 594
( 25004, 'MAXIMUM SESSION USER LENGTH', 128, NULL), ( 25004, 'MAXIMUM SESSION USER LENGTH', 128, NULL),
( 25005, 'MAXIMUM SYSTEM USER LENGTH', 128, NULL); ( 25005, 'MAXIMUM SYSTEM USER LENGTH', 128, NULL);
/*sql_implementation_info*/ /*sql_implementation_info*/
VALUES VALUES
( 10003, 'CATALOG NAME', NULL, 'Y', 'CHAR: ''Y'' if supported, otherwise ''N''' ), ( 10003, 'CATALOG NAME', NULL, 'Y', 'CHAR: ''Y'' if supported, otherwise ''N''' ),
( 10004, 'COLLATING SEQUENCE', NULL, 'English', 'CHAR: default collation name' ) , ( 10004, 'COLLATING SEQUENCE', NULL, 'English', 'CHAR: default collation name' ) ,
( 23, 'CURSOR COMMIT BEHAVIOR', 2, NULL, 'INT: 0: close cursors & delete prepare d stmts 1: close cursors & retain prepared stmts 2: leave cursors open & retain stmts' ), ( 23, 'CURSOR COMMIT BEHAVIOR', 2, NULL, 'INT: 0: close cursors & delete prepare d stmts 1: close cursors & retain prepared stmts 2: leave cursors open & retain stmts' ),
( 2, 'DATA SOURCE NAME', NULL, '', 'CHAR: <connection name> on CONNECT statement ' ), ( 2, 'DATA SOURCE NAME', NULL, '', 'CHAR: <connection name> on CONNECT statement ' ),
( 17, 'DBMS NAME', NULL, 'HSQLDB', 'CHAR: Name of the implementation software' ) , ( 17, 'DBMS NAME', NULL, 'HSQLDB', 'CHAR: Name of the implementation software' ) ,
( 18, 'DBMS VERSION', NULL, '2.7.1', 'CHAR: Version of the implementation softwa re The format is: <part1>.<part2>.<part3>[<part4>] where: <part1> ::= <digit><di git> <part2> ::= <digit><digit> <part3> ::= <digit><digit><digit><digit> <part4> ::= <character representation>' ), ( 18, 'DBMS VERSION', NULL, '2.7.2', 'CHAR: Version of the implementation softwa re The format is: <part1>.<part2>.<part3>[<part4>] where: <part1> ::= <digit><di git> <part2> ::= <digit><digit> <part3> ::= <digit><digit><digit><digit> <part4> ::= <character representation>' ),
( 26, 'DEFAULT TRANSACTION ISOLATION', 2, NULL, 'INT: 1: READ UNCOMMITTED 2: REA D COMMITTED 3: REPEATABLE READ 4: SERIALIZABLE' ), ( 26, 'DEFAULT TRANSACTION ISOLATION', 2, NULL, 'INT: 1: READ UNCOMMITTED 2: REA D COMMITTED 3: REPEATABLE READ 4: SERIALIZABLE' ),
( 28, 'IDENTIFIER CASE', 3, NULL, 'The case in which identifiers are stored in t he Definition Schema INT: 1: stored in upper case 2: stored in lower case 3: sto red in mixed case - case sensitive 4: stored in mixed case - case insensitive' ) , ( 28, 'IDENTIFIER CASE', 3, NULL, 'The case in which identifiers are stored in t he Definition Schema INT: 1: stored in upper case 2: stored in lower case 3: sto red in mixed case - case sensitive 4: stored in mixed case - case insensitive' ) ,
( 85, 'NULL COLLATION', 1, NULL, 'INT: 0: nulls higher than non-nulls 1: nulls l ower than non-nulls' ), ( 85, 'NULL COLLATION', 1, NULL, 'INT: 0: nulls higher than non-nulls 1: nulls l ower than non-nulls' ),
( 13, 'SERVER NAME', NULL, '', 'CHAR: <SQL server name> on CONNECT statement' ), ( 13, 'SERVER NAME', NULL, '', 'CHAR: <SQL server name> on CONNECT statement' ),
( 94, 'SPECIAL CHARACTERS', NULL, '', 'CHAR: All special chars OK in non-delimit ed ids' ), ( 94, 'SPECIAL CHARACTERS', NULL, '', 'CHAR: All special chars OK in non-delimit ed ids' ),
( 46, 'TRANSACTION CAPABLE', 3, NULL, 'INT: 0: not supported 1: DML only - error if DDL 2: both DML and DDL 3: DML only - commit before DDL 4: DML only - ignore DDL' ); ( 46, 'TRANSACTION CAPABLE', 3, NULL, 'INT: 0: not supported 1: DML only - error if DDL 2: both DML and DDL 3: DML only - commit before DDL 4: DML only - ignore DDL' );
 End of changes. 3 change blocks. 
2 lines changed or deleted 3 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)