While processing some radar data at the office last week, I ran into a little problem. I found that individually, two of my stored procedures were working fine, but having one call the other caused problems. It would call the procedure, but it wouldn't actually do anything.

After some investigation, I realized one of my in variables was the same as the name of a field in a select query for a cursor. What I think MySQL was doing was replacing the value of the in variable into the select query rather than seeing it as a field name. I'm sure this is still possible to do if you escape the field name with `field_name` rather than just field_name.

I just wanted to throw this little tidbit of information out there for anyone else running into a similar problem. Don't name your in variables the same as a column name!!

A few months ago I found an Objective-C framework called SMySQL for connecting to MySQL databases via Objective-C. I wanted to test it out, so I tried writing a small test program that used it. That's when I found out that the SMySQL framework hadn't been updated since 2006, before Apple switched over to Intel processors. So I tried my hand at creating a universal binary version of the SMySQL framework.

The first thing I realized was that in order to make a universal binary framework that links to MySQL, I also need a universal binary of libmysqlclient (.a and .dylib). Unfortunately at this time, MySQL is not distributing universal binary versions of mysql. They only have versions for the individual processor types ppc, ppc64, x86, and x86_64.

So we start by downloading the source for MySQL here. Unarchive that and cd into the mysql source folder. Now set the following environment variables:



These let the ./configure script know that we want to build a universal binary for OS X 10.5. Next, you need to run the ./configure script with whatever options you want included or disabled in your copy of MySQL. The only option you must use as a configure option is --disable-dependency-tracking. GCC 4.0 will not build for multiple architectures when using dependency tracking. Here's the configure command line I used:



Once that finishes, run make, and a little while later, you have yourself a universal binary version of MySQL and its libraries.

The SMySQL Framework can be found at code.google.com. It was originally written by Serge Cohen and his original project is hosted at sourceforge.net. I attempted to contact Serge via the sourceforge project page to give him a copy of the updated Xcode project but never heard back from him.