clearParam removes SQL


I'm accustomed to setting up queries like this:

But I just upgraded to 5.3(.1.95) from 5.2(.9.31) and this code now generates:

Searching for other issues that may relate or show a path out for me; I see this:


Java 1.8.0_202 (Oracle Corporation) 64bit
OS Linux (4.4.0-34-generic) 64bit
Architecture 64bit


Pothys - MitrahSoft
March 19, 2020, 2:45 PM

Once again i checked this ticket and confirmed the issue happened on Lucee latest version SNAPSHOT also. If we execute query once, then the sql was removed from the query. So we try to execute the query once again means it throws an error like "the required sql string is not defined in the body of the query tag, and not in a sql attribute". And added a test case for this ticket.

Pull Request:

Michael Diederich
July 22, 2020, 11:42 AM

Problem still exists in Lucee

Zac Spitzer
July 22, 2020, 11:45 AM
Michael Diederich
October 2, 2020, 12:02 PM

Any updates on this issue?

Zac Spitzer
October 2, 2020, 1:12 PM

I think it’s just a one liner, but I’m not sure why it was done in the first place…. i.e. any side effects?

It’s not actually anything to do with clearParam, calling execute removes the sql


Michael Offner


Brian Harcourt




Fix versions


Affects versions