View Incident Report

Serious

Reported By: Rolf Frei
Reported On: 7/24/2002
For: Version 3.12 Build 1

# 1165 Using Explicit SQL SELECT Columns Followed By All Columns (*) Causes Incorrect Fields in Result Set

This query puts the first field (expression 0/1) at the end of the result and so this query (Group and Order) returns false results. FYI: The same affect is also with a normal qurey (not an Union) with an expression in it

SELECT 0, * FROM Parts
WHERE Enabled = 1 and PartNo = '010702'
GROUP BY 1, PartNo
ORDER BY 1, PartNo
UNION
SELECT 1, * FROM Parts
WHERE Enabled = 1 and (PartNo = '010093' or MasterPartNo = '010093')
and PartNo <> '010702'
GROUP BY 1, PartNo
ORDER BY 1, PartNo

Resolution

Fixed Problem on 8/2/2002 in version 3.13 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap