"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "hsqldb/testrun/sql2nnn/ISO_IEC_9075_2_SQL_Foundation/E031_identifiers/E031_Identifiers_03_Trailing_underscore.sql" between
hsqldb-2.7.0.zip and hsqldb-2.7.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.

E031_Identifiers_03_Trailing_underscore.sql  (hsqldb-2.7.0)	:	E031_Identifiers_03_Trailing_underscore.sql  (hsqldb-2.7.1)
/*s*/DROP TABLE IF EXISTS TEST_;		-- E031_Identifiers_03_Trailing_underscore.sql
/*s*/CREATE TABLE TEST_(ID_ INT);		DROP TABLE IF EXISTS TEST_;
/*c1*/SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES T WHERE T.TA		CREATE TABLE TEST_(ID_ INT);
BLE_SCHEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_';		SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES T WHERE T.TABLE_SC
/*s*/ALTER TABLE TEST_ ADD COLUMN VALUE_ VARCHAR(255) NOT NULL;		HEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_';
/*c1*/SELECT COUNT(*) AS COLUMN_COUNT FROM INFORMATION_SCHEMA.COLUMNS T WHERE T.		ALTER TABLE TEST_ ADD COLUMN VALUE_ VARCHAR(255) NOT NULL;
TABLE_SCHEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_' AND T.COLUMN_NAME = 'VALUE_';		SELECT COUNT(*) AS COLUMN_COUNT FROM INFORMATION_SCHEMA.COLUMNS T WHERE T.TABLE_
/*s*/ALTER TABLE TEST_ DROP COLUMN VALUE_;		SCHEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_' AND T.COLUMN_NAME = 'VALUE_';
/*c1*/SELECT COUNT(*) AS COLUMN_COUNT FROM INFORMATION_SCHEMA.COLUMNS T WHERE T		ALTER TABLE TEST_ DROP COLUMN VALUE_;
.TABLE_SCHEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_' AND T.COLUMN_NAME = 'VALUE_'		SELECT COUNT(*) AS COLUMN_COUNT FROM INFORMATION_SCHEMA.COLUMNS T WHERE T.TABLE
;		_SCHEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_' AND T.COLUMN_NAME = 'VALUE_';
/*s*/DROP TABLE TEST_;		DROP TABLE TEST_;
/*c1*/SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES T WHERE T.TA		SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES T WHERE T.TABLE_SC
BLE_SCHEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_';		HEMA = 'PUBLIC' AND T.TABLE_NAME = 'TEST_';
End of changes. 1 change blocks.
lines changed or deleted		lines changed or added

---