Jose Luis Martinez wrote: > > DBIx::Class::ResultSet::count(): DBI Exception: DBD::mysql::st execute > failed: Duplicate column name 'subscriber_id' [for Statement "SELECT > COUNT( * ) FROM (SELECT me.subscriber_id, > subscribers_data.subscriber_id, subscribers_data.c001 FROM subscribers > me JOIN subscribers_data subscribers_data ON > subscribers_data.subscriber_id = me.subscriber_id GROUP BY > me.subscriber_id ORDER BY me.subscriber_id desc) count_subq"] > > Looks like prefetch is the cause. If I comment it out, everything works > again (with performance penalty of no prefetch :(). > The sub-select from the error works OK on it's own, but when you > surround it in the count(*) FROM (...), mysql doesn't like the two > columns called "subscriber_id" in the subselect :(. > > New bug? Shot myself in the foot?
This was reported on IRC and fixed. A new RC will be rolled-up later today. _______________________________________________ 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/[email protected]
