Skip Menu |

This queue is for tickets about the TheSchwartz CPAN distribution.

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

Owner: Jeff.Fearn [...]
Requestors: gonullu [...]

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/ 2010-06-02 13:20:53.520219069 +0200 +++ /home/sag/ROOT/lib/perl5/lib/perl5/ 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 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 infrastructure.

Please report any issues with to