in reply to Re^3: MAC OS 10.6 upgrade breaks DBD:mysql
in thread dyld: lazy symbol binding failed (was MAC OS 10.6 upgrade breaks DBD:mysql)
I did exactly the same: Install mysql 5.4.1beta 64bit binary from mysql developer website. recompile dbd::mysql.
It SEEMS to work fine, but I am having a load of very very strange issues when selecting from tables with blob/text columns.
Basically, what happens is that I get NULL return values sometimes. Sometimes in this case means not just sporadic, but reproducibly for one script while I'm testing it. However, it's also random, because changing the script, without changing any of the queries, suddenly causes the queries to return data. It's driving me nuts, this error. Yesterday I thought I nailed it, it seemed that always the last requested column of the query returned NULL. Today, I changed the query back to where it was failing yesterday, and suddenly it works again. I'm at a loss. I tried the DBD::mysql mailing list, noone had a clue there, either.
Oh wise perl Monk, hast though any idea how to salvage my script?
Actually, I figured out why the behaviour is so unpredictable: The bug must have to do with the actual mysql server doing some caching: When I run a query on the table containing the TEXT column in Sequel (a mysql client for Mac), and then run the perl script immediately afterwards, it works. A few hours later, it doesn't work any more. Now how weird is that?!