WsSQL is executing outdated published queries due to a caching issue.

If the original published query is deleted, and a new query with the same name is published, then WsSQL will call the workunit of the older query with the same published query name.

As a workaround, the old workunit that compiled the original roxie query is deleted, which forces WsSQL to use the more updated workunit.