Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-420

Double LOAD DATA LOCAL INFILE fails with commit 02e7d56

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.0.9, 3.1.0
    • None
    • None
    • None

    Description

      The following fails when client multi-statements are enabled and all lines are executed as a single command. The START TRANSACTION fails with a Commands out of sync; you can't run this command now error.

      CREATE OR REPLACE TABLE test.t1(id INT);
      LOAD DATA LOCAL INFILE './data.csv' INTO TABLE test.t1;LOAD DATA LOCAL INFILE './data.csv' INTO TABLE test.t1; -- Note: this line executed as a single mysql_query
      START TRANSACTION; -- this starts to fail with 02e7d5654dd83600f3c1e27b7c61ab1f4ea59138
      SELECT COUNT(*) FROM test.t1; -- should return double the rows that data.csv contains
      COMMIT;
      

      This works before commit 02e7d5654dd83600f3c1e27b7c61ab1f4ea59138 and fails after it.

      Attachments

        Issue Links

          Activity

            People

              georg Georg Richter
              markus makela markus makela
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.