cfquery returnType Array return NULL whereas returnType Query return empty string with Partially NULL Support

Description

I converted CFQUERY returnType from query to array and I notice that a array having NULL value whereas a Query don't have NULL value (It returns with blank string). I have not enabled Complete NULL Support. I think it should return blank value in returntype array as well.

My lucee version is 5.3.1.102.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 <cfquery name="qGetData" datasource="#variables.dsn#"> SELECT 1 AS id, null AS value UNION SELECT 2 AS id, 'foo' AS value; </cfquery> <cfdump var="#qGetData#"> <cfquery name="qGetData" datasource="#variables.dsn#" returntype="array"> SELECT 1 AS id, null AS value UNION SELECT 2 AS id, 'foo' AS value; </cfquery> <cfdump var="#qGetData#">

Thanks, Bharat

Status

Assignee

Michael Offner

Reporter

Bharat Patel

Labels

None

Sprint

None

Fix versions

Affects versions

5.2.9.31
5.3.2.41

Priority

Major