[Catalyst] has_many but no left join?!

[Stephen Shorrock]

Hi,

I was wondering if anyone could offer some insight into a problem I'm
finding.  I wish to create a relationship using a left join by this doesn't
appear to be happening when I trace the SQL. My only thought is that it is
something to do with using a 'table' without a primary key or whose
underlying database object is actually not a table but a view?

The example class  / relationship below doe snot produce  a left join, but
would have thought it aught to:

package MyApp::Schema::Result::IndexStatus;

__PACKAGE__->table("index_statuses");

 __PACKAGE__->add_columns(
  "myindex",
  { data_type =3D> "bigint", is_nullable =3D> 0 },
  "myoldindex",
  { data_type =3D> "bigint", is_nullable =3D> 0 },
  "mystatus",
  { data_type =3D> "varchar", default_value =3D> "", is_nullable =3D> 0, si=
ze =3D>
45 },
);

#relationship to find all old index statuses:
__PACKAGE__->has_many(
   "old_statuses"=3D>"MyApp::IndexStatus",
    { "foreign.myindex" =3D> "self.myoldindex"},
);


----
then (in Cat app)
$c->model('MyApp::IndexStatus')->search_related('old_statuses');

produces SQL something like:
SELECT me.myindex, me.myoldindex, me.mystatus FROM index_statuses me  JOIN
index_statuses old_statuses ON old_statuses.myindex =3D me.myoldindex:

even adding {join_type=3D>'LEFT'} to the arguments of has_many does not
produce a left join.

DBIx::Class has been pretty robust, I'm assuming that this is an
undocumented feature rather than a bug.  However how can I get it to do a
left join?

Thanks in advance
Stephen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20130618/4c860=
e4f/attachment.htm