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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.7
    • Server
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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