https://bugs.documentfoundation.org/show_bug.cgi?id=169424
--- Comment #3 from Neil Roberts <[email protected]> --- Oh ok, I didn’t realise that HSQLDB doesn’t support natural joins. So yeah, it should probably stop you from trying to make a natural join with the UI (or even better figure out what the join columns should be and translate the SQL into a normal join!). However, I think that is a separate problem because: * The bug happens if even before Base sends the query to the database backend. It’s a problem of the UI code not being able to interpret the SQL statement in order to recreate the design view. * It works fine if the join is only between two tables, although if you actually try to execute it with the HSQLDB backend then it does something weird. * The same bug happens with the MariaDB backend. With that backend you can’t toggle between design and SQL view, but you can execute the query successfully. -- You are receiving this mail because: You are the assignee for the bug.
