[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 --- Comment #9 from Eike Rathke --- That for this case 0.3... (the 08:00 converted to double) results in being converted to date string "30 December 1899" which when converted to numeric is 0, hence all records match departure>0. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 --- Comment #8 from Eike Rathke --- HAHAHA https://opengrok.libreoffice.org/xref/core/connectivity/source/parse/sqlnode.cxx?r=16506994#220 https://opengrok.libreoffice.org/xref/core/connectivity/source/parse/sqlnode.cxx?r=16506994#232 https://opengrok.libreoffice.org/xref/core/connectivity/source/parse/sqlnode.cxx?r=16506994#245 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 --- Comment #7 from Eike Rathke --- If that commit affects time queries in Base then Base somewhere makes serious wrong assumptions about number formatter internal constants. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 Julien Nabet changed: What|Removed |Added Severity|normal |major Priority|medium |high --- Comment #6 from Julien Nabet --- (In reply to raal from comment #5) > This seems to have begun at the below commit. > ... > https://git.libreoffice.org/core/+/f7d0c6b42a0a5ec98876006cd5048589219be741 > Sort ZF_STANDARD_NEWEXTENDED_DATE_... into ZF_STANDARD_DATE category I confirm, I don't reproduce the pb when reverting this commit locally. Let's increase a bit importance since: - it's a regression - it impacts all env It's possible not only Firebird (which is still experimental). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 raal changed: What|Removed |Added CC||er...@redhat.com, ||r...@post.cz Keywords|bibisectRequest |bibisected, bisected --- Comment #5 from raal --- This seems to have begun at the below commit. Adding Cc: to Eike Rathke ; Could you possibly take a look at this one? Thanks c8ece95d00e558f56c1d970745337bbf9254d2fc is the first bad commit commit c8ece95d00e558f56c1d970745337bbf9254d2fc Author: Jenkins Build User Date: Thu Sep 23 20:33:51 2021 +0200 source sha:f7d0c6b42a0a5ec98876006cd5048589219be741 https://git.libreoffice.org/core/+/f7d0c6b42a0a5ec98876006cd5048589219be741 Sort ZF_STANDARD_NEWEXTENDED_DATE_... into ZF_STANDARD_DATE category -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 Alex Thurgood changed: What|Removed |Added Summary|Embedded Firebird ignores |Embedded Firebird ignores |parameterized query input |parameterized query input |(macOS Arm) | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 QA Administrators changed: What|Removed |Added Keywords||bibisectRequest -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 --- Comment #4 from Julien Nabet --- I could reproduce this on an hsqldb odb file. However, not sure my test was ok since typing this in Execute SQL statement SELECT * FROM "Timetable" WHERE "departure" > '08:00' failed with: Wrong data type: java.lang.IllegalArgumentException /home/julien/lo/libreoffice/connectivity/source/drivers/jdbc/Object.cxx:172 The goal was to find if it was specific to Firebird. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 Julien Nabet changed: What|Removed |Added Hardware|ARM |All CC||serval2...@yahoo.fr Ever confirmed|0 |1 Status|UNCONFIRMED |NEW OS|macOS (All) |All --- Comment #3 from Julien Nabet --- On pc Debian x86-64 with master sources updated today, I could reproduce this. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 --- Comment #2 from Alex Thurgood --- Also works correctly in Collabora Office Version: 21.06.9.1 Build ID: 0579e4dd91e7fd2e0574e3919b921e930642f8dd CPU threads: 8; OS: Mac OS X 12.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded and LibreOffice Vanilla Version: 7.2.4.1 / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 8; OS: Mac OS X 12.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 Alex Thurgood changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 Alex Thurgood changed: What|Removed |Added Hardware|All |ARM -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input (macOS Arm)
https://bugs.documentfoundation.org/show_bug.cgi?id=146757 --- Comment #1 from Alex Thurgood --- Created attachment 177541 --> https://bugs.documentfoundation.org/attachment.cgi?id=177541&action=edit Embedded Firebird test file -- You are receiving this mail because: You are the assignee for the bug.