In a Teradata 13.1 database, user executes large results in SQL trying to scroll up/down in the results.
The following error is generated. User felt that the SQL should have stopped at the upper limit set in the options like it does for Oracle.
System.OutOfMemoryException
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace:
at System.Data.Common.Int64Storage.SetCapacity(Int32 capacity)
at System.Data.RecordManager.set_RecordCapacity(Int32 value)
at System.Data.RecordManager.GrowRecordCapacity()
at System.Data.RecordManager.NewRecordBase()
at System.Data.DataTable.NewRecordFromArray(Object[] value)
at System.Data.DataTable.LoadDataRow(Object[] values, Boolean fAcceptChanges)
at Quest.FastData.SystemDatatypeConversion.DatatypeLoadDataRow(DataTable table, FastTable fastTable, Object[] originalRow, Object[] newRow)
at Quest.FastData.SystemDatatypeConversion.LoadDataRow(DataTable table, FastTable fastTable, Object[] originalRow, Object[] newRow)
at Quest.FastData.FastTable.GetDataTable(IFastConversion conversion, IFastTask& task, FastDataTaskStartedHandled started)
at Quest.FastData.FastTable.GetDataTable(IFastConversion conversion)
at Quest.Toad.PivotGrid.ToadPivotGridControl.AnalyzeData(IDataSourceControl grid)
Enable this option: Tools | Options | Database | General apply to Editor.
In Toad for Data Analysts, this option is disabled by default because it would cause locking issues in same databases.
Enabling this will limit the fetching and have the same behavior as Toad for Oracle.
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center