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

Invisible columns and LOAD DATA don't work well together: ER_WARN_TOO_FEW_RECORDS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: 10.3.7
    • Component/s: Server
    • Labels:
      None

      Description

      Since the main characteristic of invisible columns is to be transparent for operations like INSERT, it's reasonable to expect that the same applies to LOAD DATA; but it doesn't – LOAD DATA without specifying the field list doesn't work for any types of invisible columns.

      create or replace table t (a int, b int invisible);
      insert into t values (1),(2);
      select * from t into outfile 'f';
      load data infile 'f' into table t;
      

      10.3 d71a8855eef

      MariaDB [test]> load data infile 'f' into table t;
      ERROR 1261 (01000): Row 1 doesn't contain data for all columns
      

      set debug_dbug= "+d,test_completely_invisible";
      create or replace table t (a int);
      set debug_dbug= "";
      load data infile 'f' into table t;
      

      10.3 d71a8855eef

      MariaDB [test]> load data infile 'f' into table t;
      ERROR 1261 (01000): Row 1 doesn't contain data for all columns
      

        Attachments

          Activity

            People

            Assignee:
            sachin.setiya.007 Sachin Setiya
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: