![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
[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.
|
|
Tue Nov 05, 2019 6:58 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
In 11.1 we will have spaces after commas ignored. As an immediate workaround, please remote space characters from the option value
|
|
Sun Nov 10, 2019 9:33 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
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.
|
|
Mon Nov 11, 2019 3:55 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
Still faulty in 11.1.105 Pro.
|
|
Wed Nov 27, 2019 5:38 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
May I ask for the full option value as you have it on your settings so that I can try reproducing the same setup?
|
|
Fri Nov 29, 2019 11:07 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
Sure. Here it is, copy-pasted from Ignore Name Prefixes:
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
TBL_,TFN_,V_,tada_,kar_,kr_,tm_,obu_
|
Or as it can be seen in the SQL Assistant - Option:
![](https://i.imgur.com/zFNBbVD.png)
|
|
Sat Nov 30, 2019 5:02 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
SELECT *
FROM tada_service_journey AS sj |
|
|
Mon Dec 02, 2019 6:20 pm |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
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.
|
|
Mon Dec 02, 2019 7:36 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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_
|
|
Thu Dec 05, 2019 1:46 am |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
Thanks a lot for the tip! I couldn't figure out which setting would make the difference.
|
|
Thu Dec 05, 2019 4:45 am |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|