[Libreoffice-bugs] [Bug 146757] Embedded Firebird ignores parameterized query input

2022-01-17 Thread bugzilla-daemon
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

2022-01-17 Thread bugzilla-daemon
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

2022-01-17 Thread bugzilla-daemon
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

2022-01-17 Thread bugzilla-daemon
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

2022-01-15 Thread bugzilla-daemon
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

2022-01-15 Thread bugzilla-daemon
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

2022-01-15 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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)

2022-01-14 Thread bugzilla-daemon
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.