How can we help you today? How can we help you today?

BUG: INSERT auto-fill doesn't find all columns

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
)
zeffi
0

Comments

3 comments

Sort by
  • zeffi
    I forgot to include the versions I use:

    SQL Prompt: 7.0.0.62
    SSMS: 12.0.2000.8
    OS: 6.1.7601

    best regards
    Stefan
    zeffi
    0
  • Aaron L
    Hi 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.
    Aaron L
    0
  • Aaron L
    Hi Stefan,

    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.
    Aaron L
    0

Add comment

Please sign in to leave a comment.