Sybase, ANSI compliant? Phooey.
Here's another nail in it's coffin in my mind - full join.
So, Adaptive Server Anywhere supports Ansi full join, as does IQ (Sybase's data warehouse product), but their flagship Adaptive Server Enterprise (mmmm, Enterprise) doesn't?
Instead I have to distinct union together the left and right outer join...
Update: Oh, and a blank string coerces to a date of 1/1/1900. Brilliant.
Update: brillant. Like MySQL, Sybase would rather silently ignore your bugs than report them:
- commit: If no transaction is currently active, the commit or rollback statement has no effect on Adaptive Server.
11:05 AM, 18 Jan 2007 by Mark Aufflick Permalink