Skip to end of metadata
Go to start of metadata

<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>
<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>

<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>

<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>

<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>

<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>

<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>
<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>
<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>

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.