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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Julien Nabet changed: What|Removed |Added Resolution|--- |FIXED Status|NEW

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Julien Nabet changed: What|Removed |Added See Also||https://bugs.documentfounda

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

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Julien Nabet changed: What|Removed |Added CC|

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

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

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever

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

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

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

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

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

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

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

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,

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Buovjaga changed: What|Removed |Added CC|

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Xisco Faulí changed: What|Removed |Added Status|NEEDINFO

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Xisco Faulí changed: What|Removed |Added Status|REOPENED

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Markos Chandras changed: What|Removed |Added Status|RESOLVED|REOPENED

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED

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

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; Απόδοση

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

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);

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 jimishol changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Xisco Faulí changed: What|Removed |Added Resolution|FIXED

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 jimishol changed: What|Removed |Added Status|NEEDINFO|RESOLVED

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 jimishol changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED

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

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:

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

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

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

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)

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

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

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

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

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 rob...@familiegrosskopf.de changed: What|Removed |Added CC|

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

https://bugs.documentfoundation.org/show_bug.cgi?id=103736 Julien Nabet changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO