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

[Amedee Van Gasse]

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...