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

Owner: Nobody in particular
Requestors: jason [...]

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 #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. 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 infrastructure.

Please report any issues with to