MySQL UPDATE does not work with store: true

[renemolenaar82]

Describe the issue

When you have store:true in io.kestra.plugin.jdbc.mysql.Query the task will execute but it won't update anything until you remove or disable store. For example:

  - id: wp_user_update
    type: io.kestra.plugin.jdbc.mysql.Query
    store: true
    sql: |
      UPDATE wp_users
      SET user_login = "{{ inputs.email_new }}",
          user_email = "{{ inputs.email_new }}"
      WHERE ID = 123

A task like this executes but won't update anything.

Environment

• Kestra Version: v0.21.1