I agree

I need to do something in MySQL that requires a sub select (select a from table_1 where a in (select b from table_2)) . of course MySQL 3.22.x doesn’t support that sort of query, so I’m compiling 3.23.37 right now.

it’s that or write lots and lots of code to by pass this little MySQL 3.22 shortcoming…

About Kevin Sonney

Kevin Sonney - who, contrary to popular opinion was NOT raised by wolves - grew up in central North Carolina. He fell into the technology field by accident in 1991, when he gave up the wild and crazy lifestyle of an on-air AM radio DJ to become a mundane technical support monkey. The technology industry has never really recovered from this. Kevin has worked for such names as IBM, Red Hat, webslingerZ, and Lulu Technologies (we won't mention the ones that didn't survive the experience). He currently works as a Linux Administrator for Apptio. In his spare time he rescues stray animals and plays video games with his two sons. His wife, we're sad to say, helps him get past the really hard bits. Kevin is still not very mundane, he just got better at hiding it.
This entry was posted in Uncategorized. Bookmark the permalink.

7 Responses to I agree

  1. katzj says:

    mysql 3.22.x sucks in a lot of strange and perverse ways… and isn’t free software to boot! :)

  2. alchemist says:

    And if it works, the hard part will be getting the wZ sysadmins to upgrade the production box to the most recent stable version…

  3. badger says:

    *ahem*

    *THWAP*

    :)

  4. alchemist says:

    I deserved that.

    But even I would need more than “I want this feature” to upgrade a production database server to the latest code *grin*

    And anyway, MySQL still doesn’t support sub-selects. *sigh*

  5. badger says:

    Latest even stable dev, eh. Latest stable production build, try & mention it earlier than Monday afternoon for a Tuesday project deadline in case we are working on an unrelated meltdown :). And I can’t help it if mysql doesn’t support subselects. Does postgres? Just do not mention Oracle.

  6. alchemist says:

    Probably an unrelated problem. While postgres supports subselects, and Oracle would do the job, I’m not about to convert a live site to postgres just because I want/need a subselect.

    Bleck. I’ll just convert it to a different sql handler for that page *grin*.

    Of course, if there *IS* a MySQL issue right now, email me on the work addy, and I’ll help…

  7. badger says:

    I’m having deja vu reading this.

Comments are closed.