Description

Autocomplete currently doesn't work when you use a leading exclamation point as a negation operator.

For example:

Typing "c.D" here will filter autocomplete and display "Deleted" as a column option

SELECT *
FROM contacts c
WHERE c.Deleted = 0

However, typing "!c.D" will result in no autocomplete options appearing

SELECT *
FROM contacts c
WHERE !c.Deleted

Not sure if this is technically a bug or support was just never added for it, but either way, it would be VERY nice to support!

HeidiSQL version

12.10.0.7000

Database server version

MariaDB 10.6.21

Reproduction recipe

Typing "c.D" here will filter autocomplete and display "Deleted" as a column option

SELECT *
FROM contacts c
WHERE c.Deleted = 0

However, typing "!c.D" will result in no autocomplete options appearing

SELECT *
FROM contacts c
WHERE !c.Deleted

Error/Backtrace