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

[Jess Robinson]

On Thu, 26 Apr 2007, SHAD0WRUNNER at gmx.de 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