Reported By: Tom Reported On: 7/14/2007 For: Version 1.04 Build 5
# 2414UNION with ORDER BY Does Not Work Without Parentheses The following does not work.
SELECT * FROM MyTable
UNION
SELECT * FROM MyTable
ORDER BY MyColumn
Comments and WorkaroundsThe workaround is to use parentheses around the second query.
ResolutionFixed Problem on 7/18/2007 in version 1.04 build 6
Products AffectedElevateDB 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 VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial