[11.0.35 Pro] - BUG: Aliases-Ignore Name Prefixes

[11.0.35 Pro] - BUG: Aliases-Ignore Name Prefixes

DB Option > Aliases > Ignore Name Prefixes does not seem to work. At least it doesn't for MariaDB. I have some prefixes (tada_, kar_, kr_, tm_) added to the defaults (TBL_, TFN_, V_), yet whenever I select a table from the popup that has one of those prefixes, the resulting alias still contains the letter of the should-be-ignored prefix, eg. the table tada_service_journey will get the alias tsj instead of sj.

In 11.1 we will have spaces after commas ignored. As an immediate workaround, please remote space characters from the option value

The ignored prefixed were typed into that post, they weren't copy-pasted. I've got no space characters in the option value at all.

Still faulty in 11.1.105 Pro.

Still faulty in 11.1.105 Pro.

May I ask for the full option value as you have it on your settings so that I can try reproducing the same setup?

Sure. Here it is, copy-pasted from Ignore Name Prefixes:

	Code:
	TBL_,TFN_,V_,tada_,kar_,kr_,tm_,obu_

Or as it can be seen in the SQL Assistant - Option:

Hi,

We have failed to reproduce this issue after testing it in several environment and it worked fine in all of them. Here is something that I have tried personally too in my MariaDB database

	Code:
	CREATE TABLE tada_service_journey(col1 int);

Refreshed cashed, cleared editor, and then typed SELECT * FROM . When prompted typed tada and and selected tada_service_journey, the result is below. Later tried the same after changing the match method and typing serv, the result is still the same

	Code:
	SELECT * FROM tada_service_journey AS sj

Something in the Assistance settings that was brought over from earlier versions seems to interfere with this feature. I've reloaded the factory default for Assistance and the feature started working. I've reloaded my settings (for Assistance only) from a backup and it stopped working again.

Hi

We've managed to reproduce the issue. It's manifesting when Always Add Delimiters option is activated. It's going to be fixed in the next maintenance release.
A simple workaround available ow is setting the ignored prefixes list to TBL_,TFN_,V_,tada_,kar_,kr_,tm_,obu_,`TBL_,`TFN_,`V_,`tada_,`kar_,`kr_,`tm_,`obu_

Thanks a lot for the tip! I couldn't figure out which setting would make the difference.