use SQL::Translator::Diff;
BEGIN {
- maybe_plan(2, 'SQL::Translator::Parser::YAML',
+ maybe_plan(3, 'SQL::Translator::Parser::YAML',
'SQL::Translator::Producer::Oracle');
}
my $d = SQL::Translator::Diff->new
({
output_db => 'Oracle',
+ target_db => 'Oracle',
source_schema => $s->schema,
target_schema => $t->schema,
});
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.');