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
MIME-Version: 1.0
X-Mailer: MIME-tools 5.418 (Entity 5.418)
Content-Type: text/plain
Charset: utf8
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 678
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