Skip Menu |
 

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

Report information
The Basics
Id: 25333
Status: resolved
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: yuji [...] tamashiro.org
Cc:
AdminCc:

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



Subject: "AS" is added to GROUP BY when using slice
Download (untitled) / with headers
text/plain 651b
"AS" be added to GROUP BY when using slice. For example, when the following script is processed, the following wrong query is generated. #### Script #### my $rs = $self->resultset('artist')->search({}, {group_by => [qw( name )]}); my ($artist) = $rs->slice(0); $artist->artistid; #### Generated SQL #### SELECT * FROM ( SELECT A.*, ROWNUM r FROM ( SELECT me.artistid AS col1, me.name AS col2 FROM artist me GROUP BY name AS col3 ) A WHERE ROWNUM < 2 ) B WHERE r >= 1 * My test environment - Perl v5.8.8 built for i686-linux - DBIx::Class 0.07999_02 - DBI 1.53 - DBD::Oracle 1.19 - Oracle 9.2.0.1
I'm pretty sure this was fixed for 08000+, if not please re-open it. Thanks for the report.


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.