https://bugs.documentfoundation.org/show_bug.cgi?id=101732
Marc Bantle <m...@rcie.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #3 from Marc Bantle <m...@rcie.de> ---
As far as I understand, the settings in bug 81213#c4 applies to the "as" before
table aliases, such as
select * from TableName TableAlias
vs.
select * from TableName as TableAlias
It's a commonly known problem that different DBMS require different handling of
"AS" before table aliases. The related changes also suggest that it applies to
table aliases only.
Nothing the less I tried the setting. It did not fix the problem.
This bug here applies to the "as" before column aliases, such as
select ColumnName ColumnAlias from TableName
vs.
select ColumnName as ColumnAlias from TableName
Sofar I'm not aware of any DBMS that cannot handle the "AS" before a
ColumnAlias. On the other hand it seems reasonable to strip the syntax, where
possible. Unfortunately here it causes problems.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs