Skip Menu |
 

This queue is for tickets about the TheSchwartz CPAN distribution.

Report information
The Basics
Id: 58049
Status: resolved
Priority: 0/
Queue: TheSchwartz

People
Owner: Jeff.Fearn [...] gmail.com
Requestors: gonullu [...] bluewin.ch
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 1.11



Subject: get_server_time with Oracle
Download (untitled) / with headers
text/plain 822b
Hi, get_server_time will not work under Oracle because of the missing " FROM DUAL". I thought to make the change in Data::ObjectDriver::Driver::DBD::Oracle sql_for_unixtime but then I realized that this method is supposed to return an integer and not a string so I made the following change --- /home/sag/ROOT/lib/perl5/lib/perl5/TheSchwartz.pm.orig 2010-06-02 13:20:53.520219069 +0200 +++ /home/sag/ROOT/lib/perl5/lib/perl5/TheSchwartz.pm 2010-06-02 13:19:31.164714180 +0200 @@ -305,6 +305,7 @@ my TheSchwartz $client = shift; my($driver) = @_; my $unixtime_sql = $driver->dbd->sql_for_unixtime; + $unixtime_sql .= $driver->dbd->isa('Data::ObjectDriver::Driver::DBD::Oracle') ? ' FROM DUAL': ''; return $driver->rw_handle->selectrow_array("SELECT $unixtime_sql"); } Regards, -salih
Download (untitled) / with headers
text/plain 111b
Applied. To git@github.com:jfearn/TheSchwartz.git e89b55f..69af856 master -> master Thanks for the patch!
A fix for this issue shipped in Version 1.11.


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.