We also wanted to share our queries that failed, but now work with hotfix: hf201800-4212383
Union is in the QoQ:
// Simple Query 1
var q1 = queryExecute("
SELECT * FROM `table` WHERE `something` = 'something'
",
{},
{
'datasource': REQUEST.objEnv.getDSN("database","R")
}
)
// Simple Query 2
var q2 = queryExecute("
SELECT * FROM `table` WHERE `something` = 'something'
",
{},
{
'datasource': REQUEST.objEnv.getDSN("database","R")
}
)
// Query of above Queries that causes issue
var q3 = queryExecute("
SELECT * FROM q1
UNION
SELECT * FROM q2
ORDER BY lastname
",
{},
{
'dbtype': 'query'
}
)
Union is in the original query that is later queried:
// Initial query with union.
// I think this is fine on its own
var q1 = queryExecute("
SELECT * FROM `table` WHERE `something` = 'something'
UNION
SELECT * FROM `table` WHERE `something` = 'somethingelse'
",
{},
{
'datasource': REQUEST.objEnv.getDSN("database","R")
}
)
// Query of query with union that causes issue
// Requires loop. Error is the "index out of bounds" error
var q2 = queryExecute("
SELECT * FROM q1
ORDER BY lastname
",
{},
{
'dbtype': 'query'
}
)
for (var i=1; i<=q2.recordcount; i++) {
queryGetRow(q2, i);
}
We were able to resolve with the hotfix, but it was then unresolved when the log4j update came out. We had to reapply the hotfix after cf2018 update 13.
The hotfix needed to go into cfusion/lib/updates, not cfusion/hf-updates. That threw us for a loop too.
58
Replies
AdChoices