 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[12.4.476 Pro] - Mishandling of aliases in SQL Server |
|
The aliases for tables in SQL Server are not handled correctly. For example, I have a table named Adatblokk_copy which was created using the Clone feature. I have an alias pointing to that table, it is called Adatblokk.
The alias was created by this statement:
 |
 |
CREATE SYNONYM [dbo].[Adatblokk] FOR [EN_DATABLOCKS].[dbo].[Adatblokk_copy];
|
When hovering over the table/alias name in
 |
 |
SELECT [whatever] FROM [dbo].[Adatblokk];
|
the popup shows this:
which is a bit weird (and incorrect).
Also, when I ctrl+click on a column in, eg. the SI:
 |
 |
SELECT a.[AdatblokkId], a.[SI] FROM [dbo].[Adatblokk] AS a;
|
I get an error:
 |
 |
Msg 208, Level 16, State 1, Invalid object name 'EN_DATABLOCKS.dbo.[dbo].[Adatblokk_copy]'....
|
|
|
Tue Apr 09, 2024 2:35 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you for letting us know. I submitted a bug report for this issue. Tacking ticket number #SA0044513.
|
|
Tue Apr 09, 2024 8:31 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
Has there been any progress on this matter? It's still present in 13 beta.
|
|
Tue Jul 23, 2024 4:30 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
This seems to be still not fixed. I'm not able to provide an ETA yet. We will address it as soon as possible.
|
|
Wed Jul 24, 2024 1:19 pm |
|
 |
|
|
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
|
|
|