Skip Menu |

This queue is for tickets about the SQL-Statement CPAN distribution.

Report information
The Basics
Id: 61384
Status: resolved
Priority: 0/
Queue: SQL-Statement
People
Owner: Nobody in particular
Requestors: jmv [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 1.26
Fixed in: (no value)

History Show all quoted text
  Thu Sep 16 02:19:12 2010 jmv [...] cpan.org - Ticket created
Subject: 1.26 + breaks usage of column alias in order by
SELECT A.id, B.name AS aliasname FROM TABLEA A, TABLEB B WHERE A.id = B.id ORDER BY aliasname works in 1.15 fails in 1.26 and later
  Thu Sep 16 16:55:38 2010 REHSACK [...] cpan.org - Correspondence added
On Thu Sep 16 02:19:12 2010, JMV wrote: Show quoted text
> SELECT A.id, B.name AS aliasname FROM TABLEA A, TABLEB B > WHERE A.id = B.id ORDER BY aliasname > > works in 1.15 > fails in 1.26 and later
I'll prove that. If you open such reports, it's great when you add a test case which could simply executed and demonstrates the issue. Not that it's difficult to create such a one for the maintainer, but typically they have more than one module and the chance for EHEADELSEWHERE is big. Thanks for reporting, Jens
  Thu Sep 16 16:55:39 2010 The RT System itself - Status changed from 'new' to 'open'
  Sat Jan 15 06:07:41 2011 REHSACK [...] cpan.org - Correspondence added
Fixed in 1.31_001 and upcoming 1.32.
  Sat Jan 15 06:07:42 2011 REHSACK [...] cpan.org - Status changed from 'open' to 'resolved'