[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