SQL Reference Manuals

Here's a list of the SQL reference manuals for the supported database systems.
I thought it may help development of Zend_Db_Select, and other database modules.

• DB2: I-Series V5R3

• DB2: Linux, Unix, Windows and z/OS

• Microsoft SQL Server: 2005, 2000.

• MySQL: 5.2(alpha), 5.1, 5.0, 3.23,4.0,4.1.

• Oracle: 10g, 8i.

• PostgreSQL: 8.2, 8.1, 8.0, 7.4, 7.3.

• SQLite: latest (3.3.13)

Please add missing systems and versions, and strike out any non-supported versions.
The links should lead directly to an index of the SQL reference manual.

Unit Testing

Many of the adapters supported by Zend_Framework require some fine-tuning for them to pass unit testing. Adapter-specific notes are listed below for reference.

Pdo_Mssql

• The transaction suite does not work consistently if two concurrent connections are made to the database. The driver-specific tests rely on a single connection only to perform database updates and to then test the integrity of those updates after a COMMIT and a ROLLBACK
• Manipulating primary keys' values should only be attempted after performing a query 'SET IDENTITY_INSERT [table_name] ON' and subsequently turning off this behaviour with 'SET IDENTITY_INSERT [table_name] OFF'