No subqueries on DreamHost either
So MySQL can’t cope with subqueries. Something simple like:
select * from competitions where id in (select competition_id from scores where user_id = 1)
From what I’ve read the 4.1.x series should be able to do this. The version on my account claims to be 4.1.8 but the version the server is running is 4.0.23. But it must be pretty new because even the stable version in Gentoo is only 4.0.28. How on Earth did this database get to be so popular?!?! Simple basic things that PostgreSQL has been doing for ages are only getting into MySQL, it’s really beginning to piss me off.
