Problem with recursive inner joins about rom-sql HOT 6 CLOSED

Is this your actual use-case? Nested Set Model would probably be a better fit if you need to return a subset of child nodes.

As for the issue, I haven't tested it but try calling #inner_join with something like: inner_join("nodes AS nodes_#{index}")

from rom-sql.

Yes this is a real use-case. I know the nested set model, but here the scenario is a bit different. Usually one node needs to be selected, which is identified by a composite key, based on parent nodes. Thus the most natural (but not most efficient) way of identifying the node is via path of its parents.

from rom-sql.

OK, cool, did you try the suggested fix at all?

from rom-sql.

A different error is reported:

PG::UndefinedTable: ERROR:  relation "nodes as nodes_1" does not exist (Sequel::DatabaseError)

from rom-sql.

I'm gonna close this one since it is not a bug. It's possible to build a query like that, but using a slightly different approach (I'll try to show how and post it on our forum in the related thread).

from rom-sql.

Ok, I'm looking forward to see the solution. Thanks.

from rom-sql.