add function queryLazy

Description

we add this function, because <cfquery lazy="true"> does not work with MySQL because of the limitation of the MySQL JDBC implementation.
cfquery produces a query object that can be used more than once and MySQL only supports streaming with the "forward_only_cursor", what is incompatible with the query object.

the function queryLazy will need a function passed in as an argument, that then will be called by QueryLazy to pass the records. So the function will not create a query as result.

Activity

Show:
Michael Offner
April 8, 2020, 3:16 PM

Zac Spitzer
April 14, 2020, 7:01 PM

call this script with ?f=struct

 

lucee.runtime.exp.NativeException: java.lang.NullPointerException at lucee.runtime.type.util.StructSupport.invalidKey(StructSupport.java:65) at lucee.runtime.type.StructImpl.get(StructImpl.java:139) at lucee.runtime.functions.query.QueryLazy.exe(QueryLazy.java:229) at lucee.runtime.functions.query.QueryLazy.call(QueryLazy.java:132)

Pothys - MitrahSoft
April 17, 2020, 2:45 PM

Hi , I've checked as per your code. But, it works fine for me. I couldn't face any error.

Zac Spitzer
April 17, 2020, 2:58 PM

check the commit logs since i posted that… was fixed with referencing the task in the commit

Fixed

Assignee

Michael Offner

Reporter

Michael Offner

Labels

Fix versions

Priority

Minor
Configure