https://bugs.documentfoundation.org/show_bug.cgi?id=165458
Bug ID: 165458
Summary: Database queries suddenly show SQL error after update
from 24.7.2 to 24.8.5
Product: LibreOffice
Version: 24.8.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
>From a quick examination it seems that the COLLATE "UNICODE" statements in an
order by clause is suddenly producing an error.
It worked fine in 24.7.2 and striking that from the statements removes the SQL
error but of course gives crappy sorting results.
And it gets even sillier:
I have forms using the very queries that are throwing an error when called as a
query ... and these forms are working fine showing the desired query results
with correct sorting!
What is going on here?????
Steps to Reproduce:
1. Make a query using COLLATE "UNICODE" in an order by statement.
2. Try to save query and get an error.
3. If you already have such a query and it is used in a form however, it works
fine.
Actual Results:
Query as query is not running at all due to an (imagined?) error.
Expected Results:
The query should simply run and produce the correctly sorted results.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: fddf2685c70b461e7832239a0162a77216259f22
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
