Uploaded image for project: 'HPCC'
  1. HPCC
  2. HPCC-21359

MySQL Plugin - Stored Procedure Out of Sync Error

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 7.0.4
    • Fix Version/s: 6.4.34, 7.0.12
    • Component/s: Plugins
    • Labels:
      None
    • Environment:
      ECL IDE

      Description

      I'm trying to call a Stored Procedure from THOR using the MySQL Plugin and I'm receiving the error, "Error: 0: mysql: Commands out of sync; you can't run this command now (0, 0)".

      ECL:

      IMPORT MYSQL;

      DATASET(outputRec) FindLid() :=
      EMBED(mysql : user(mysql_userid),
      server(mysql_server),
      port(mysql_port),
      database(mysql_schema),
      password(mysql_pwd))

      CALL test('123NMAINSTSUNIT1MINNEAPOLISMN55403');

      ENDEMBED;

      testSP := FindLid();
      testSP;

      SP:

      CREATE DEFINER=`lid_agid_admin_d`@`%` PROCEDURE `test`(IN in_str VARCHAR(255))

      BEGIN
      SELECT *
      FROM lid_agid_base
      WHERE uix_address_match = in_str;
      END

        Attachments

          Activity

            People

            • Assignee:
              richardkchapman Richard Chapman
              Reporter:
              glodowskiev Evan Glodowski
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: