Bug 598668

Summary:	app-office/libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view
Product:	Gentoo Linux	Reporter:	Jimis Hol <jimishol>
Component:	Current packages	Assignee:	Gentoo Linux bug wranglers <bug-wranglers>
Status:	RESOLVED UPSTREAM
Severity:	normal	CC:	jstein
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Jimis Hol 2016-11-01 09:15:04 UTC

libreoffice version 5.2.2.2

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.

Comment 1 Jimis Hol 2016-11-01 09:33:48 UTC

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 opened the query in design view and try in there the SQL view the problem appears again.

Comment 2 Jonas Stein gentoo-dev

2016-11-01 16:37:20 UTC

To me it sounds like a bug in the software provided upstream.
I will close this bug here, because I do not see a relation to the gentoo ebuild or the way gentoo handles this special software package. Please provide more information, if I am wrong.

Comment 3 Jimis Hol 2016-11-08 15:00:50 UTC

Just for the shake of completion. 
The problem was that

since I'm Greek I had user interface in greek language. As soon as I choosed from Tools/Options/Language Settings/User interface: English (USA)
the problem disappeared both on debian and gentoo