[MDEV-15965] Invisible columns and LOAD DATA don't work well together: ER_WARN_TOO_FEW_RECORDS Created: 2018-04-21  Updated: 2018-05-15  Resolved: 2018-05-15

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3
Fix Version/s: 10.3.7

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
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



 Comments   
Comment by Sachin Setiya (Inactive) [ 2018-04-26 ]

http://lists.askmonty.org/pipermail/commits/2018-April/012465.html

Comment by Sachin Setiya (Inactive) [ 2018-04-26 ]

Documentation needs to be updated

Generated at Thu Feb 08 08:25:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.