I’ve run into a QofQ issue with Lucee 5.4.3.2 and using the 5.4.3.10-SNAPSHOT
The same QofQ has worked on all past versions of Lucee through 5.3.12.1
returning a single record
With the latest version, 5.4.3.2, I’m receiving the error “incompatible data type in conversion”
Is this a bug?
<cfscript>
dump(server.lucee.version);
myQuery = queryNew("navid, type, url",
"decimal,decimal,VarChar",
[{
"navid": 200,
"type": 1,
"url": "football"
},
{
"navid": 201,
"type": 1,
"url": "baseball"
},
{
"navid": 202,
"type": 1,
"url": "basketball"
},
{
"navid": 20010,
"type": 2,
"url": "offense"
},
{
"navid": 20011,
"type": 2,
"url": "defense"
},
{
"navid": 20012,
"type": 2,
"url": "goalie"
},
{
"navid": 20210,
"type": 2,
"url": "offense"
},
{
"navid": 20211,
"type": 2,
"url": "defense"
}
]);
dump(myQuery);
query name="myNewQuery" dbtype="query" {
echo("
select navid, type, url
from myQuery
where url = 'offense'
and type = 2
and left(navid, 3) in (select navid
from myQuery
where type = 1
and url = 'football')
");
}
dump(myNewQuery);
</cfscript>
-------------------
I have also tried changing the first two field types to "integer" in the example with the same result.
myQuery = queryNew(navid, type, url,
integer,integer,VarChar,
-------------------
OS: Windows Server 2019 (10.0) 64bit
Java Version: 11.0.20 (Eclipse Adoptium) 64bit
Tomcat Version: 9.0.78
Lucee Version: Lucee 5.4.3.2