Hi I've been having a strange issue with the LOAD DATA INFILE query after doing a reconnect in rails.
I have a process that can potentially take a while to parse a large amount of data. After the parsing is complete, I want to import that data into the database using LOAD DATA INFILE, however, I get an error: "ActiveRecord::StatementInvalid: Mysql::Error: The used command is not allowed with this MySQL version" Before the reconnect, I am able to use that query just fine, and I've doubled check my configurations and everything.
I also filed a ticket: https://rails.lighthouseapp.com/projects/8994/tickets/6266-cannot-execute-mysql-load-data-infile-query-after-using-verify_active_connections
One person on there seems to have found the solution, but it involves making a change/fix to the mysql adapter code in Rails core.
Any suggestions on how this can be fixed external? or how I can get the Rails guys to fix it?
