On Fri, 27 Apr 2007, "Dieter Späth" wrote:
-------- 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.
Shiney, care to patch it so that it always uses that one for Oracle?
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]/
