Auto indentation behavior

[cesarmansur]

Hello.
I'd like to have an option to disable auto indentation after inserting empty lines. This is the default behavior in Notepad++, for example. But I think it could be configurable in DBeaver.

[uslss]

hi @cesarmansur ,
probably default formatter changing could solve your problem? e.g. for Compact view

[cesarmansur]

Hi @uslss
This is not exactly what I'm looking for...
I'm talking about the auto indentation feature, that automatically insert spaces in the new line, even if I remove the indentation and also after I enter empty new lines.
e.g.

Sample SQL

Now, if I press ENTER, the editor will automatically indent the new line. So far so good.

But, If I remove all the spaces from the new line and press ENTER, it will insist on putting spaces on the new lines. This is not desirable, as per I deliberately removed the spaces because I don't want them. It should follow the indentation from my previous empty line, that is none.

And even if I insert many empty lines, everytime I press ENTER it will insist in put spaces on my new line. This is very annoying.

My feature request is to have the automatic indentation disabled after the user inserted an empty and not indented new line. This is the default behavior on other editors. It should just follow the indentation from the previous line. If the previous line is empty and not indented, no indentation on the new line. Only if the previous line is indented, so make the editor auto indent the new line.
e.g. Notepad++

[uslss]

@cesarmansur thanks a lot for clarification and suggestion

[AndreSchulz-IONOS]

hi, any update here? having the same issue...

e.g. have a look at the following example:

SELECT col
    FROM tab;
-- test1
-- test2

if i want to add a new line before -- test2 i would put the cursor on the start of the line and hit enter.
this results in

SELECT col
    FROM tab;
-- test1

-- test2

so far so good.
but

SELECT col
    FROM tab
        WHERE a = 1;
-- test1
-- test2

results in

SELECT col
    FROM tab
        WHERE a = 1;
-- test1

    -- test2

[superclarkk]

Same issue. Any chance of a fix?

[MeboGit]

Also having same issue, any fix or workaround?

[anymos]

Same issue, looking forward for a fix ...

[w97655]

This forced indentation is so annoying. Incredible auto indent on/off is not available, it's such a small technical thing with a huge user impact.

[perbergstrand]

Ended up here when looking for how to disable the auto indenting. Apparently there is no such setting (odd since DBeaver has about a thousand settings :)). Please add this possibility. It is annoying to have to keep removing undesired added spaces when inserting a new line in the middle of a list or something else placed in the editor. Not all text placed there is pure SQL (for which I would still like to be able to get rid of the auto indenting), but meta text as well for the stuff you are working with at the moment.

[DreamXWay]

Did a quick search and the auto indent logic is most likely in SQLAutoIndentStrategy.java. Mark for myself to read the code later to see if it's possible to make a PR out of it.

As of the fixing approach, I don't think an extra preference option is needed, just follow the indent from the previous line, even if it is an empty line.

[mibrunet]

The problem with the auto indentation on new lines is that it aligns with the start position of the last line of code and adding empty lines in between does not change this behavior. Should adding an empty line reset the start position?