[Dbix-class] 0.08103 - call for testers!

Peter Rabbitson rabbit+dbic at rabbit.us
Wed May 20 10:27:22 GMT 2009


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.



More information about the DBIx-Class mailing list