https://bugs.documentfoundation.org/show_bug.cgi?id=83454
--- Comment #34 from Lionel Elie Mamane <[email protected]> --- Fundamentally, we have to set one of the behaviours as default: either putting the AS or not putting it, and people that need the opposite from the default must set the behaviour they require in the advanced options. It seems to me that since the vast majority of DBMS work fine without the "AS", and a sizeable amount require the *absence* of the AS, not putting the "AS" is the correct default, as we did in 2014 in issue 81213, as that will give maximum compatibility. If I recall correctly, not putting the "AS" is the SQL standard conformant behaviour, but my memory might be corrupted on that. If (with the caveats in comment 33 for proper testing) the checkbox in the "advanced settings" do not work, and LibreOffice does NOT put the "AS" even though the checkbox telling it to do so is checked, then *that* is the bug that needs to be corrected, not changing the default back and forth each time a user files a bug... -- You are receiving this mail because: You are the assignee for the bug.
