Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: jason [...] froebe.net
Cc:
AdminCc:

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



Subject: SQL::Translator::Parser::DBI::Sybase needs to strip the carriage return from stored procs/views sql
Download (untitled) / with headers
text/plain 678b
Centos 5 Linux dba-dev1 2.6.22.9-default #1 SMP Mon Oct 1 11:26:48 CDT 2007 i686 athlon i386 GNU/Linux Perl v5.8.8 built for i386-linux-thread-multi SQL::Translator::0.09000 Sybase ASE will often store the SQL text for stored procedures and views with the carriage return embedded (\r). We need to strip that out else we will receive "^M" in the output. Sybase_orig.pm Sybase_new.pm 108a109 Show quoted text
>
109a111,112 Show quoted text
> $stuff->{view}->{$_->[0]}->{text} =~ s/\r//g > if (defined ($stuff->{view}->{$_->[0]}->{text}));
155a159,161 Show quoted text
> $stuff->{procedures}->{$_->[0]}->{text} =~ s/\r//g > if (defined ($stuff->{procedures}->{$_->[0]}->{text} )); >


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.