- Fixed test case to expect a column with a primary key to be not null and
contain a default value, since some RDBMS (Oracle, MySQL, Postgres) ensure
this themselves.
# Tests running now again against MySQL, SQLite and Postgres
git-svn-id: https://svn.apache.org/repos/asf/incubator/zetacomponents/trunk@978713 13f79535-47bb-0310-9956-ffa450edef68
diff --git a/DatabaseSchema/tests/generic_diff_test.php b/DatabaseSchema/tests/generic_diff_test.php
index 670a3bb..f5dc341 100644
--- a/DatabaseSchema/tests/generic_diff_test.php
+++ b/DatabaseSchema/tests/generic_diff_test.php
@@ -145,7 +145,7 @@
),
'bugdb_change' => new ezcDbSchemaTable(
array (
- 'group' => new ezcDbSchemaField( 'integer' ),
+ 'group' => new ezcDbSchemaField( 'integer', false, true, 0 ),
'table' => new ezcDbSchemaField( 'integer' ),
),
array (
diff --git a/DatabaseSchema/tests/mysql_diff_test.php b/DatabaseSchema/tests/mysql_diff_test.php
index f5cc4b5..9fe0169 100644
--- a/DatabaseSchema/tests/mysql_diff_test.php
+++ b/DatabaseSchema/tests/mysql_diff_test.php
@@ -73,7 +73,7 @@
0 => "ALTER TABLE `bugdb_change` DROP INDEX `join`",
1 => "ALTER TABLE `bugdb_change` DROP INDEX `primary`",
2 => "ALTER TABLE `bugdb_change` DROP `from`",
- 3 => "ALTER TABLE `bugdb_change` ADD `group` bigint",
+ 3 => "ALTER TABLE `bugdb_change` ADD `group` bigint NOT NULL DEFAULT 0",
4 => "ALTER TABLE `bugdb_change` ADD PRIMARY KEY ( `group` )",
5 => "ALTER TABLE `bugdb_change` ADD UNIQUE `from` ( `table` )",
6 => "CREATE TABLE `order` (\n\t`right` bigint\n)",
diff --git a/DatabaseSchema/tests/oracle_diff_test.php b/DatabaseSchema/tests/oracle_diff_test.php
index 7b4314f..a9b5c2e 100644
--- a/DatabaseSchema/tests/oracle_diff_test.php
+++ b/DatabaseSchema/tests/oracle_diff_test.php
@@ -64,7 +64,7 @@
0 => 'DROP INDEX "join"',
1 => 'ALTER TABLE "bugdb_change" DROP CONSTRAINT "bugdb_change_pkey"',
2 => 'ALTER TABLE "bugdb_change" DROP COLUMN "from"',
- 3 => 'ALTER TABLE "bugdb_change" ADD "group" number',
+ 3 => 'ALTER TABLE "bugdb_change" ADD "group" number DEFAULT 0 NOT NULL',
4 => 'ALTER TABLE "bugdb_change" ADD CONSTRAINT "bugdb_change_pkey" PRIMARY KEY ( "group" )',
5 => 'CREATE UNIQUE INDEX "from" ON "bugdb_change" ( "table" )',
6 => "CREATE TABLE \"order\" (\n\t\"right\" number\n)",
diff --git a/DatabaseSchema/tests/pgsql_diff_test.php b/DatabaseSchema/tests/pgsql_diff_test.php
index f1a5022..4f0e056 100644
--- a/DatabaseSchema/tests/pgsql_diff_test.php
+++ b/DatabaseSchema/tests/pgsql_diff_test.php
@@ -64,7 +64,7 @@
0 => 'DROP INDEX "join"',
1 => 'ALTER TABLE "bugdb_change" DROP CONSTRAINT bugdb_change_pkey',
2 => 'ALTER TABLE "bugdb_change" DROP "from"',
- 3 => 'ALTER TABLE "bugdb_change" ADD "group" bigint',
+ 3 => 'ALTER TABLE "bugdb_change" ADD "group" bigint NOT NULL DEFAULT 0',
4 => 'ALTER TABLE "bugdb_change" ADD CONSTRAINT "bugdb_change_pkey" PRIMARY KEY ( "group" )',
5 => 'CREATE UNIQUE INDEX "from" ON "bugdb_change" ( "table" )',
6 => "CREATE TABLE \"order\" (\n\t\"right\" bigint\n)",
diff --git a/DatabaseSchema/tests/sqlite_diff_test.php b/DatabaseSchema/tests/sqlite_diff_test.php
index 7cede33..35ce007 100644
--- a/DatabaseSchema/tests/sqlite_diff_test.php
+++ b/DatabaseSchema/tests/sqlite_diff_test.php
@@ -76,7 +76,7 @@
0 => "DROP INDEX 'join'",
1 => "DROP INDEX 'bugdb_change_pri'",
2 => "ALTER TABLE 'bugdb_change' DROP COLUMN 'from'",
- 3 => "ALTER TABLE 'bugdb_change' ADD 'group' integer",
+ 3 => "ALTER TABLE 'bugdb_change' ADD 'group' integer NOT NULL DEFAULT 0",
4 => "CREATE UNIQUE INDEX 'bugdb_change_pri' ON 'bugdb_change' ( 'group' )",
5 => "CREATE UNIQUE INDEX 'from' ON 'bugdb_change' ( 'table' )",
6 => "CREATE TABLE 'order' (\n\t'right' integer\n)",
