INSERT query works in draft/debug but not in published agent

[bkermen]

Hi everyone. I’m running into some unexpected behavior with the Query App Database block and wanted to check if I might be missing something.

I’m using a very simple INSERT query:

INSERT INTO MyTable (txt_date, txt_source)
VALUES ({{currentDate}}, 'Manual Run')

This works as expected when I run the agent in draft mode or through the debugger. However, when I run the published agent, no row gets inserted into the table.

What’s confusing is that the debug logs still show: “1 row(s) affected)”.

Has anyone seen something similar or know what might be causing this? Not sure if I’m overlooking something simple or if this could be a bug.

Thanks in advance!

[Alex_MindStudio]

Hi @bkermen,

The issue has been fixed. Now, you can switch between Draft and Live tabs directly in your Database Tables, so test data from draft agent runs won’t affect your real data:

Appreciate you flagging this!