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

Identity seed causes an error

If you try to type the following code in SSMS 2008: 
create table test (a int identity (1, 1))

you'll get an "Object reference not set to an instance of an object"
and the following details (I copied only the first part):
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Parser.SqlParser.HasParameters(ITreeNode& nameTail, Int32& paramIndex)
at RedGate.SqlPrompt.Parser.SqlParser.GetCandidateList(String source, Int32 offset, Boolean caseSensitive)
at RedGate.SqlPrompt.Engine.NewEngine.SqlPrompt4Engine.GetCandidates(Int32 offset)
at RedGate.SqlPrompt.Engine.PromptEngineEmulator.get_GetSuggestions()
at RedGate.SqlPrompt.Engine.PromptEngineEmulator.get_IsWildcardExpansionAvailable()
at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.OnCaretPoitionChanged()
at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.OnTextViewCommandExec(TextViewMonitor sender, EventArgs e)
at RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.Exec(Guid& pguidCmdGroup, UInt32 nCmdID, UInt32 nCmdexecopt, IntPtr pvaIn, IntPtr pvaOut)
George Palacean
0

Comments

1 comment

Sort by
  • tanya
    Hi George,

    Thank you for reporting the issue.
    We have been able to replicate the crash and will have it fixed for the beta release.
    Apologies for the inconvenience caused.

    Regards,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.