August 27, 2004


I'm not the most stable human right now. It's 7:28 on a Friday evening, and I'm WORKING. Why am I working? Well, at 3 p.m., I declared myself too frustrated to work and left for home. After a calming weightlifting session and a good dinner, I rededicated myself to the task at hand. Which is trying a somewhat difficult query in MySQL - difficult because I can't get the damned thing to work. I found the nice documentation on MySQL's site, and huffed and puffed and huffed and puffed (and threw stuffed animals...because that's my temperament) but just couldn't blow this house down.

And I'm madder now that I know why.

You see, the current production-level release of MySQL doesn't support subqueries - only the 4.1 beta release. Sorry, not taking beta into a client's production environment. See, this nice person told me so in very succinct words.

Unfortunately and obnoxiously, MySQL's online documentation is seemingly for the 4.1 product, even though it's still beta. Nowhere in red will you, the skimming reader who normally finds this part of the job a breeze, see the "you can't do this here text" or that the version documented is not the production version. It's. simply. not. there.

Pardon me while I deadrenalize over my wasted time I don't have. Even the cats are running away.


Posted by hln at August 27, 2004 07:36 PM | Anecdote | TrackBack

[leaves chocolate]
[runs away in terror]

Posted by: Harvey at August 28, 2004 08:33 AM

[leaves DARK chocolate]
[runs away in terror]

Posted by: Harvey at August 28, 2004 01:15 PM

Mmm, chocolate.
[Leaves PostgreSQL, sneaks away silently.]

Posted by: Pixy Misa at August 29, 2004 12:08 PM

Hey, free PostgreSQL!

[Leaves Anacondas: The Hunt for the Blood Orchid, the worst sequel of all, and carefully planting a chocolate Pixy Misa fingerprint on it, sneaks away quickly.]

Posted by: Brian J. at August 29, 2004 04:42 PM

Hmmm - looks like I'm late as usual. Looks like Harvey and Pixy were trying to help. So, I'll send some "I'm so there with you" commisserating waves. I LOATHE documentation. It generally does NOT tell you what you need to know and leaves you high and dry for no discernable cause.

Well, at the very least you did find out why. But this is how much hair is lost and why many pets become neurotic. Hope this week goes better.

Posted by: Teresa at August 30, 2004 05:20 PM

Burn the tech writers!

Posted by: Brian J. at August 31, 2004 01:13 PM