PDO_ODBC test cases, primary key syntax
| From: | Dan Scott | 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