[svn:DBD-mysql] r9277 - in DBD-mysql/trunk: . t

[jimw]

Author: jimw
Date: Mon Mar 19 12:14:02 2007
New Revision: 9277

Modified:
   DBD-mysql/trunk/ChangeLog
   DBD-mysql/trunk/t/41bindparam.t
   DBD-mysql/trunk/t/42bindparam.t

Log:
Work around a bug in old 3.23 servers by specifying NOT NULL for fields used
as a primary key in tests. (Bug #20325, reported by Julian Ladisch)


Modified: DBD-mysql/trunk/ChangeLog
==============================================================================
--- DBD-mysql/trunk/ChangeLog	(original)
+++ DBD-mysql/trunk/ChangeLog	Mon Mar 19 12:14:02 2007
@@ -1,4 +1,6 @@
 <unreleased> Patrick Galbraith <patg@stripped> Jim Winstead
<jimw@stripped> (4.004)
+* Work around a bug in old 3.23 servers by specifying NOT NULL for fields used
+  as a primary key in tests. (Bug #20325, reported by Julian Ladisch)
 * Add support for mysql_warning_count statement handle attribute. (Bug #25457,
   patch from Philip Stoev)
 * Add support for mysql_multi_statements connection option. (RT #12322, based

Modified: DBD-mysql/trunk/t/41bindparam.t
==============================================================================
--- DBD-mysql/trunk/t/41bindparam.t	(original)
+++ DBD-mysql/trunk/t/41bindparam.t	Mon Mar 19 12:14:02 2007
@@ -48,7 +48,7 @@
     DbiError($dbh->err, $dbh->errstr); 
 
   Test($state or 
-    $dbh->do("create table $table (a int, primary key (a))")) or
+    $dbh->do("create table $table (a int not null, primary key (a))")) or
     DbiError($dbh->err, $dbh->errstr); 
 
   Test($state or 

Modified: DBD-mysql/trunk/t/42bindparam.t
==============================================================================
--- DBD-mysql/trunk/t/42bindparam.t	(original)
+++ DBD-mysql/trunk/t/42bindparam.t	Mon Mar 19 12:14:02 2007
@@ -45,7 +45,7 @@
     DbiError($dbh->err, $dbh->errstr); 
     
   Test($state or 
-    $dbh->do("create table $table (a int, b double, primary key (a))")) or
+    $dbh->do("create table $table (a int not null, b double, primary key (a))")) or
     DbiError($dbh->err, $dbh->errstr); 
 
   Test($state or