https://bugs.documentfoundation.org/show_bug.cgi?id=170289
Bug ID: 170289
Summary: LibreOffice Base Query SQL-View does not reliable save
Code with linebreaks
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Hello,
When creating a query in the SQL-view, sometimes the code looses all
linebreaks.
The functionality isnt affected, but its very hard to work with the code
without linebreaks.
This happens only if the mode is set to not execute the query directly on DB.
It might has something to do with the automatic check / supplement of quatation
marks around table and column names (e.g. tbl_A.x gets "tbl_A"."x").
I could experience this behavior on GNU/Linux (Debian with KDE) and Windows 10
in several versions of LibreOffice up to 25.2.3.2.
Steps to Reproduce:
1. Create a query in SQL view with linebreaks and tabs etc.
2. Set Mode to directly execute on DB and save query
3. Close and reopen query in SQL-view
Actual Results:
The SQL code has no linebreaks and no tabs
Expected Results:
The SQL code should be in the same format as it was shown when saved.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: kf6 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Debian package version: 4:25.2.3-2+deb13u2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
