Problems with QoQ after upgrading to 5.4.3.2

dev support
2

Hi, I had similar problems this morning.
See https://dev.lucee.org/t/error-using-query-of-queries-user-lacks-privilege-version-5-4-x/12905

Try the following …

<cfscript>
	dump(server.lucee.version);
	myQuery = queryNew("field1,field2",
	"integer,integer",
	[{
			"field1": 30,
			"field2": 3
		},
		{
			"field1": 345,
			"field2": 34
		},
		{
			"field1": 123,
			"field2": 12
		},
		{
			"field1": 24,
			"field2": 2
		},
		{
			"field1": 56,
			"field2": 5
		},
		{
			"field1": 44,
			"field2": 4
		},
		{
			"field1": 234,
			"field2": 23
		},
		{
			"field1": 3434,
			"field2": 34
		}
	]);

	dump(myQuery);

	query name="myNewQuery" dbtype="query" {
		echo("
            SELECT field1, field2, ROUND(field1 + field2) AS field3
	        FROM myQuery
		");
	}

	query name="myNewQuery2" dbtype="query" {
		echo("
            SELECT field1, field2, (field1 + field2) AS field3
	        FROM myQuery
	        WHERE (field1 + field2) > 200
        ");
	}

	dump(myNewQuery);
	dump(myNewQuery2);
	
</cfscript>