SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.0.35 Pro] - BUG: Aliases-Ignore Name Prefixes

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[11.0.35 Pro] - BUG: Aliases-Ignore Name Prefixes
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [11.0.35 Pro] - BUG: Aliases-Ignore Name Prefixes Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Still faulty in 11.1.105 Pro.
Wed Nov 27, 2019 5:38 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
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:

Sat Nov 30, 2019 5:02 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
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

Mon Dec 02, 2019 6:20 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Thanks a lot for the tip! I couldn't figure out which setting would make the difference.
Thu Dec 05, 2019 4:45 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.