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

Embedded TRANSFORM in MySQL failing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Not specified
    • Resolution: Fixed
    • Affects Version/s: 6.0.0
    • Fix Version/s: 6.0.2
    • Component/s: Plugins
    • Labels:
      None

      Description

      Using test code of the form:

      TRANSFORM(childrec) mysqlTransform(string name) := EMBED(mysql : server(myServer),user(myUser),database(myDB))
        SELECT * from tbl1 WHERE name=? LIMIT 1;
      ENDEMBED;
      
      testMySQLTransform() := PROJECT(init, mySQLTransform(LEFT.name));

      Gives an error:

      EXCEPTION: mysql: Attempt to read a row while there is no result set associated with the statement

      (lazyExecute() is not working as intended)

        Attachments

          Activity

            People

            • Assignee:
              richardkchapman Richard Chapman
              Reporter:
              richardkchapman Richard Chapman
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: