[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY, MILLISECOND

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

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 Lionel Elie Mamane changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #26 from Julien Nabet --- Thank you Robert for your feedback. Lionel: do you think it worths it to cherry-pick the 3 commits (the Tor's one + the 2 of you) which fixed this one on 6.0 branch or since

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 rob...@familiegrosskopf.de changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #24 from Julien Nabet --- On pc Debian x86-64 with master sources updated today, I gave a new try. Here what I got in EXTRACT field with last three requests: EXTRACT(WEEKDAY FROM "StartTimestamp") => 2

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #23 from Commit Notification --- Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #22 from Commit Notification --- Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #21 from Lionel Elie Mamane --- (In reply to Tor Lillqvist from comment #20) > You write: 'No, it is not LibreOffice itself that "quotes" the WEEKDAY, it > is the SDBC Firebird driver.' > > But isn't "the

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #20 from Tor Lillqvist --- You write: 'No, it is not LibreOffice itself that "quotes" the WEEKDAY, it is the SDBC Firebird driver.' But isn't "the SDBC Firebird driver" part of LibreOffice? Doesn't that simply

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #19 from Lionel Elie Mamane --- (In reply to Lionel Elie Mamane from comment #18) > There is probably a much more robust way to do it... One only has to grossly > lex the SQL, just keeping track of whether

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #18 from Lionel Elie Mamane --- (In reply to Lionel Elie Mamane from comment #17) > connectivity::firebird::Connection::transformPreparedStatement > seems to exist only to remove named parameters... Which

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #17 from Lionel Elie Mamane --- No, it is not LibreOffice itself that "quotes" the WEEKDAY, it is the SDBC Firebird driver. connectivity::firebird::Connection::prepareStatement is called with: SELECT

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #16 from Lionel Elie Mamane --- (In reply to Tor Lillqvist from comment #13) > The problem is that Base for some reason seems to uses its SQL lexer and > parser to decide whether to pass words in SQL to the

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #15 from Tor Lillqvist --- s/affect/effect -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #14 from Tor Lillqvist --- I did try Firebird 3.0.2, it had no affect on this. -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #13 from Tor Lillqvist --- The problem is that Base for some reason seems to uses its SQL lexer and parser to decide whether to pass words in SQL to the database engine as such or quoted. Not sure why it works

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 Commit Notification changed: What|Removed |Added Whiteboard|

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #12 from Commit Notification --- Tor Lillqvist committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #11 from Lionel Elie Mamane --- (In reply to Tor Lillqvist from comment #10) > Suggested fix in https://gerrit.libreoffice.org/#/c/47271/ This change teaches the corresponding keywords to the LibreOffice

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #10 from Tor Lillqvist --- Suggested fix in https://gerrit.libreoffice.org/#/c/47271/ -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #9 from Gerhard Schaber --- There is already Firebird 3.0.2. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #8 from Tamas Bunth --- (In reply to Julien Nabet from comment #7) > Tamas: would you have some time for a patch to upgrade to Firebird 3.0.1 by > any chance? Sorry, I still don't have time until March.

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #7 from Julien Nabet --- Tamas: would you have some time for a patch to upgrade to Firebird 3.0.1 by any chance? -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #6 from Tamas Bunth --- (In reply to Lionel Elie Mamane from comment #4) > (In reply to Lionel Elie Mamane from comment #3) > > Hmm... That's weird. These all work in a stand-alone firbird 3.0 > > That

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #4 from Lionel Elie Mamane --- (In reply to Lionel Elie Mamane from comment #3) > Hmm... That's weird. These all work in a stand-alone firbird 3.0 That might be a bug fixed in Firebird 3.0.1, althought I

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #5 from Lionel Elie Mamane --- (I say that because my stand-alone firebird is 3.0.1 and there it works) -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 --- Comment #3 from Lionel Elie Mamane --- Hmm... That's weird. These all work in a stand-alone firbird 3.0 -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

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

[Libreoffice-bugs] [Bug 104986] Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY , MILLISECOND

https://bugs.documentfoundation.org/show_bug.cgi?id=104986 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEW