Scott,
> the sad thing is that while MySQL implemented a -ansi switch that
> supposedly turns on ansi compliance, it only fixes about 1/2 of all the
> non-compliance issues. Yet another half-implemented feature... :)
Plus they completely broke ansi-compliance with the latest version of
mysqldump, which is what I'm struggling with. To quote one of the
developers on #mysql:
"Oh, that's not really a bug, it only affects ANSI mode".
However, Perl is superb at pattern-matching, so I've patched for it ...
--
-Josh Berkus
Aglio Database Solutions
San Francisco