cvs: php-src /ext/pdo/tests pdo_001.inc pdo_002.inc pdo_003.inc pdo_004.inc pdo_005.inc pdo_006.inc pdo_007.inc pdo_008.inc pdo_009.inc pdo_010.inc
pdo_011.inc pdo_012.inc pdo_013.inc pdo_014.inc pdo_015.inc pdo_016.inc pdo_018.inc pdo_019.inc
| From: | Magnus M��tt� | Date: | Thu, 10 Mar 2005 02:37:21 +0000 |
| Subject: | cvs: php-src /ext/pdo/tests pdo_001.inc pdo_002.inc pdo_003.inc pdo_004.inc pdo_005.inc pdo_006.inc pdo_007.inc pdo_008.inc pdo_009.inc pdo_010.inc pdo_011.inc pdo_012.inc pdo_013.inc pdo_014.inc pdo_015.inc pdo_016.inc pdo_018.inc pdo_019.inc |
||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-30822@lists.php.net to get a copy of this message | ||
magnus Wed Mar 9 21:37:21 2005 EDT
Modified files:
/php-src/ext/pdo/tests pdo_001.inc pdo_002.inc pdo_003.inc
pdo_004.inc pdo_005.inc pdo_006.inc
pdo_007.inc pdo_008.inc pdo_009.inc
pdo_010.inc pdo_011.inc pdo_012.inc
pdo_013.inc pdo_014.inc pdo_015.inc
pdo_016.inc pdo_018.inc pdo_019.inc
Log:
Add NOT NULL to create so the tests work with Firebird too.
http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_001.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_001.inc diff -u php-src/ext/pdo/tests/pdo_001.inc:1.3 php-src/ext/pdo/tests/pdo_001.inc:1.4 --- php-src/ext/pdo/tests/pdo_001.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_001.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_002.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_002.inc diff -u php-src/ext/pdo/tests/pdo_002.inc:1.3 php-src/ext/pdo/tests/pdo_002.inc:1.4 --- php-src/ext/pdo/tests/pdo_002.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_002.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_003.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_003.inc diff -u php-src/ext/pdo/tests/pdo_003.inc:1.3 php-src/ext/pdo/tests/pdo_003.inc:1.4 --- php-src/ext/pdo/tests/pdo_003.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_003.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_004.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_004.inc diff -u php-src/ext/pdo/tests/pdo_004.inc:1.3 php-src/ext/pdo/tests/pdo_004.inc:1.4 --- php-src/ext/pdo/tests/pdo_004.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_004.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_005.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_005.inc diff -u php-src/ext/pdo/tests/pdo_005.inc:1.3 php-src/ext/pdo/tests/pdo_005.inc:1.4 --- php-src/ext/pdo/tests/pdo_005.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_005.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'AA\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'BB\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\', \'CC\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_006.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_006.inc diff -u php-src/ext/pdo/tests/pdo_006.inc:1.3 php-src/ext/pdo/tests/pdo_006.inc:1.4 --- php-src/ext/pdo/tests/pdo_006.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_006.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'A\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_007.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_007.inc diff -u php-src/ext/pdo/tests/pdo_007.inc:1.3 php-src/ext/pdo/tests/pdo_007.inc:1.4 --- php-src/ext/pdo/tests/pdo_007.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_007.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id CHAR(1) PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(\'A\', \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(\'B\', \'A\')'); set_sql('insert3', 'INSERT INTO test VALUES(\'C\', \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_008.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_008.inc diff -u php-src/ext/pdo/tests/pdo_008.inc:1.3 php-src/ext/pdo/tests/pdo_008.inc:1.4 --- php-src/ext/pdo/tests/pdo_008.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_008.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id CHAR(1) PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(\'A\', \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(\'B\', \'A\')'); set_sql('insert3', 'INSERT INTO test VALUES(\'C\', \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_009.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_009.inc diff -u php-src/ext/pdo/tests/pdo_009.inc:1.3 php-src/ext/pdo/tests/pdo_009.inc:1.4 --- php-src/ext/pdo/tests/pdo_009.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_009.inc Wed Mar 9 21:37:20 2005 @@ -2,11 +2,11 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(10) UNIQUE)'); +set_sql('create1', 'CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) UNIQUE)'); set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'Test1\')'); set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'Test2\')'); -set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(10))'); +set_sql('create2', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10))'); set_sql('insert4', 'INSERT INTO test VALUES(1, 0, \'A\')'); set_sql('insert5', 'INSERT INTO test VALUES(2, 1, \'B\')'); set_sql('insert6', 'INSERT INTO test VALUES(3, 2, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_010.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_010.inc diff -u php-src/ext/pdo/tests/pdo_010.inc:1.2 php-src/ext/pdo/tests/pdo_010.inc:1.3 --- php-src/ext/pdo/tests/pdo_010.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_010.inc Wed Mar 9 21:37:20 2005 @@ -2,11 +2,11 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(10) UNIQUE)'); +set_sql('create1', 'CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) UNIQUE)'); set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'Test1\')'); set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'Test2\')'); -set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create2', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert4', 'INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')'); set_sql('insert5', 'INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')'); set_sql('insert6', 'INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_011.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_011.inc diff -u php-src/ext/pdo/tests/pdo_011.inc:1.2 php-src/ext/pdo/tests/pdo_011.inc:1.3 --- php-src/ext/pdo/tests/pdo_011.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_011.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group1\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\', \'Group2\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_012.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_012.inc diff -u php-src/ext/pdo/tests/pdo_012.inc:1.2 php-src/ext/pdo/tests/pdo_012.inc:1.3 --- php-src/ext/pdo/tests/pdo_012.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_012.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group2\')'); set_sql('select1', 'SELECT val, grp FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_013.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_013.inc diff -u php-src/ext/pdo/tests/pdo_013.inc:1.2 php-src/ext/pdo/tests/pdo_013.inc:1.3 --- php-src/ext/pdo/tests/pdo_013.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_013.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group2\')'); set_sql('select1', 'SELECT val, grp FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_014.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_014.inc diff -u php-src/ext/pdo/tests/pdo_014.inc:1.2 php-src/ext/pdo/tests/pdo_014.inc:1.3 --- php-src/ext/pdo/tests/pdo_014.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_014.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group2\')'); set_sql('select1', 'SELECT val, grp FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_015.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_015.inc diff -u php-src/ext/pdo/tests/pdo_015.inc:1.1 php-src/ext/pdo/tests/pdo_015.inc:1.2 --- php-src/ext/pdo/tests/pdo_015.inc:1.1 Sun Feb 27 17:32:11 2005 +++ php-src/ext/pdo/tests/pdo_015.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(20))'); +set_sql('create1', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(20))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'A2\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'A\', \'B2\')'); set_sql('select1', 'SELECT id, val, val2 FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_016.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_016.inc diff -u php-src/ext/pdo/tests/pdo_016.inc:1.1 php-src/ext/pdo/tests/pdo_016.inc:1.2 --- php-src/ext/pdo/tests/pdo_016.inc:1.1 Thu Mar 3 20:29:27 2005 +++ php-src/ext/pdo/tests/pdo_016.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE test(idx int PRIMARY KEY, txt VARCHAR(20))'); +set_sql('create1', 'CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); set_sql('insert1', 'INSERT INTO test VALUES(0, \'String0\')'); set_sql('insert2', 'INSERT INTO test VALUES(1, \'String1\')'); set_sql('insert3', 'INSERT INTO test VALUES(2, \'String2\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_018.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_018.inc diff -u php-src/ext/pdo/tests/pdo_018.inc:1.1 php-src/ext/pdo/tests/pdo_018.inc:1.2 --- php-src/ext/pdo/tests/pdo_018.inc:1.1 Mon Mar 7 17:36:11 2005 +++ php-src/ext/pdo/tests/pdo_018.inc Wed Mar 9 21:37:20 2005 @@ -54,13 +54,13 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(20) UNIQUE)'); +set_sql('create1', 'CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(20) UNIQUE)'); set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'TestBase\')'); set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'TestDerived\')'); set_sql('selectC', 'SELECT COUNT(*) FROM classtypes'); set_sql('select0', 'SELECT id, name FROM classtypes ORDER by id'); -set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(255))'); +set_sql('create2', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(255))'); set_sql('insert4', 'INSERT INTO test VALUES(:id, :classtype, :val)'); set_sql('select1', 'SELECT id FROM classtypes WHERE name=:cname'); set_sql('select2', 'SELECT test.val FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_019.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_019.inc diff -u php-src/ext/pdo/tests/pdo_019.inc:1.1 php-src/ext/pdo/tests/pdo_019.inc:1.2 --- php-src/ext/pdo/tests/pdo_019.inc:1.1 Mon Mar 7 17:43:27 2005 +++ php-src/ext/pdo/tests/pdo_019.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE test(idx int PRIMARY KEY, txt VARCHAR(20))'); +set_sql('create1', 'CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); set_sql('insert1', 'INSERT INTO test VALUES(0, \'String0\')'); set_sql('insert2', 'INSERT INTO test VALUES(1, \'String1\')'); set_sql('insert3', 'INSERT INTO test VALUES(2, \'String2\')');
http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_001.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_001.inc diff -u php-src/ext/pdo/tests/pdo_001.inc:1.3 php-src/ext/pdo/tests/pdo_001.inc:1.4 --- php-src/ext/pdo/tests/pdo_001.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_001.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_002.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_002.inc diff -u php-src/ext/pdo/tests/pdo_002.inc:1.3 php-src/ext/pdo/tests/pdo_002.inc:1.4 --- php-src/ext/pdo/tests/pdo_002.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_002.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_003.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_003.inc diff -u php-src/ext/pdo/tests/pdo_003.inc:1.3 php-src/ext/pdo/tests/pdo_003.inc:1.4 --- php-src/ext/pdo/tests/pdo_003.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_003.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_004.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_004.inc diff -u php-src/ext/pdo/tests/pdo_004.inc:1.3 php-src/ext/pdo/tests/pdo_004.inc:1.4 --- php-src/ext/pdo/tests/pdo_004.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_004.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_005.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_005.inc diff -u php-src/ext/pdo/tests/pdo_005.inc:1.3 php-src/ext/pdo/tests/pdo_005.inc:1.4 --- php-src/ext/pdo/tests/pdo_005.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_005.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'AA\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'BB\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\', \'CC\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_006.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_006.inc diff -u php-src/ext/pdo/tests/pdo_006.inc:1.3 php-src/ext/pdo/tests/pdo_006.inc:1.4 --- php-src/ext/pdo/tests/pdo_006.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_006.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'A\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_007.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_007.inc diff -u php-src/ext/pdo/tests/pdo_007.inc:1.3 php-src/ext/pdo/tests/pdo_007.inc:1.4 --- php-src/ext/pdo/tests/pdo_007.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_007.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id CHAR(1) PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(\'A\', \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(\'B\', \'A\')'); set_sql('insert3', 'INSERT INTO test VALUES(\'C\', \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_008.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_008.inc diff -u php-src/ext/pdo/tests/pdo_008.inc:1.3 php-src/ext/pdo/tests/pdo_008.inc:1.4 --- php-src/ext/pdo/tests/pdo_008.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_008.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id CHAR(1) PRIMARY KEY, val VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(\'A\', \'A\')'); set_sql('insert2', 'INSERT INTO test VALUES(\'B\', \'A\')'); set_sql('insert3', 'INSERT INTO test VALUES(\'C\', \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_009.inc?r1=1.3&r2=1.4&ty=u Index: php-src/ext/pdo/tests/pdo_009.inc diff -u php-src/ext/pdo/tests/pdo_009.inc:1.3 php-src/ext/pdo/tests/pdo_009.inc:1.4 --- php-src/ext/pdo/tests/pdo_009.inc:1.3 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_009.inc Wed Mar 9 21:37:20 2005 @@ -2,11 +2,11 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(10) UNIQUE)'); +set_sql('create1', 'CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) UNIQUE)'); set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'Test1\')'); set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'Test2\')'); -set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(10))'); +set_sql('create2', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10))'); set_sql('insert4', 'INSERT INTO test VALUES(1, 0, \'A\')'); set_sql('insert5', 'INSERT INTO test VALUES(2, 1, \'B\')'); set_sql('insert6', 'INSERT INTO test VALUES(3, 2, \'C\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_010.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_010.inc diff -u php-src/ext/pdo/tests/pdo_010.inc:1.2 php-src/ext/pdo/tests/pdo_010.inc:1.3 --- php-src/ext/pdo/tests/pdo_010.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_010.inc Wed Mar 9 21:37:20 2005 @@ -2,11 +2,11 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(10) UNIQUE)'); +set_sql('create1', 'CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) UNIQUE)'); set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'Test1\')'); set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'Test2\')'); -set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create2', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert4', 'INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')'); set_sql('insert5', 'INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')'); set_sql('insert6', 'INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_011.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_011.inc diff -u php-src/ext/pdo/tests/pdo_011.inc:1.2 php-src/ext/pdo/tests/pdo_011.inc:1.3 --- php-src/ext/pdo/tests/pdo_011.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_011.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group1\')'); set_sql('insert3', 'INSERT INTO test VALUES(3, \'C\', \'Group2\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_012.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_012.inc diff -u php-src/ext/pdo/tests/pdo_012.inc:1.2 php-src/ext/pdo/tests/pdo_012.inc:1.3 --- php-src/ext/pdo/tests/pdo_012.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_012.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group2\')'); set_sql('select1', 'SELECT val, grp FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_013.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_013.inc diff -u php-src/ext/pdo/tests/pdo_013.inc:1.2 php-src/ext/pdo/tests/pdo_013.inc:1.3 --- php-src/ext/pdo/tests/pdo_013.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_013.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group2\')'); set_sql('select1', 'SELECT val, grp FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_014.inc?r1=1.2&r2=1.3&ty=u Index: php-src/ext/pdo/tests/pdo_014.inc diff -u php-src/ext/pdo/tests/pdo_014.inc:1.2 php-src/ext/pdo/tests/pdo_014.inc:1.3 --- php-src/ext/pdo/tests/pdo_014.inc:1.2 Sat Feb 26 10:35:41 2005 +++ php-src/ext/pdo/tests/pdo_014.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +set_sql('create', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'Group1\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'B\', \'Group2\')'); set_sql('select1', 'SELECT val, grp FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_015.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_015.inc diff -u php-src/ext/pdo/tests/pdo_015.inc:1.1 php-src/ext/pdo/tests/pdo_015.inc:1.2 --- php-src/ext/pdo/tests/pdo_015.inc:1.1 Sun Feb 27 17:32:11 2005 +++ php-src/ext/pdo/tests/pdo_015.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE test(id int PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(20))'); +set_sql('create1', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(20))'); set_sql('insert1', 'INSERT INTO test VALUES(1, \'A\', \'A2\')'); set_sql('insert2', 'INSERT INTO test VALUES(2, \'A\', \'B2\')'); set_sql('select1', 'SELECT id, val, val2 FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_016.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_016.inc diff -u php-src/ext/pdo/tests/pdo_016.inc:1.1 php-src/ext/pdo/tests/pdo_016.inc:1.2 --- php-src/ext/pdo/tests/pdo_016.inc:1.1 Thu Mar 3 20:29:27 2005 +++ php-src/ext/pdo/tests/pdo_016.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE test(idx int PRIMARY KEY, txt VARCHAR(20))'); +set_sql('create1', 'CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); set_sql('insert1', 'INSERT INTO test VALUES(0, \'String0\')'); set_sql('insert2', 'INSERT INTO test VALUES(1, \'String1\')'); set_sql('insert3', 'INSERT INTO test VALUES(2, \'String2\')'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_018.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_018.inc diff -u php-src/ext/pdo/tests/pdo_018.inc:1.1 php-src/ext/pdo/tests/pdo_018.inc:1.2 --- php-src/ext/pdo/tests/pdo_018.inc:1.1 Mon Mar 7 17:36:11 2005 +++ php-src/ext/pdo/tests/pdo_018.inc Wed Mar 9 21:37:20 2005 @@ -54,13 +54,13 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE classtypes(id int PRIMARY KEY, name VARCHAR(20) UNIQUE)'); +set_sql('create1', 'CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(20) UNIQUE)'); set_sql('insert1', 'INSERT INTO classtypes VALUES(0, \'stdClass\')'); set_sql('insert2', 'INSERT INTO classtypes VALUES(1, \'TestBase\')'); set_sql('insert3', 'INSERT INTO classtypes VALUES(2, \'TestDerived\')'); set_sql('selectC', 'SELECT COUNT(*) FROM classtypes'); set_sql('select0', 'SELECT id, name FROM classtypes ORDER by id'); -set_sql('create2', 'CREATE TABLE test(id int PRIMARY KEY, classtype int, val VARCHAR(255))'); +set_sql('create2', 'CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(255))'); set_sql('insert4', 'INSERT INTO test VALUES(:id, :classtype, :val)'); set_sql('select1', 'SELECT id FROM classtypes WHERE name=:cname'); set_sql('select2', 'SELECT test.val FROM test'); http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_019.inc?r1=1.1&r2=1.2&ty=u Index: php-src/ext/pdo/tests/pdo_019.inc diff -u php-src/ext/pdo/tests/pdo_019.inc:1.1 php-src/ext/pdo/tests/pdo_019.inc:1.2 --- php-src/ext/pdo/tests/pdo_019.inc:1.1 Mon Mar 7 17:43:27 2005 +++ php-src/ext/pdo/tests/pdo_019.inc Wed Mar 9 21:37:20 2005 @@ -2,7 +2,7 @@ require_once('pdo.inc'); -set_sql('create1', 'CREATE TABLE test(idx int PRIMARY KEY, txt VARCHAR(20))'); +set_sql('create1', 'CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); set_sql('insert1', 'INSERT INTO test VALUES(0, \'String0\')'); set_sql('insert2', 'INSERT INTO test VALUES(1, \'String1\')'); set_sql('insert3', 'INSERT INTO test VALUES(2, \'String2\')');