BUG: INSERT auto-fill doesn't find all columns
zeffi
Posts: 3
If the userdefined datatype of a column has the same name as a table in the database, the autofill of INSERT columns doesn't find these columns:
CREATE TYPE [dbo].[Anvandare] FROM [VARCHAR](16) NOT NULL;
CREATE TABLE Anvandare ( ID INT );
CREATE TABLE [dbo].[Test]
(
ID INT
,Name [dbo].[Anvandare] NOT NULL
);
/*
here I "refresh suggestions"
after that the autofill of the INSERT-statement
will not include the Name-column because the name
of the type is the same as the name of the table Anvandare
*/
INSERT INTO dbo.Test
( ID )
VALUES
( 0 -- ID - int
)
CREATE TYPE [dbo].[Anvandare] FROM [VARCHAR](16) NOT NULL;
CREATE TABLE Anvandare ( ID INT );
CREATE TABLE [dbo].[Test]
(
ID INT
,Name [dbo].[Anvandare] NOT NULL
);
/*
here I "refresh suggestions"
after that the autofill of the INSERT-statement
will not include the Name-column because the name
of the type is the same as the name of the table Anvandare
*/
INSERT INTO dbo.Test
( ID )
VALUES
( 0 -- ID - int
)
Comments
SQL Prompt: 7.0.0.62
SSMS: 12.0.2000.8
OS: 6.1.7601
best regards
Stefan
Thanks for your post - we can reproduce this issue here and we're looking into a fix now. I'll let you know when we have a build with a fix (hopefully later today)
Thanks,
Aaron.
This should now be fixed in the latest beta build (7.1.0.244). If you continue to see any issues on this build please let me know.
Thanks,
Aaron.