unwanted but valid keyword in aucocomplete popup

[Jerther]

Is your feature request related to a problem? Please describe.
I use dbeaver for a postgresql database, and I use autocomplete. The keywords dbeaver suggests are generally useful, but there is a "notnull" (no space) keyworkd that keeps popping up and is selected by default when I write "where x is not null" and while I can just select "null" or write the whole text manually or press space, I find it very annoying.

Describe the solution you'd like
I'd like some way of removing that keyword form the autocomplete list, either via a GUI or a workaround.

Describe alternatives you've considered
None. I couldn't find anything about this anywhere, so I thought it was hardcoded or something, and I just live with it :(

Additional context

[LonwoLonwo]

Hello @Jerther

As I can see in PostgreSQL documentation - NOTNULL is a valid keyword.

[Jerther]

Hmmm, you're right... So the syntax is

where x notnull

Even more annoying ;)

Is there a way to remove or hide that keyword from the suggestion popup, even though it's valid?

[LonwoLonwo]

No, sorry. The keywords returned the driver DBeaver shows in the pop-up list. There is no specific keywords list in DBeaver with the word 'NOTNULL'.

[Jerther]

So it comes from the driver. I took a quick look around the JDBC documentation for postgres and I couldn't find anything related to keywords. Well anyway, if dbeaver does not provide some kind of "blacklist" or "whitelist" for SQL keywords, I might as well give up on this.

[LonwoLonwo]

DBeaver has this kind of list of extra keywords, but 'NOTNULL' is not in this list.
https://github.com/dbeaver/dbeaver/blob/devel/plugins/org.jkiss.dbeaver.ext.postgresql/src/org/jkiss/dbeaver/ext/postgresql/model/PostgreDialect.java

[Jerther]

I think the "issue" I'm having would be alleviated by #6528 (comment)

[timw2]

@LonwoLonwo how does DBeaver determine what order the autocomplete words are listed in? I think the frustration is that the word I typed is in the list but isn't the first option in the list that is selected so if I just type the query normally without thinking about autocomplete it gets "broken".

Could the autocomplete list put any options that exactly match what is typed (case insensitive) at the top of the list?