On Thu, 26 Apr 2007, [EMAIL PROTECTED] wrote:
Hello,
in January there was a discussion about "as"-statementes in group by
for instance
SELECT * FROM
(
SELECT A.*, ROWNUM r FROM
(
SELECT myCol AS col1 FROM table
GROUP BY myCol AS col2
) A
WHERE ROWNUM < 4
) B
WHERE r >=3D 1
Is this issue allready fixed?
Matt S Trout mentioned a patch for this, where can I find this?
Regards
Dieter
No idea if it is, but try looking in DBIx::Class::Storage::DBI::Oracle, or
at the _RowNumberOver for DB2 in DBIx::Class::Storage::DBI.
Jess
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
