https://bugs.documentfoundation.org/show_bug.cgi?id=159236
Bug ID: 159236
Summary: Running specific query in LibreOffice Base does not
work
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When opening this file (https://file.io/ubY52Z0AjH0A) in LibreOffice Base and
running the shown query (https://ibb.co/album/WGqGK2) it returns the shown
error. The query in of itself has no issues and running it with other
Conditions after the WHERE clause works properly. When reconstructing the table
manually in a new/seperate file and running the same query, everything works
fine.
Steps to Reproduce:
1. Open the attached file (https://file.io/ubY52Z0AjH0A) in LibreOffice Base
2. Create a new SQL query
3. Type in the shown query (SELECT * FROM Sortiment WHERE Rubrik = "Zeichnen")
and run
Actual Results:
Two errors:
SQL Status: S0022
Error code: -28
Column not found: Zeichnen in statement [SELECT * FROM "Sortiment" WHERE
"Rubrik" = "Zeichnen"] at ./connectivity/source/drivers/jdbc/Object.cxx:173
and
The data content could not be loaded. at
./connectivity/source/commontools/dbtools.cxx:746
Expected Results:
Run the query properly and show the results
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: de-DE (en_GB.UTF-8); UI: en-US
Debian package version: 4:7.6.4~rc1-1+b2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
