Bug #5996 Views: LOAD DATA doesn't work
Submitted: 8 Oct 2004 21:35 Modified: 22 Oct 2004 7:51
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[8 Oct 2004 21:35] Peter Gulutzan 
Description:
LOAD DATA doesn't work with views. 
 
 
 

How to repeat:
CREATE TABLE table2 (s1 char, s2 char); 
INSERT INTO table2 VALUES ('a','a'); 
CREATE VIEW view2 AS SELECT * FROM table2 WHERE s1 <> 'a' WITH CHECK 
OPTION; 
SELECT * INTO OUTFILE '/tmp/data.txt' FIELDS TERMINATED BY ',' FROM table2; 
LOAD DATA INFILE '/tmp/data.txt' INTO TABLE table2 FIELDS TERMINATED BY ','; 
LOAD DATA INFILE '/tmp/data.txt' INTO TABLE view2 FIELDS TERMINATED BY ',';
[8 Oct 2004 21:41] MySQL Verification Team 
Verified against latest BK source.
[21 Oct 2004 18:54] Oleksandr Byelkin 
ChangeSet 
  1.1670 04/10/21 21:53:27 bell@sanja.is.com.ua +7 -0 
  added support of view and CHECK OPTION of view to LOAD DATA (BUG#5996)
[22 Oct 2004 7:51] Oleksandr Byelkin 
Thank you for bugreport! Bugfix is pushed into source repository.