tracker issue : CF-4063717

select a category, or use search below
(searches all categories and all time range)
Title:

isNull needs to return false if literal values are provided

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/AsDesigned

Reporter/Name(from Bugbase): / ext-user (Immanuel Noel)

Created: 09/25/2015

Components: Language

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: 295695 /

Priority/Frequency: Normal / Few users will encounter

Locale/System: English / Linux All,Mac 10 All,Solaris All,Win XP All

Vote Count: 5

Problem:

isNull needs to return false if literal values like string, boolean and number are passed. 
This is an offset of the bug, 4028246

Method:
Run,
isNull(33)

Result:
Returns True

Expected:
Return False

Workaround:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4063717

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

I'm quite curious to understand how it matters how the express that represents the argument value is composed.
Comment by External U.
5726 | September 25, 2015 02:02:23 AM GMT
Seems a stupid sort of bug to vote for, but it's more a case that ColdFusion shouldn't get stuff like this wrong.
Vote by External U.
5735 | September 25, 2015 02:03:00 AM GMT
Oops... "expression" rather than "express". Oh that I could edit my own comments :-/
Comment by External U.
5727 | September 25, 2015 03:18:39 AM GMT
Please explain in 25 characters or more how this bug impacts productivity and why you are adding a vote.
Vote by External U.
5736 | September 25, 2015 08:29:42 AM GMT
Um... Immanual... you've got your Result / expected arse-about-face there. Wanna update it?
Comment by External U.
5728 | September 25, 2015 12:19:41 PM GMT
I think the Result and Expected in the ticket are reversed. IsNull(33) returns true but should return false.
Comment by External U.
5729 | September 25, 2015 12:19:49 PM GMT
The ticket description is incorrect and has the result and expected result backwards. The ticket title is correct. Can someone at Adobe please update the ticket description as it's already confused a few people. Method: Run, isNull(33) Result: Return true Expected: Return false
Comment by External U.
5730 | September 25, 2015 12:20:14 PM GMT
Please explain in 25 characters or more how this bug impacts productivity and why you are adding a vote.
Vote by External U.
5737 | September 25, 2015 12:20:28 PM GMT
This is a bug in CF9, 10 & 11. As the title says: isNull needs to return false if literal values are provided Current behaviour: isNull(33) => "YES" Expected behaviour: isNull(33) => False
Comment by External U.
5731 | September 25, 2015 12:54:25 PM GMT
As the title says: isNull needs to return false if literal values are provided
Vote by External U.
5738 | September 25, 2015 12:54:36 PM GMT
+1 ......................
Vote by External U.
5739 | September 28, 2015 02:29:24 AM GMT
Corrected that. Thanks for pointing it out.
Comment by Immanuel N.
5732 | September 28, 2015 02:54:04 AM GMT
As per current design, when a literal is passes as parameter to isNull, ColdFusion tries to search the property with that name in all the scopes. example isNull(123) while return false is 123 is defined in any of CF scopes or otherwise true. This behavior is there for some time and any change in this behavior to return false for a literal would break an existing application. However this is a bug where the above example fails for String literal which needs to be fixed. For that I would request someone to log a bug.
Comment by Awdhesh K.
5733 | August 23, 2016 02:47:49 AM GMT
Logged a separate bug, #CF-4183352, to track the string lookup issue.
Comment by Immanuel N.
5734 | August 23, 2016 11:45:39 PM GMT