Bug 74487 - UI: Enhancement: Keep whitespace in SQL Editor
Summary: UI: Enhancement: Keep whitespace in SQL Editor
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
Reported: 2014-02-04 05:51 UTC by tristen.smart
Modified: 2017-11-06 00:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description tristen.smart 2014-02-04 05:51:28 UTC
Problem description: 
It would aid readability and reduce reliance on copy / pasting from a text editor if whitespace & SQL syntax were left as entered by the user in the SQL editor.

Steps to reproduce:
1. Open a new query in SQL View
2. Type a SELECT statement with readable indentation
3. Save & close.
4. Re-open Query in SQL View.

Current behavior:
All surplus whitespace is removed. SQL Syntax may be altered if not matching HSQLDB syntax (the last is usually a good thing).

Expected behavior:
No change to user entered statements. Perhaps an Options setting for SQL Syntax Auto-Correct, however whitespace really should remain.

Operating System: All
Version: release
Comment 1 Robert Großkopf 2014-02-04 15:02:35 UTC
Could this be a duplicate of Bug46841 ? See also Bug42713.
Comment 2 Robert Großkopf 2014-11-15 17:46:05 UTC
I could reproduce the bug and will set this to NEW.
It is an ask for the same enhancement as in some other bugs, which are linked in "See also". 

The real problem ist: There is only saved the SQL-code of a query - no comment, no special formatting, nothing, which is declared in GUI for formatting columns ...

If there is any possibility to save something else than the SQL-code without comments all this asks for an enhancement would be more easy to manage.
Comment 3 Alex Thurgood 2015-01-03 17:38:21 UTC Comment hidden (no-value)