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