https://bugs.freedesktop.org/show_bug.cgi?id=82325
Priority: medium
Bug ID: 82325
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: query builder should seek input concerning what table
operation should be done first
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: dougt901-2...@yahoo.com
Hardware: Other
Status: UNCONFIRMED
Version: 4.3.0.4 release
Component: Database
Product: LibreOffice
With LEFT JOIN and RIGHT JOIN, it matters what table operation is performed
first. Query builder is not as good at figuring out what goes first, and if
there are more that two tables it seems not good at creating a plan for the
SQL. Consider having the builder allow user to group tables from left to right
or top to bottom to give visual cues to builder what table operation should be
performed first.
Presently, where multiple tables and joins are concerned, only way to ensure
desired sequence of execution is to save multiple layered queries, one
referencing the other. That leads to too many saved queries. Instead,
consider giving user finer control in context of one query (or getting better
SQL plans when more than two LEFT or RIGHT JOIN relationships are in play.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
