I have a call to a function that contains a query. The function fires at every step, as debug messages will let me know, but the query is not firing. I can find no evidence of it in MariaDB's logs, or Lucee's logs.

To simplify this, I have placed a simplified version of the query directly where the function call goes.

The simplified query is as follows

QueryExecute(sql = "INSERT INTO MyMessages (AuthorID, mSubject, mDate, mContents)
Values (21, 'direct', Now(), '{}')",
options = {datasource = "dsn_global"})

I know for a fact that the logical flow is reaching this query, even though it isn't firing, because if I remove the datasource specification, I get an error that my application's default datasource doesn't contain a table MyMessages (which it shouldn't). If I set the datasouce again, all evidence of the query disappears.

I query this datasource in other parts of my application, and it works fine including working with this table.

I am aware that this issue probably sounds like something I'm misunderstanding, but QueryExecute is being called, it just isn't doing anything. It moves on to the code after it.