Status/Resolution/Reason: To Fix//BugVerified
Reporter/Name(from Bugbase): Ashwini A. / ()
Created: 09/03/2019
Components: Database, Query-of-Query(IMQ)
Versions: 2018
Failure Type: Incorrectly functioning
Found In Build/Fixed In Build: 5.1.4 (Build 0001) /
Priority/Frequency: Normal /
Locale/System: / Win 2016
Vote Count: 0
Problem Description:The query of query mathematical interpretation, when it has three operands
Steps to Reproduce:
{code:java}
qty1=64
qty2=32
qtyOnHand=96
<cfquery name="test" dbtype="query">
select qtyOnHand,qty1,qty2,qtyOnHand-qty1-qty2 as qty3 FROM test
</cfquery>
{code}
Actual Result: qty3 is 64
Expected Result:0
Any Workarounds: Yes, i have to put the parenthesis qtyOnHand-(qty1+qty2) as qty3Attachments:
Comments: