Perfectly valid MySQL query gives syntax error in LibreOffice Base (was: the other way around)

[Keith Clark]

On Fri, 2011-05-20 at 23:52 +0200, Amedee Van Gasse wrote:
> On 05/20/11 23:44, Amedee Van Gasse wrote:
> 
> > Same query, rewritten from scratch:
> >
> > SELECT YEAR(logfiledate) AS Year, MONTH(logfiledate) AS Month, UserId,
> > Name, FirstName, Cat, SUM(TotalTime) AS TotalTime
> > FROM Sessions
> > LEFT JOIN Logfiles on Sessions.LogFile = Logfiles.logfile
> > LEFT JOIN Users on UserId = Trigram
> > WHERE YEAR(logfiledate) = 2010
> > AND MONTH(Logfiles.logfiledate) = 12
> > GROUP BY UserId
> > ORDER BY TotalTime DESC, UserId ASC
> > LIMIT 0, 10
> >
> > Much cleaner, methinks.
> > Thanks to all who contributed, or for just being my wall.
> > Case closed.
> 
> Case not entirely closed.
> Now I have a perfectly valid MySQL query, verified with phpMyAdmin, and 
> LibreOffice Base claims that I have syntax terror in SQL expression.
> 
> I think I'll have to file that bug report after all...
> 
I might be wrong, but when using Base for MySQL connectivity you have to
use the ` quotes.  If using the HSQL, you use the " quotes.  It has been
awhile since I used Base but I seem to remember that frustrating me a
lot when trying to use it for quick development of SQL code and then
copy pasting that into phpMyAdmin.