https://bugs.freedesktop.org/show_bug.cgi?id=81213
--- Comment #2 from Lionel Elie Mamane <[email protected]> --- (In reply to comment #1) > Lionel: searching "AS" in reportbuilder module gives 2 relevant locations: > http://opengrok.libreoffice.org/xref/core/reportbuilder/java/org/libreoffice/ > report/SDBCReportDataFactory.java#559 + line 565 of this same file. > > Should we just remove this "AS" since it's optional for most (all?) RDBMS > and illegal at least for Oracle? Yes, please do that. However, I think it will not be enough, since this is a backup code branch that I've only ever seen taken with gcj (never with Sun/Oracble Java). > BTW: I can make the change obviously but not test it. Activate the database's query logging, you'll see the queries sent to the database. I don't think this is per se related to the report builder (except the locations you linked to), the report builder does not really create queries. It gets a query as a parameter (the data source), and modifies it a bit (to add/remove ORDER BY clauses for sorting, GROUP BY clauses for groupings, etc, etc). But AFAIK it does that through a query composer UNO service. So the soure of the stuff is most probably from our general query designer / composer. That can be tested by creating a query with the query designer and switching to SQL view. Should be in dbaccess/source/ui/querydesign/ and/or dbaccess/source/core/api/SingleSelectQueryComposer.cxx and/or in dbaccess/source/core/api/querycomposer.cxx. I'd be most happy if you took care of this. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
