Greetings!
After upgrading the DBIx::Class package from 8.0127 to 8.0196 the problem
occurs in using
select attribute of a ResultSet with DISTINCT qualifier.
I used the syntax
my $rs_2 = $rs->search({},
{
select => ['DISTINCT searchable_id', "dense_rank() OVER (ORDER BY
$order_by) AS pos" ],
as => ['searchable_id', 'pos'],
}
);
$order_by clause is calculated separately and above.
I get an error
=======
DBIx::Class::ResultSet::next(): DBI Exception: DBD::Pg::st execute failed:
ERROR: column me.distinct does not exist
[Mon Jun 10 17:33:22 2013] [error] LINE 1: SELECT me.pos FROM (SELECT
me.DISTINCT searchable_id, dense_rank()...
=======
For this particular query I can avoid DISTINCT, but what should I do not ot
get this error?
Thank you!
--
SY, Dmitry Belyavsky
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
