Toad World® Forums

Toad Insight exception if you type alias,.


#1

, t.[object_id]

, t,.

When you type the dot after the t, in the line show above, you’ll get this exception:

System.ArgumentOutOfRangeException
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Stack Trace:
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.ThrowHelper.ThrowArgumentOutOfRangeException()
at Quest.Toad.CodeInsight.LanguageDialect.ReadVirtualList(IConnection connection, Insight insight, IncludeInsight include, Boolean filtering, String defaultSchema)
at Quest.Toad.SqlServer.SqlServerLanguageDialect.ReadVirtualList(IConnection connection, Insight insight, IncludeInsight include, Boolean filtering, String defaultSchema)
at Quest.Toad.CodeInsight.BaseDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Insight insight, Boolean secondary, Boolean& hasSecondary, List`1 ownerList)
at Quest.Toad.CodeInsight.BaseDialect.GetInsight(IConnection connection, Chunk chunk, Int32 offset, String defaultSchema, Int32& startOffset, Boolean& hasSecondary, Boolean filtering, Boolean secondary, HotTokenInsight hotToken)
at Quest.Toad.Editor.Commands.InvokeMemberListCommand.FetchMemberListItems(Object editorText)

When using Toad insight (the intellisense feature), if you accidentally type a comma, and then a dot when using a table alias, Toad throws an exception:

For example:SELECT t.[name]FROM sys.tables t
Darren

ToadException.jpeg


#2

This issue was addressed in 5.0.1 patch that is about to be GA’ed.

Igor.