Subsonic 2.1 fail to do an inner join on column has ON DELETE CASCADE trigger set up

Question

Hi All,

I am having problem to do inner join on column has ON DELETE CASCADE trigger set . I am not sure this is a bug, wondering if anyone has seen it. EX :

query = query.InnerJoin(Addendum.Schema.Columns.GetColumn("ProductId"), Product.Schema.Columns.GetColumn("Id"))

It is just a simple inner join, it doen't work if "ProductId" column on Addendum table has ON DELETE CASCADE trigger set. It works fine if I removed the ON DELETE CASCADE trigger on this column.

Thanks, Van