I'm running an insert select into a new table with a foreign key check constraint and getting an error 3807 Object Spool 2 does not exist. when I run the select part of the query it works fine. when I take the foreign key off the table being inserted to it works fine.
I can't even run an explain on the insert query - which implies its not my data.
Has anyone come across this before or have any immediate ideas ?