QoQ throws an error when variables scoped as [local]

Description

<cfscript>
local ={};
local.q_asset = queryNew('asset,asset_id');
</cfscript>
<cfquery name="qTest" dbtype="query">
select asset, asset_id
from [local].q_asset
group by asset, asset_id
order by asset
</cfquery>
<cfdump var=#qTest#>
throws the following error
Lexical error at line 2, column 17. Encountered: "[" (91), after : ""

this works fine in ACF

http://www.bennadel.com/blog/94-local-variables-scope-conflicts-with-coldfusion-query-of-queries.htm

I think the brackets [ ] should just be parsed as whitespace?

Environment

None

Activity

Show:
Pothys - MitrahSoft
September 27, 2017, 3:10 PM

Hi ,

Yes, I've tested with both mySql & SqlServer. It throws the same error.

Dave Merrill
October 18, 2017, 10:33 AM

Works for me on Lucee 4.5.3.020, 5.6.35-log, Linux - 2.6.32-431.29.2.el6.x86_64, after fixing the error in the test code provided in the original description .

There's no 'asset_id' column, columns are asset and id.

Zac Spitzer
October 18, 2017, 10:46 AM

have a look the test case (i deleted the attachments, they were wrong)
https://github.com/lucee/Lucee/pull/314/commits/c4f591d7adb9f9f8becc0521407d35b65dcf413e

Zac Spitzer
October 26, 2020, 10:48 AM

also solved by

Michael Offner
October 28, 2020, 1:46 PM

fixed by the QoQ update

Fixed

Assignee

Michael Offner

Reporter

Zac Spitzer

Priority

Minor

Labels

Fix versions

Affects versions

Configure