Icon View Incident Report

Serious Serious
Reported By: Piotr Font
Reported On: 2/5/2010
For: Version 2.03 Build 8
# 3146 Large Column Sizes in ORDER BY Can Cause Infinite Loop When Navigating Result Set

The following query causes an infinite loop when navigating the query result set using next and prior.

SELECT
File.FileID,
PathDictionary."Path",
FileDictionary."Name",
CompanyDictionary."Name"  Company
FROM File
INNER JOIN  PathDictionary ON
File.PathDictionaryID = PathDictionary.PathDictionaryID
  INNER JOIN FileDictionary ON
File.FileDictionaryID = FileDictionary.FileDictionaryID
  LEFT JOIN CompanyDictionary ON FileDictionary.CompanyDictionaryID = CompanyDictionary.CompanyDictionaryID
WHERE ( NodeId=1 ) AND (File.Deleted = false) AND
   (File.UserActivity = false)
ORDER BY FileDictionary."Name"



Comments Comments
The problem was caused by very large index keys in the ORDER BY that EDB wasn't handling properly in the result set sorting.


Resolution Resolution
Fixed Problem on 2/15/2010 in version 2.03 build 9


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image