clearParam removes SQL

Description

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:
https://luceeserver.atlassian.net/browse/LDEV-1750

Environment

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

Activity

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

Once again i checked this ticket and confirmed the issue happened on Lucee latest version 5.3.6.20 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: https://github.com/lucee/Lucee/pull/888

Michael Diederich
July 22, 2020, 11:42 AM

Problem still exists in Lucee 5.3.6.61

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

Assignee

Michael Offner

Reporter

Brian Harcourt

Priority

Major

Labels

Fix versions

None

Affects versions

Configure