Expected behavior

Two possible behaviors:

1. autocomplete should sort by alphabetical order (or it should be an option in the settings)
2. autocomplete should complete the text only when I press "enter" and not when I press "space"

Current behavior

Autocomplete does not sort columns, they are displayed in the same order as you have them in the table. Therefore you might pick wrong column name from the popup in certain situations.

Failure information (for bugs)

If you have several columns with similar names, it could lead to autocomplete picking wrong item when you press space-bar.

Steps to reproduce

1. create a table with two columns "column_a" and "column"
2. write a query and have autocomplete to show you suggestions for the table
3. type "column" and press space... your text will be changed to "column_a"

Context

• HeidiSQL version: 9.4.0.5186
• Operating system: Windows 10

Failure Logs

(pressing space at this moment will autocomplete with the "field_b" column name which was not intended)