(A & B) * B results in an error

[eywalker]

Currently the following query:

(A & B) * B

throws an error like:

Cannot join relations on dependent attribute `xxx`

where xxx is a non-primary key attribute of the relation B

[dimitri-yatsenko]

Reproduced and understood. It's because it tries to optimize (A & B) * B as A * B & B to avoid an extra subquery. This has to do with rules of query optimization. We need to add this to tests.

[eywalker]

Yeah I thought so but isn't it weird then that the error message says there is an issue with join? I would have expected error about restricting with dependent attribute