-
-
Notifications
You must be signed in to change notification settings - Fork 2.3k
Closed
Labels
enhancementFeature requests.Feature requests.
Description
Details for the issue
When using Copy Create Statement and copying the statement in the SQL tab, the statement results in one long single line without multiple spaces, tabs and newlines.
CREATE VIEW equityExclAccounts as WITH recursive assets AS ( SELECT * FROM category ca WHERE type IN ('ASSETS', 'LIABILITIES') UNION SELECT ca.* FROM category ca JOIN assets a on a.id = ca.parentId WHERE ca.type != 'ACCOUNT' ) SELECT * FROM assets
When exporting the schema of a table/view, the schema preserves the newlines.
DROP VIEW IF EXISTS `equityExclAccounts`;
CREATE VIEW equityExclAccounts as
WITH recursive assets AS
(
SELECT *
FROM category ca
WHERE type IN ('ASSETS', 'LIABILITIES')
UNION
SELECT ca.*
FROM category ca
JOIN assets a on a.id = ca.parentId
WHERE ca.type != 'ACCOUNT'
)
SELECT * FROM assets;
COMMIT;
Enhancement request:
Could newlines be preserved in Copy Create Statement too? And maybe tabs and spaces also?
Useful extra information
I'm opening this issue because:
- DB4S is crashing
- DB4S has a bug
- DB4S needs a feature
- DB4S has another problem
I'm using DB4S on:
- Windows: ( version: 10 )
- Linux: ( distro: ___ )
- macOS: ( version: ___ )
- Other: ___
I'm using DB4S version:
- 3.10.1
- 3.10.0
- 3.9.1
- Other:
I have also:
- Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
- Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
Metadata
Metadata
Assignees
Labels
enhancementFeature requests.Feature requests.