Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 103996
Status: open
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: rrwo [...] thermeon.com
Cc:
AdminCc:

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



Subject: emulate limit for Genesis SQL dialect
Date: Mon, 27 Apr 2015 11:26:16 +0100
To: bug-DBIx-Class [...] rt.cpan.org
From: Robert Rothenberg <rrwo [...] thermeon.com>
Download (untitled) / with headers
text/plain 894b
When using rows to limit SQL we get the warning: Show quoted text
> DBIx::Class::SQLMaker::select(): Support for the legacy emulate_limit() > mechanism inherited from SQL::Abstract::Limit has been deprecated, and > will be removed when DBIC transitions to Data::Query. If your code uses > this type of limit specification please file an RT and provide the source > of your emulate_limit() implementation, so an acceptable upgrade-path can > be devised
Genesis SQL's dialect uses SELECT TOP n sub emulate_limit { my ($self, $sql, $rs_attrs, $rows, $offset) = @_; $sql =~ s/^ \s* SELECT \s+ //ix or $self->throw_exception("Unrecognizable SELECT: $sql"); return sprintf ('SELECT %s%s%s%s', $offset ? sprintf('SKIP %u ', $offset) : '' , sprintf('TOP %u ', $rows) , $sql, $self->_parse_rs_attrs ($rs_attrs), ); }
Download (untitled) / with headers
text/plain 638b
On Mon Apr 27 12:26:33 2015, rrwo@thermeon.com wrote: Show quoted text
> When using rows to limit SQL we get the warning: >
> > DBIx::Class::SQLMaker::select(): Support for the legacy emulate_limit() > > mechanism inherited from SQL::Abstract::Limit has been deprecated, and > > will be removed when DBIC transitions to Data::Query. If your code uses > > this type of limit specification please file an RT and provide the source > > of your emulate_limit() implementation, so an acceptable upgrade-path can > > be devised
> > Genesis SQL's dialect uses >
Hi! This bug fell between the floorboards. Is it still relevant to you 3 years later? Thanks!


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.