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

Reply via email to