[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Julien Nabet  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEW |RESOLVED

--- Comment #36 from Julien Nabet  ---
I changed it for an unbreakable space but it's been changed again by Dimitris
Spingos (dmtrs32) to put "AVERAGE".
Since I'm not Greek, I don't know what to think.
At least, it shouldn't fail so let's put this one to FIXED then.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Julien Nabet  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||8200

--- Comment #35 from Julien Nabet  ---
Eike's response indicates that even in Calc there shouldn't be a space.

Is everyone ok for putting an unbreakable space here?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #34 from Julien Nabet  ---
Just for the record, I asked some advice from LO devs here:
http://document-foundation-mail-archive.969070.n3.nabble.com/Question-about-localized-functions-parsing-in-multiple-words-in-Base-tt4278070.html

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #33 from Julien Nabet  ---
In dbaccess/source/ui/querydesign/QueryDesignView.cxx, line 666 from
GenerateSelectList method I tried to change this line:
OUStringBuffer aTmpStr2( field->GetFunction());
to:
OUStringBuffer aTmpStr2(field->GetFunction().replaceAll(OUStringLiteral1(" "),
OUStringLiteral1(a0)));
to replace plain space by an unbreakable space, still the same result.
I'm stuck :-(

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #32 from Julien Nabet  ---
Created attachment 149056
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149056=edit
bts

I found where the translation was done.

I retrieved 7 bts:
- 3 when loading query editor (so before typing F5)
- 4 after I typed F5

Interestingly, I noticed that in bt4 we got:
#0  0x73bac2a9 in
svxform::OSystemParseContext::getIntlKeywordAscii(connectivity::IParseContext::InternationalKeyCode)
const
(this=0x58dbc620,
_eKey=connectivity::IParseContext::InternationalKeyCode::Avg) at
/home/julien/lo/libreoffice/svx/source/form/ParseContext.cxx:119
#1  0x73bac386 in
svxform::OSystemParseContext::getIntlKeyCode(rtl::OString const&) const
(this=0x58dbc620, rToken="Μέσος")
at /home/julien/lo/libreoffice/svx/source/form/ParseContext.cxx:140
#2  0x7fffec04b9d0 in
connectivity::OSQLScanner::getInternationalTokenID(char const*) const
(this=0x588aa850, sToken=0x58766220 "Μέσος")
at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:7309
#3  0x7fffec04b046 in gatherName(sal_Char const*) (text=0x58766220
"Μέσος")
at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:7130
#4  0x7fffec046bd4 in SQLyylex() () at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:5884
#5  0x7fffec04ba9b in connectivity::OSQLScanner::SQLlex() () at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:7322
#6  0x7fffec040629 in connectivity::OSQLParser::SQLlex() () at
/home/julien/lo/libreoffice/workdir/YaccTarget/connectivity/source/parse/sqlbison.cxx:11158
#7  0x7fffec03dcd1 in SQLyyparse() () at
/home/julien/lo/libreoffice/workdir/YaccTarget/connectivity/source/parse/sqlbison.cxx:10339
#8  0x7fffec03f237 in connectivity::OSQLParser::parseTree(rtl::OUString&,
rtl::OUString const&, bool)
(this=0x57b38b80, rErrorMessage="", rStatement="SELECT Μέσος
όρος(\"number-field\") AS \"number-field\" FROM \"table-number\" GROUP BY
\"group\" ", bInternational=true) at
/home/julien/lo/libreoffice/workdir/YaccTarget/connectivity/source/parse/sqlbison.cxx:10921

bt5:
#0  0x73bac2a9 in
svxform::OSystemParseContext::getIntlKeywordAscii(connectivity::IParseContext::InternationalKeyCode)
const
(this=0x58dbc620,
_eKey=connectivity::IParseContext::InternationalKeyCode::Avg) at
/home/julien/lo/libreoffice/svx/source/form/ParseContext.cxx:119
#1  0x73bac386 in
svxform::OSystemParseContext::getIntlKeyCode(rtl::OString const&) const
(this=0x58dbc620, rToken="όρος")
at /home/julien/lo/libreoffice/svx/source/form/ParseContext.cxx:140
#2  0x7fffec04b9d0 in
connectivity::OSQLScanner::getInternationalTokenID(char const*) const
(this=0x588aa850, sToken=0x58766220 "όρος")
at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:7309
#3  0x7fffec04b046 in gatherName(sal_Char const*) (text=0x58766220
"όρος")
at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:7130
#4  0x7fffec046bd4 in SQLyylex() () at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:5884
#5  0x7fffec04ba9b in connectivity::OSQLScanner::SQLlex() () at
/home/julien/lo/libreoffice/workdir/LexTarget/connectivity/source/parse/sqlflex.cxx:7322
#6  0x7fffec040629 in connectivity::OSQLParser::SQLlex() () at
/home/julien/lo/libreoffice/workdir/YaccTarget/connectivity/source/parse/sqlbison.cxx:11158
#7  0x7fffec03dcd1 in SQLyyparse() () at
/home/julien/lo/libreoffice/workdir/YaccTarget/connectivity/source/parse/sqlbison.cxx:10339
#8  0x7fffec03f237 in connectivity::OSQLParser::parseTree(rtl::OUString&,
rtl::OUString const&, bool)
(this=0x57b38b80, rErrorMessage="", rStatement="SELECT Μέσος
όρος(\"number-field\") AS \"number-field\" FROM \"table-number\" GROUP BY
\"group\" ", bInternational=true) at
/home/julien/lo/libreoffice/workdir/YaccTarget/connectivity/source/parse/sqlbison.cxx:10921

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #31 from Julien Nabet  ---
I tried to play with m_bGraphicalDesign + impl_setViewMode to call
getContainer()->switchView just when needed* + revert back the state, I could
retrieve "AVG" instead of the localized name.
However, when trying trying sql, execute, design, execute, ... I don't remember
the order, it still failed at a point.
In brief, I can put an unbreakable space in Pootle but can't do more.

*
688 case ID_BROWSER_QUERY_EXECUTE:
689 grabFocusFromLimitBox(*this);
690 if ( getContainer()->checkStatement() )
691 {
from dbaccess/source/ui/querydesign/querycontroller.cxx (see
https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/querydesign/querycontroller.cxx#692)

Here why I tried this:
68  OUString OQueryViewSwitch::getStatement()
69  {
70  if(m_pTextView->IsVisible())
71  return m_pTextView->getStatement();
72  return m_pDesignView->getStatement();
73  }
(gdb) p m_pTextView->IsVisible()
$11 = false
(gdb) p m_pTextView->getStatement()
$12 = "SELECT AVG( \"table-number\".\"number-field\" ) AS \"number-field\" FROM
\"table-number\" GROUP BY \"group\""
(gdb) p m_pDesignView->getStatement()
$13 = "SELECT Moyenne(\"number-field\") AS \"number-field\" FROM
\"table-number\" GROUP BY \"group\" "

from
(gdb) bt
#0  0x7fffc8193a14 in dbaui::OQueryViewSwitch::getStatement()
(this=0x5895b500) at
/home/julien/lo/libreoffice/dbaccess/source/ui/querydesign/QueryViewSwitch.cxx:69
#1  0x7fffc815c6d9 in dbaui::OQueryContainerWindow::getStatement()
(this=0x580bd0d0) at
/home/julien/lo/libreoffice/dbaccess/source/ui/inc/querycontainerwindow.hxx:82
#2  0x7fffc8158b69 in dbaui::OQueryController::translateStatement(bool)
(this=0x58e7d650, _bFireStatementChange=false)
at
/home/julien/lo/libreoffice/dbaccess/source/ui/querydesign/querycontroller.cxx:1686
#3  0x7fffc81559ac in dbaui::OQueryController::executeQuery()
(this=0x58e7d650) at
/home/julien/lo/libreoffice/dbaccess/source/ui/querydesign/querycontroller.cxx:1246
#4  0x7fffc8152713 in dbaui::OQueryController::Execute(unsigned short,
com::sun::star::uno::Sequence const&)
(this=0x58e7d650, _nId=10721, aArgs=uno::Sequence of length 1 = {...}) at
/home/julien/lo/libreoffice/dbaccess/source/ui/querydesign/querycontroller.cxx:690
#5  0x7fffc7ef54d2 in
dbaui::OGenericUnoController::executeChecked(com::sun::star::util::URL const&,
com::sun::star::uno::Sequence const&)
(this=0x58e7d650, _rCommand=..., aArgs=uno::Sequence of length 1 = {...})
at
/home/julien/lo/libreoffice/dbaccess/source/ui/browser/genericcontroller.cxx:1049

I searched about IsVisible and found Show function in
OQueryViewSwitch::impl_postViewSwitch itself called from
OQueryViewSwitch::switchView

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #30 from Lionel Elie Mamane  ---
I mean, if you solve the bug at a deeper level and truly allow the process to
handle spaces, then all the better. To do that, the right place is probably not
the yacc/lex grammar per se. We need to find the code that gets the localised
string chosen in the menu and maps it back to SQL keywords (which happen to
resemble English). That's the point that needs to be fixed. Hopefully it just
needs to treat the whole string gotten from the menu as an indivisible string
instead of tokenizing it. To get started on that, look where the error is
raised and go from there. If there is already Greek at that point, go back and
find where that Greek is coming from.

But failing that, at least the non-breaking space will solve this particular
bug which is problematic for Greek users.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #29 from Lionel Elie Mamane  ---
Try putting adding double quotes around "Μέσος όρος"; it that doesn't work, try
simple quotes. I don't know if it works, but worth trying.
If that doesn't work, yes, put an unbreakable space, a dash "-", an underscore
"_" or just remove the space and use CamelCase, whatever the Greek translation
community thinks is the least horrible.

Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #28 from jimishol  ---
Excuse my  interference, I, as simple user for this kind of problems, use
visible Shift+"-" as a pointer that space could cause problems.
May be it is totally irrelevant but the "Μέσος όρος" appears 4 times at
https://opengrok.libreoffice.org/xref/translations/source/el/sc/messages.po

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #27 from Julien Nabet  ---
I confirm putting an unbreakable space worked.

Lionel: do you think it's ok for the unbreakable space or is it just a
workaround and tokenization process should be changed? (I couldn't help for
this since I know too little about lex and yacc)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Julien Nabet  changed:

   What|Removed |Added

 CC||lio...@mamane.lu

--- Comment #26 from Julien Nabet  ---
Lionel: I'm not sure but wonder if the pb may be due to the fact that AVG
corresponds to a 2 words "Μέσος όρος" in Greek.
Perhaps putting an unbreakable space could make it.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #25 from Julien Nabet  ---
Created attachment 141180
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141180=edit
bt + gdb traces

On gdb, I did a ctrl-C when error message box appeared.
Then I used:
thread apply all bt
and finally got this bt

Pb is in OQueryController::translateStatement (see
https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/querydesign/querycontroller.cxx#1683)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #24 from Julien Nabet  ---
On pc Debian x86-64 with master sources updated today, I could reproduce this
with Greek language.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #23 from Markos Chandras  ---
(In reply to Buovjaga from comment #22)
> Right, I forgot about the Greekness along the way.
> Markos: how were you able to reproduce this? With Greek interface or
> something else?

Yep, I did the exact same thing with jimishol

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #22 from Buovjaga  ---
Right, I forgot about the Greekness along the way.
Markos: how were you able to reproduce this? With Greek interface or something
else?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #21 from jimishol  ---
I tried daily and alpha. Both have only English default interface, so I cann't
test the Greek interface. Nevertheless, both crashed when i clicked "edit
query" even at english interface.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #20 from Buovjaga  ---
(In reply to jimishol from comment #19)
> I tried appimage. It was full libreoffice-still version 5.4.6.2
> Same bug, same behavior.
> And since i had full version i tried german, italian, french and russian
> interfaces. None had the greek interface problem.

No, please try with the DAILY VERSION.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #19 from jimishol  ---
I tried appimage. It was full libreoffice-still version 5.4.6.2
Same bug, same behavior.
And since i had full version i tried german, italian, french and russian
interfaces. None had the greek interface problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Buovjaga  changed:

   What|Removed |Added

 CC||mchand...@suse.de,
   ||todven...@suomi24.fi

--- Comment #18 from Buovjaga  ---
jimishol, Markos: can you try with an appimage of a daily version:
https://www.libreoffice.org/download/appimage

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Xisco Faulí  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #17 from jimishol  ---
Created attachment 140832
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140832=edit
103736bug-video for average function_on greek translation

On updated Arch i installed libreoffice-still-el package

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Xisco Faulí  changed:

   What|Removed |Added

 Status|REOPENED|NEEDINFO

--- Comment #16 from Xisco Faulí  ---
(In reply to Markos Chandras from comment #15)
> I am reopening this bug since I was able to reproduce it on openSUSE Leap
> 42.3 using 5.4.5.1

Could you please try to reproduce it with a master build from
http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the master build

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Markos Chandras  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTOURBUG   |---
 Ever confirmed|0   |1

--- Comment #15 from Markos Chandras  ---
I am reopening this bug since I was able to reproduce it on openSUSE Leap 42.3
using 5.4.5.1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTOURBUG

--- Comment #14 from Alex Thurgood  ---
@jimishol : 5.2 is no longer current.

Given other people's testing without a problem, it appears that your problem is
a Gentoo package issue, rather than a problem with a current release of
LibreOffice, I am setting this to NOTOURBUG.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #13 from Alex Thurgood  ---
No repro either with GR langpack :

Έκδοση: 5.4.4.2
Αναγνωριστικό δόμησης: 2524958677847fb3bb44820e40380acbe820f960
Νήματα CPU:4; Λειτουργικό σύστημα: Mac OS X 10.13.2; Απόδοση διεπαφής χρήστη:
προεπιλογή; 
Τοπικό: el-GR (fr_FR.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #12 from Alex Thurgood  ---
No repro with:

Version: 5.4.4.2
Build ID: 2524958677847fb3bb44820e40380acbe820f960
Threads CPU : 4; OS : Mac OS X 10.13.2; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

jimishol  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|WORKSFORME  |---
 Ever confirmed|1   |0

--- Comment #11 from jimishol  ---
I'm deeply sorry. I failed to check properly. On greek interface it continue
the same problem when i go to design mode. So  i switch back to english
interface. 
I switch to uncorfimed tag, because i have nothing else to add.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Xisco Faulí  changed:

   What|Removed |Added

 Resolution|FIXED   |WORKSFORME

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

jimishol  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |FIXED

--- Comment #10 from jimishol  ---
Problem fixed by itself at

Version: 5.4.4.2
Build ID: Gentoo official package
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
Locale: el-GR (el_GR.utf8); Calc: group

Now i can switch to greek interface with no problem

I mark as resolved-fixed. Please, put the right tag if it is not the right
ones.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #9 from QA Administrators  ---
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping-20180102

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Xisco Faulí  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||xiscofa...@libreoffice.org
 Ever confirmed|0   |1

--- Comment #8 from Xisco Faulí  ---
Put it back to UNCONFIRMED once you test it, otherwise, better to keep it in
NEEDINFO

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

jimishol  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #7 from jimishol  ---
I can not update right now, may be later.
i use 
Version: 5.2.5.1
Build ID: Gentoo official package
CPU Threads: 4; OS Version: Linux 4.6; UI Render: default; VCL: gtk2; 
Locale: el-GR (el_GR.utf8); Calc: group

I installed from gentoo portage
I installed app-office/libreoffice-l10n too

When i use Greek interface for libreoffice i get this error
So i use the default English interface where there is no problem

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #6 from QA Administrators  ---
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping-20170531

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #5 from jimishol  ---
It was not jre matter after all. Sorry.
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)
problem disappeared both on debian and gentoo

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #4 from jimishol  ---
i use packages as it comes from my distributions
and i used HSQLDB

i tried to see if it happens with postgres as well. So on a virtualbox with
Arch i installed libreoffice and postgres. Upon query design LO said it needed
JRE and i installed jre8-openjdk and problem disappeared!! at HSQLDB too!

Now on gentoo i have virtual/jre-1.8.0-r1 and 
on debian-jessie openjdk-7-jre and default-jre

I had no time to test with different jre s and specially on gentoo it isnt easy
because of compilation time it will take

It seems it is a jre matter

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

--- Comment #3 from jimishol  ---
Created attachment 128557
  --> https://bugs.documentfoundation.org/attachment.cgi?id=128557=edit
just for avg testing

right click query to edit on sql view so as to see sql code
run (f5) to see 2 averages
click view on design view
try run again or save or leave design view
syntax error

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 CC||rob...@familiegrosskopf.de

--- Comment #2 from rob...@familiegrosskopf.de ---
Have tested with 
Version: 5.2.3.3
Build-ID: d54a8868f08a7b39642414cf2c8ef2f228f780cf
CPU-Threads: 4; BS-Version: Linux 4.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group

In a internal HSQLDB I created a query, set AVG by GUI to a numeric field. No
problem to run a query.

The error, which is reported, is the standard if Base doesn't understand the
code. 

@jimishol: Which *.deb-packages do you use? From LO directly or packages of
your distribution?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 103736] libreoffice-5.2.2.2 AVG function produces SQL syntax error in query design view

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=103736

Julien Nabet  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||serval2...@yahoo.fr
Version|unspecified |5.2.2.2 release
 Ever confirmed|0   |1

--- Comment #1 from Julien Nabet  ---
Which DB do you use?
Would you have some example file so we can give it a try?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs