Skip Menu |
 

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 36301
Status: new
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: jozef [...] kutej.net
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 0.09000
Fixed in: (no value)



Subject: SQL::Translator::Producer::Oracle - creating trigger for NULL timestamps
MIME-Version: 1.0
X-Mailer: MIME-tools 5.426 (Entity 5.426)
Content-Type: text/plain
Charset: utf8
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 652
Download (untitled) / with headers
text/plain 652b
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


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.