"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "hsqldb/src/org/hsqldb/resources/information-schema.sql" between
hsqldb-2.6.0.zip and hsqldb-2.6.1.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.6.0)	:	information-schema.sql  (hsqldb-2.6.1)
		-- author Fred Toussi (fredt@users dot sourceforge.net) version 2.6.1
/*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 588		skipping to change at line 588
( 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.6.0', '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.6.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>' ),
( 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. 2 change blocks.
1 lines changed or deleted		2 lines changed or added

---