MySQL Bugs: #53997: please add "LOAD DATA INPIPE" to have normal pipes

Bug #53997	please add "LOAD DATA INPIPE" to have normal pipes
Submitted:	26 May 2010 14:47	Modified:	27 May 2010 3:30
Reporter:	ivo welch	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: General	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The named pipe solutions are really quite ugly.

It would be much cleaner and nicer not to have to mess around too much with the Unix or Windows filesystem, but instead allow

LOAD DATA INPIPE 'gzcat persondata.txt.gz' into TABLE persondata;

How to repeat:

feature request

Suggested fix:
I believe the change to the mysql source should be small.  In C, it requires a simple replacement of fopen with popen (ok, fclose needs to become pclose).  everything else should be the same.

Thank you for the feature request.