-------- Original-Nachricht --------
Datum: Thu, 26 Apr 2007 22:03:32 +0100 (BST)
Von: Jess Robinson <[EMAIL PROTECTED]>
An: [email protected]
Betreff: Re: [Dbix-class] Oracle, distinct and rows/limit
>
>
>
> 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
>
THX a lot for your hint with DBIx::Class::Storage::DBI
and RowNumberOver.
I tried:
$source->storage->sql_maker->limit_dialect('RowNumOver');
and now it seems to work. 'RowNum' is used as default for Oracle.
Greetz
Dieter
--
FastJack
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
_______________________________________________
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]/
