#11 Using 3 Inner Joins Causes a Crash

[Christopher K. Lester]

This query has 3 inner joins:

select * from invoices_memberships
inner join members on invoices_memberships.id.member_id = members.id.user_id
inner join member_addresses on invoices_memberships.id.member_id = member_addresses.id.member_id
inner join users on invoices_memberships.id.member_id = users.uid
where invoices_memberships.trans_type in (1,2,12)

It generates the attached ex.err file when run either through wxEDB or via code.

(This also crashes when I spell out all the fields (instead of using '*' I use the appropriate field names).)

In part:

c:/eu_includes/eusql/eusql.e:4951 in function intersect_recursive()
attempt to subscript an atom
(reading from it)
a = {
{
205,
{2008,11,30,16,29,50'2'}
}
}
rec = {205}
levels = 1
r = <no value>
result = {{}}
reslen = 0
i = <no value>
j = <no value>
i = 1

[Christopher K. Lester]

[Matt Lewis]

The join logic assumes that the joins are "chained" together instead of all being joined to a central table.