Skip Menu |

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

Report information
The Basics
Id: 93411
Status: open
Priority: 0/
Queue: DBIx-Class
People
Owner: Nobody in particular
Requestors: nygel [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 0.08270
Fixed in: (no value)
Attachments
Test.zip

History Show all quoted text
  Thu Feb 27 11:30:01 2014 nygel [...] cpan.org - Ticket created
Subject: Paged Resultsets unable to return rows due to LIMIT/OFFSET ranges
1) Paging a resultset adds offset/limit to the (to be) generated SQL. 2) $self in a resultset refers to the resultset. 3) $self->find($an_id_in_the_resultset); in the resultset triggers the SQL generation SQL on pages 2 and above, will be as follows (page 1 omits the offset causing the bug not to manifest) : SELECT me.id FROM stuff me WHERE ( me.id = ? ) LIMIT ? OFFSET ?: '5', '4', '4' The specific issue is that the SQL server will apply the where clause BEFORE the limit/offset, this causes the SQL to return no results despite the id in question being in the original resultset. Have attached a test case illustrating the issue.
Subject: Test.zip
Download Test.zip
application/zip 3k

Message body not shown because it is not plain text.

  Sun Jan 28 12:11:22 2018 ribasushi [...] leporine.io - Correspondence added
On Thu Feb 27 17:30:01 2014, NYGEL wrote: Show quoted text
> > The specific issue is that the SQL server will apply the where clause > BEFORE the limit/offset, this causes the SQL to return no results > despite the id in question being in the original resultset.
Hi! It has been 4 years since this bug was filed, but on the off-chance it is still relevant: I must say: in general... everything seems to function as designed. Perhaps I am misunderstanding the issue... maybe it manifests on SQL Server only and not on SQLite? If you are still working on the codebase in question - let me know your thoughts!
  Sun Jan 28 12:11:22 2018 The RT System itself - Status changed from 'new' to 'open'