Version 7 by Simon Mundy
on Jan 20, 2008 07:07.

compared with
Current by Simon Mundy
on Jan 20, 2008 07:07.

(show comment)
Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (24)

View Page History
h1. SQL Reference Manuals
<h1>SQL Reference Manuals</h1>

<p>Here's a list of the SQL reference manuals for the supported database systems.<br />
I thought it may help development of Zend_Db_Select, and other database modules.</p>
* DB2: [I-Series V5R3|http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmst02.htm]
<ul>
<li>DB2: <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmst02.htm">I-Series V5R3</a></li>
</ul>

* DB2: [Linux, Unix, Windows|http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp] and [z/OS|http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp]

* Microsoft SQL Server: [2005|http://msdn2.microsoft.com/en-us/library/ms189826.aspx], [2000|http://msdn2.microsoft.com/en-us/library/aa299742(sql.80).aspx].
<ul>
<li>DB2: <a href="http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp">Linux, Unix, Windows</a> and <a href="http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp">z/OS</a></li>
</ul>

* MySQL: [5.2(alpha)|http://dev.mysql.com/doc/falcon/en/index.html], [5.1|http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html], [5.0|http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html], [3.23,4.0,4.1|http://dev.mysql.com/doc/refman/4.1/en/sql-syntax.html].

* Oracle: [10g|http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm], [8i|http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/toc.htm].
<ul>
<li>Microsoft SQL Server: <a href="http://msdn2.microsoft.com/en-us/library/ms189826.aspx">2005</a>, <a href="http://msdn2.microsoft.com/en-us/library/aa299742(sql.80).aspx">2000</a>.</li>
</ul>

* PostgreSQL: [8.2|http://www.postgresql.org/docs/8.2/static/sql-commands.html], [8.1|http://www.postgresql.org/docs/8.1/static/sql-commands.html], [8.0|http://www.postgresql.org/docs/8.0/static/sql-commands.html], [7.4|http://www.postgresql.org/docs/7.4/static/sql-commands.html], [7.3|http://www.postgresql.org/docs/7.3/static/sql-commands.html].

* SQLite: [latest (3.3.13)|http://www.sqlite.org/lang.html]
<ul>
<li>MySQL: <a href="http://dev.mysql.com/doc/falcon/en/index.html">5.2(alpha)</a>, <a href="http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html">5.1</a>, <a href="http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html">5.0</a>, <a href="http://dev.mysql.com/doc/refman/4.1/en/sql-syntax.html">3.23,4.0,4.1</a>.</li>
</ul>

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.

h1. Unit Testing
<ul>
<li>Oracle: <a href="http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm">10g</a>, <a href="http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/toc.htm">8i</a>.</li>
</ul>

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.

h2. Pdo_Mssql
<ul>
<li>PostgreSQL: <a href="http://www.postgresql.org/docs/8.2/static/sql-commands.html">8.2</a>, <a href="http://www.postgresql.org/docs/8.1/static/sql-commands.html">8.1</a>, <a href="http://www.postgresql.org/docs/8.0/static/sql-commands.html">8.0</a>, <a href="http://www.postgresql.org/docs/7.4/static/sql-commands.html">7.4</a>, <a href="http://www.postgresql.org/docs/7.3/static/sql-commands.html">7.3</a>.</li>
</ul>


<ul>
<li>SQLite: <a href="http://www.sqlite.org/lang.html">latest (3.3.13)</a></li>
</ul>


<p>Please add missing systems and versions, and <span style="text-decoration: line-through;">strike out</span> any non-supported versions.<br />
The links should lead directly to an index of the SQL reference manual.</p>

<h1>Unit Testing</h1>

<p>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.</p>

<h2>Pdo_Mssql</h2>
<ul>
* The <li>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</li>
* 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'
<li>Manipulating primary keys' values should only be attempted after performing a query 'SET IDENTITY_INSERT <ac:link><ri:page ri:content-title="table_name" /></ac:link> ON' and subsequently turning off this behaviour with 'SET IDENTITY_INSERT <ac:link><ri:page ri:content-title="table_name" /></ac:link> OFF'</li>
</ul>