https://bugs.documentfoundation.org/show_bug.cgi?id=141579
--- Comment #2 from [email protected] --- This bug still occurs at LibreOffice version 7.4.3.2 on OpenSuse leap 15.5 and Windows 10 To summarise: In LibreOffice Base when using Edit\Database\Advanced Settings there is an option to select/de-select "Append the table alias name on SELECT statements" as well the option "Use keyword AS before table alias names" Even when these options are "not" checked the resulting SQL query includes the aliasing of the table being selected with same name. EG: SELECT "AT_ID", "NAME1" FROM "CM" "CM" The only option related to using a table alias that is honoured is the "Use keyword AS before table alias names" When "Append the table alias name on SELECT statements" is "not" checked and and "Use keyword AS before table alias names" "is" checked: SELECT "AT_ID", "NAME1" FROM "CM" AS "CM" >From this one can deduce that the option "Append the table alias name on SELECT statements" is being ignored. The database using this JDBC driver requires that if a table is aliased it be to a unique name eg T1.CM - this is commonly done in many BI tools as well Because the options are not being honoured the query has to be manually edited to remove the alias. This can get complex when there many tables in the query. -- You are receiving this mail because: You are the assignee for the bug.
