PDO_ODBC test cases, primary key syntax

From: Date: Thu, 03 Mar 2005 11:43:09 +0000
Subject: PDO_ODBC test cases, primary key syntax
Groups: php.pecl.dev 
Request: Send a blank email to pecl-dev+get-2111@lists.php.net to get a copy of this message
So I'm finally porting the pdo/tests testcases over to pdo_odbc (using DB2 as the test database for pdo_odbc). The major issue I've had is that the current CREATE TABLE statements identify a column as a primary key, but don't specify that the column has to be null. DB2 barfs on this. The current syntax is: CREATE TABLE (id integer primary key, blah...) The more explicit syntax is: CREATE TABLE (id integer not null primary key, blah...) MySQL appears to accept this syntax (http://dev.mysql.com/doc/mysql/en/create-table.html). Any objections to updating the source pdo/tests/*.inc files to use the more explicit syntax? Up way too early this morning, Dan

« previous php.pecl.dev (#2111) next »