Fix ORA-01442: column to be modified to NOT NULL is already NOT NULL

[dbsrgits/SQL-Translator.git] / t / 54-oracle-alter-field.t

diff --git a/t/54-oracle-alter-field.t b/t/54-oracle-alter-field.t
index c8cd4b9..c4f4584 100644 (file)
--- a/t/54-oracle-alter-field.t
+++ b/t/54-oracle-alter-field.t
@@ -9,7 +9,7 @@ use SQL::Translator;
 use SQL::Translator::Diff;
 
 BEGIN {
-    maybe_plan(2, 'SQL::Translator::Parser::YAML',
+    maybe_plan(3, 'SQL::Translator::Parser::YAML',
                   'SQL::Translator::Producer::Oracle');
 }
 
@@ -46,5 +46,7 @@ my $d = SQL::Translator::Diff->new
 my $diff = $d->compute_differences->produce_diff_sql || die $d->error;
 
 ok($diff, 'Diff generated.');
-like($diff, '/ALTER TABLE d_operator MODIFY \( name nvarchar2\(10\) NOT NULL \)/',
+like($diff, '/ALTER TABLE d_operator MODIFY \( name nvarchar2\(10\) \)/',
+     'Alter table generated.');
+like($diff, '/ALTER TABLE d_operator MODIFY \( other nvarchar2\(10\) NOT NULL \)/',
      'Alter table generated.');