4Site
Support Request System
View Patch #60.001.080
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03862 -
Can't open a spare turnaround. Get SQL error about ORDER by clause
Symptoms:
When running under SQL 2000, attempting to open any turnaround to idenify spares results in "ORDER BY items must appear in the select list if the statement contains a UNION operator"
Solution:
This is actually a result of a bug in SQL 2000 where the parser gets confused between an ORDER BY in a sub-SELECT and an UNION between main SELECTs. The SQL statement has been changed to work around the problem with SQL 2000. Note that SQL 2005 and 2008 were unaffected.
Browse Patches
Find a Patch
Return to Request System Menu
