Appendix B: Document History

The exact file history is recorded in the manual module in our CVS tree; see http://sourceforge.net/cvs/?group_id=9028

Revision History
1.0	4 Jul 2008	PV	First publication, using 15–20% material from the Firebird Release Notes.
1.1	8 Dec 2010	PV	GLOBAL: Renamed all “Deprecated in” section headers to “Better alternative”. This also required editing the text immediately following the header and in some cases additional text in the section (if the “deprecation” was discussed in the section body). Bookinfo: Added 1.5.6 to covered versions. Introduction :: Versions covered: Added 1.5.6. Introduction :: Authorship: Edited first paragraph. Added Frank Ingermann to contributor list. Reserved words :: Added in 1.0 and 1.5: Put 2nd list in alphabetical order. Reserved words :: To be added in future versions: Put list in alphabetical order. Miscellaneous language elements :: -- (single-line comment): Brought last para within blockquote. Miscellaneous language elements: Added sections \|\| (string concatenator) and Shorthand casts. DDL statements: Added section ALTER DOMAIN. DDL statements :: ALTER TABLE: Added section ADD column: Context variables as defaults. DDL statements :: ALTER TABLE: Added section FOREIGN KEY without target column references PK. DDL statements: Added section CREATE DOMAIN. DDL statements :: CREATE TABLE: Added section Context variables as column defaults. DDL statements :: CREATE TABLE: Added section FOREIGN KEY without target column references PK. DML statements: Moved sections RELEASE SAVEPOINT, ROLLBACK TO SAVEPOINT and SAVEPOINT into new chapter Transaction control statements. DML statements :: SELECT :: Aggregate functions: Extended functionality :: Aggregate statements: Stricter HAVING and ORDER BY: Edited second listitem. Commented out third listitem as it needs research. Edited last paragraph. DML statements :: SELECT :: FIRST and SKIP: Edited Description. DML statements :: SELECT :: GROUP BY internal function, column position, and CASE: Added 3rd listitem to Important box. Edited the paras between the examples. Transaction control statements: new chapter. PSQL statements :: DECLARE [VARIABLE] with initialization: Indented var declarations in Example. PSQL statements :: EXECUTE STATEMENT :: Caveats with EXECUTE STATEMENT: Changed SQL -> DSQL in item 4. Rewrote item 6. PSQL statements: Added section FOR SELECT ... INTO ... DO. Context variables :: `CURRENT_CONNECTION`: Improved Description. Added note about upcoming change in 2.1 to last paragraph. Context variables :: `CURRENT_TRANSACTION`: Improved Description. Context variables :: `ROW_COUNT`: Edited Description. Edited second Note. External functions :: `getExactTimestamp`: Edited Description. External functions :: `log`: Changed `log` -> `log(x,y)` in Description. External functions :: `right`: moved to `sright` and left a symlink in place. External functions :: `round`, `i64round`: Added 1.5.6 to Changed in. Added Caution box. Edited and extended Bug warning box. External functions :: `substrlen`: Added “Better alternative” formalpara. External functions :: `truncate`, `i64truncate`: Added 1.5.6 to Changed in. Added Caution box. Edited Warning box. Notes :: Understanding the WITH LOCK clause :: Syntax and behaviour: In table, aligned 1st column left, all rows top, and added periods to sentences in first two rows. License notice: Added Frank Ingermann as contributor. Copyright end year now 2010.