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: 4.2.0.4 release
Could this be a duplicate of Bug46841 ? See also Bug42713.
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.
Adding self to CC if not already on