Autocomplete on aliases doesn't trigger if the table name contains the word "join"

[marcel-aguiar-frequence]

Preconditions

• HeidiSQL version: 12.6.0.6765
• Database type and version: MySQL 5.7.12 and Postgres 12.0
• OS: Windows 11 Pro 22H2

Describe the bug

There are a handful of tables in our Mysql db where when a table alias is used, autocomplete doesn't work. I noticed this seems to only happen with tables that have the word "join" them, such as "shelf_join_books" or "users_join_admins". However autocomplete does work if I reference the table name directly. I tested this on different SQL types, different machines, and different HeidiSQL versions, and the issue exists across all of them.

Example:

SELECT uja. <-- after typing ".", autocomplete doesnt trigger.
FROM users_join_admins uja;

SELECT users_join_admins . <-- This DOES work
FROM users_join_admins uja;

To Reproduce

1. Find a table with "join" in the name, or create one.
2. In a query tab, reference the above table in a query and give it an alias
3. Reference the alias and type dot (.)
4. Autocomplete won't appear

Screenshots or Crash reports

[ansgarbecker]

Issue introduced in 28634e6 from March 2008 :)

[ansgarbecker]

Fix 16 years later. Please update to the next build.

[marcel-aguiar-frequence]

Thank you! Is this a record?

[ansgarbecker]

No I don't think it's a record, but definitely worth a joke :) HeidiSQL's oldest code passages are even older than 20 years, and I believe there are still issues from that time.