What could possibly cause MySQL to hang and not resolve on a query like so.
SELECT * FROM personal LEFT JOIN addresses ON ( personal.recordid = addresses.parentid )
I am well and truly stumped and angry - I've not in 6 years seen MySQL hang on something this trivial, and I've been using it a long time. I know it's something stupid but I can't seem to find it.
The tables do not have the same number of rows, (nor should they, there'd be no point to using separate tables if they do). Hmm...