35381: SQL::Translator::Parser::DBI::Sybase needs to strip the carriage return from stored procs/views sql
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
109a111,112
155a159,161
> $stuff->{procedures}->{$_->[0]}->{text} =~ s/\r//g
> if (defined ($stuff->{procedures}->{$_->[0]}->{text} ));
>
[...] SMP Mon Oct 1 11:26:48 CDT 2007 i686 athlon i386 GNU/Linux Perl v5.8.8 built for i386-linux-thread-http://froebe.net/blog/2008/04/24/35381-sqltranslatorparserdbisybase-needs-to-strip-the-carriage-ret…Linked by Thom Holwerda on Mon 24th Oct 2005 10:09 UTC, submitted by FreeBSD_User OS NewsRink [...]