Bug 87737 - EDITING: Date-parameter in HSQLDB-queries don't work in UI-language, if parameter is only in subquery
Summary: EDITING: Date-parameter in HSQLDB-queries don't work in UI-language, if param...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-26 07:13 UTC by Robert Großkopf
Modified: 2020-07-29 08:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Try input date in the parameter for both queries. One works in GUI-language, the other doesn't. (6.66 KB, application/vnd.oasis.opendocument.base)
2014-12-26 07:13 UTC, Robert Großkopf
Details
Same database-file as attachment 1, migrated to Firebird (11.12 KB, application/vnd.oasis.opendocument.database)
2020-07-29 08:01 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2014-12-26 07:13:47 UTC
Created attachment 111359 [details]
Try input date in the parameter for both queries. One works in GUI-language, the other doesn't.

Open the attached database.
Open the query "Saldo_Kategorie".
You are asked for 'qDatum'.
Write a date and finish.
The query would be executed.

Open the query "Saldo_Konto".
You are asked for 'qDatum'.
Write a date and finish.
The query would only be executed, if you will format the date right to the SQL-standard, something like '2014-12-26'.

The difference between the two queries:
"Saldo_Kategorie" asks for the parameter in the condition of the query:
...FROM "Kasse" AS "a" WHERE "Datum" <= :qDatum AND "Umbuch_Konto_ID" IS NULL
The parameter is also askes for in subqueries, but it works well.
"Saldo_Konto" asks for the parameter only in subqueries and fails wirth GUI-language, works only with SQL-well-formatted date.

Both queries work right in a form. The date in a form will be transported in SQL-format.

My system: OpenSUSE 12.3 64bit rpm Linux, different LO-versions, also 4.4.0.1 rc
Comment 1 raal 2014-12-30 12:52:38 UTC
I can confirm with LO 4.3.5, win7
Comment 2 Alex Thurgood 2015-01-03 17:39:06 UTC Comment hidden (no-value)
Comment 3 QA Administrators 2016-01-17 20:04:06 UTC Comment hidden (obsolete)
Comment 4 Robert Großkopf 2016-01-29 15:10:51 UTC
Bug still exists with LO 5.1.0.3, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 5 QA Administrators 2017-03-06 14:20:24 UTC Comment hidden (obsolete)
Comment 6 Robert Großkopf 2017-03-06 19:54:47 UTC
Bug still exists with LO 5.3.1.1, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 7 QA Administrators 2018-03-07 03:41:50 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2018-03-07 18:03:16 UTC
Bug still exists with LO 6.0.2.1, OpenSUSE 42.3 Leap, 64bit rpm Linux.
Comment 9 QA Administrators 2019-03-08 03:41:11 UTC Comment hidden (obsolete)
Comment 10 Robert Großkopf 2019-03-08 15:58:14 UTC
Same buggy behaviour with LO 6.1.5.2 on OpenSUSE 15 64bit rpm Linux.
Comment 11 Robert Großkopf 2020-07-29 07:51:44 UTC
One hint from Firebird:
Firebird needs to set the parameter, which will be compared with a date, to VARCHAR. If I set in Firebird
CAST( :qDatum AS VARCHAR(50) )
I could input the date in GUI-language and the query will work.

... but this isn't a solution for this special problem with HSQLDB.
Comment 12 Robert Großkopf 2020-07-29 08:01:44 UTC
Created attachment 163723 [details]
Same database-file as attachment 1, migrated to Firebird

Open the attached file.
Both queries will work with input date in GUI-language.
Note: Code has to be changed in the query for Saldo_Konto, but this change is impossible in HSQLDB.