Toad World® Forums

result error - critical


#1

When running query like this:

select 1 , [name] from sys.objects

In result first column which has no name [it gets no default]!

It causes bad result eg when exporting to csv.

When such result is being sent to Histogram Tool it results in:

System.IndexOutOfRangeException

Column doesn’t exist

Stack Trace:

w Quest.FastData.FastRow.get_Item(String columnName)

w Quest.Toad.DataCleansing.ColumnHistogramController.b__0(FastRow
row)

w System.Linq.Lookup2.Create[TSource](IEnumerable1 source, Func2 keySelector, Func2 elementSelector, IEqualityComparer`1 comparer)

w System.Linq.GroupedEnumerable`3.GetEnumerator()

w System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()

w System.Linq.Buffer1..ctor(IEnumerable1 source)

w System.Linq.OrderedEnumerable`1.d__0.MoveNext()

w System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()

w System.Linq.Enumerable.d__3a`1.MoveNext()

w Quest.Toad.DataCleansing.ColumnHistogramController.GetLinqData()

w Quest.Toad.DataCleansing.ColumnHistogramController.DoRefreshDataLinq()

imho severity is critical.

Butter

int_1.jpeg
int_1.jpeg


#2

Hi Marcin,

CR83404 was created. Thanks for the reporting.

regards,

Alexander Maximov
int_1.jpeg