Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18292

CONNECT Engine JDBC not able to issue simple UPDATE statement from trigger or stored procedure

    Details

      Description

      Assume we have a CONNECT JDBC table called ProductVariants. I can successfully issue the following command:

      UPDATE ProductVariants
      SET InventoryQuantity = 3
      WHERE Id = 21163284529232
      

      The above works with hard coded values when issued direct, works when issued via a stored procedure, but does NOT work when issued via a trigger (on another table). With the trigger you get the following error:

      Table 'ProductVariants' is marked as crashed and should be repaired) #1194
      

      Of course hard coded values are useless, what I was originally trying to do via a trigger was the following:

      UPDATE ProductVariants
      SET InventoryQuantity = v_new_qty
      WHERE Id = v_ProductVariantId;
      

      where v_new_qty and v_ProductVariantId are declared as BIGINT and so are the corresponding connect columns. This command produces different errors depending on if issued via a trigger or stored procedure. When issued via a trigger the error is:

      Table 'ProductVariants' is marked as crashed and should be repaired) #1194
      

      When I call a stored procedure and pass in the values the error is:

      Got error 122 'ExecuteUpdate: XcoreXshopifyX180X6886.dlb: At least ID should be specified in this SQL statement. n=-1' from CONNECT
      

      In the stored procedure scenario it looks like it is somehow not seeing the variables. In the trigger case I have no idea.

      This is in a critical code path for a client deployment unfortunately, and we can't find a work around so a bug fix is critical for us.

      Thank you!

        Attachments

        1. ProductVariants.csv
          3 kB
        2. ROG_Lines.csv
          0.2 kB
        3. ROG.csv
          0.2 kB
        4. test_db11615.sql.gz
          16 kB
        5. trigger_test_3.sql
          2 kB
        6. Triggers.sql
          4 kB
        7. Vendor_Items.csv
          1 kB
        8. Vendors.csv
          0.5 kB

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              rdyas Robert Dyas
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: