evaluation version 3.5.0.333 and [] object

ugoreda

I was in the process of testing the evaluation version of sql prompt 3.5.0.333

if you type:

SELECT
o.[name]
FROM
[sys].[sysobjects] o
-- nothing here
INNER JOIN [sys].[sycolumns] c
ON (
o.[id] = c.[id]
)

and then start writing:

SELECT
o.[name]
FROM
[sys].[sysobjects] o
-- add this line (typing, not copy and paste)
INNER JOIN []
-- ....
INNER JOIN [sys].[sycolumns] c
ON (
o.[id] = c.[id]
)

I get the error:
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlPrompt.Engine.AbstractCandidate.CompareTo(ICandidate other)

issue is that when I enter [, autocompletes enters [] and [] is not an identified objects, hence the crash...


it is VERY annoying,
is this issue in the process of correction?

Bart Read

Hi there,


Thanks for reporting this and sorry for the trouble it's caused you. I've found and fixed the problem, and the fix will be available in the next version.


Thanks,
Bart

ugoreda

Hello, thanks for this quick reply and solution!

UgoReda