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

ER_KEY_NOT_FOUND upon attempt to LOAD DATA into sequence

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3
    • Fix Version/s: 10.3, 10.4
    • Component/s: Sequences
    • Labels:
      None

      Description

      --let $datadir=`select @@datadir`
      --write_file $datadir/test/f.data
      0 0 7
      0 0 4
      EOF
       
      SET sql_mode= '';
      CREATE SEQUENCE seq ENGINE=Aria ROW_FORMAT PAGE;
      LOAD DATA INFILE 'f.data' REPLACE INTO TABLE seq FIELDS TERMINATED BY ' ';
       
      # Cleanup
      DROP SEQUENCE seq;
      

      10.3 b50685af825

      mysqltest: At line 9: query 'LOAD DATA INFILE 'f.data' REPLACE INTO TABLE seq FIELDS TERMINATED BY ' '' failed: 1032: Can't find record in 'seq'
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: