| Subject: | SQL::Translator::Producer::Oracle - creating trigger for NULL timestamps |
Hi,
SQL::Translator::Producer::Oracle was creating trigger to set sysdate if
the value was NULL even when $field->is_nullable was set. I had to
change this:
--- Oracle.pm.orig 2008-02-28 23:36:18.000000000 +0100
+++ Oracle.pm 2008-05-30 15:31:55.000000000 +0200
@@ -348,7 +348,7 @@
;
}
- if ( lc $field->data_type eq 'timestamp' ) {
+ if ( (lc $field->data_type eq 'timestamp') and
(!$field->is_nullable) ) {
my $base_name = $table_name_ur . "_". $field_name_ur;
my $trig_name = mk_name( $base_name, 'ts' );
push @trigger_defs,
Regards,
Jozef