https://bugs.documentfoundation.org/show_bug.cgi?id=141579
--- Comment #3 from [email protected] --- Table aliasing cannot be disabled in Base. I have experimented with LO 25.2 on Windows 11 and on OpenSuSe LO 24.8.1.2. LO Base Query Builder on ODBC and JDBC connections do not display the same behaviour when creating the SQL query targeted at the Rocket UniVerse database. The description on the original bug report is still valid but the detail below may provide clarity on what LO is doing and what is expected when Advanced Settings related to the use of aliases are used. Observed Behavior (Updated) Even when “Append table alias name on SELECT statements” is unchecked, LibreOffice still appends an alias to the table name — just without the AS keyword. Example: SELECT "FIELD1" FROM "MYTABLE" "MYTABLE" This is still interpreted by some SQL engines (e.g. UniVerse) as invalid syntax: syntax error. Unexpected filename. Token was "MYTABLE". Only the setting “Use keyword AS before table alias names” toggles the AS, but not the aliasing itself. 🔧 Corrected Expectation If both: "Append table alias name on SELECT statements" is unchecked "Use keyword AS before table alias names" is unchecked Then the SQL should render: SELECT "FIELD1" FROM "MYTABLE" — with no alias at all. However, if a table is opened directly in the UI by "opening" a table, the query that is created by this action does not, apparently, use aliasing as the table rows are returned without error into the LO grid. I have not been able to view the actual query that is created and submitted to the database server when doing this. -- You are receiving this mail because: You are the assignee for the bug.
