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
The text on WHERE must be with single quotes. SELECT * FROM Sortiment WHERE Rubrik = 'Zeichnen' works for me.
(In reply to m_a_riosv from comment #1) > The text on WHERE must be with single quotes. > SELECT * FROM Sortiment WHERE Rubrik = 'Zeichnen' > works for me. Usually double quotes work too, except for this file. When re-creating this file manually, double quotes work as normal. This is inconsistent behavior.
I don't think so, double quotes are for fields, no for strings.
Attachment isn't available, but SELECT * FROM "Sortiment" WHERE "Rubrik" = "Zeichnen" expect 2 fields: "Rubrik" and "Zeichnen" and will show all rows where content of "Rubrik" and "Zeichnen" are the same. Double-quotes are used for quoting fields and tables, not for quoting text content. For text content you will need single quotes. Please have a look at the documentation. When I see the query it might be German Base Handbuch you will need: https://de.libreoffice.org/get-help/documentation/