Is the subject line enough?
Right, so a customer asked if it were possible to run our product on
MySQL. It already supports Unify, Oracle, Postgres.
We write scripts that are very very close to the lowest level of
portable SQL and they need close to no change to run on either of the
above databases. In comes mysql
mysql> create table foo (
-> c_foo integer,
-> show varchar (2)
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'show
varchar (2)
)' at line 3
so, "show" seems to be a reserved word. Err, why exactly? And why for
gods sake do you want backticks to quote fields if I insist on using
those field names?
mysql> create table mod (
-> c_mod integer,
-> mod varchar (20)
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mod (
c_mod integer,
mod varchar (20)
)' at line 1
So, "mod" is also a reserved word? Anything else you want to take away
from me?
mysql> select count (*) from usr;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '*)
from usr' at line 1
WTF, where on earth did you read that a space is not allowed before an
opening paren on an aggregate function? All other databases I've seen
so far, including SQLite and DBD::CSV allow it. You moron!
MySQL is obviously NOT my database.
But then again all other databases have their own shortcomings too.
None of them is perfect but this is beyond belief.
MySQL, I HATE YOU!
--
H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/
using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
