[Dbix-class] Oracle, distinct and rows/limit

SHAD0WRUNNER at gmx.de SHAD0WRUNNER at gmx.de
Thu Apr 26 12:38:03 GMT 2007


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

-- 
FastJack

"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail



More information about the Dbix-class mailing list