https://bugs.documentfoundation.org/show_bug.cgi?id=103736
Bug ID: 103736
Summary: libreoffice-5.2.2.2 AVG function produces SQL syntax
error in query design view
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
libreoffice version 5.2.2.2 on gentoo-testing
When designing query with librebase then
average AVG function in query design view, produces a syntax error and one can
not run query, save or go to SQL view.
A work around is to use MAX function instead, go to SQL view, change by hand
the MAX to AVG and save without going to design view again.
Using wizard for creating query the AVG function does not produce any errors
and query is saved and running successfully. you can see it by opening it
directly in SQL.
But again if you open the query in design view and try in there the SQL view
the problem appears again.
Same behavior with libreoffice-4.3.3.2 on debian-jessie
the error says something (i translate from greek)
Status SQL: HY000
error: 1000
syntax error, unexpected $end, expecting
BETWEEN or IN or SQL_TOKEN_LIKE
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
