Have tested this also.
Build two tables for the content I guessed by the given example.
Copied the query in a Base-query.
Could only execute the query in direct SQL-Mode, not in GUI-Mode. Think this is what you mean with "query works fine ...".
Now I took the query and created a view from this query.
View works the same way the query works.
So I could not confirm the described bug.
My System: OpenSUSE 13.2, 64bit rpm Linux, different LO-versions
Have tested this also.
Build two tables for the content I guessed by the given example.
Copied the query in a Base-query.
Could only execute the query in direct SQL-Mode, not in GUI-Mode. Think this is what you mean with "query works fine ...".
Now I took the query and created a view from this query.
View works the same way the query works.
So I could not confirm the described bug.
My System: OpenSUSE 13.2, 64bit rpm Linux, different LO-versions