In light to MySQL's direction of entering the enterprise DB arena, here are a few MySQL gotcha's for quick review. quite relevant topic on those tricky non-SQL compliant features of MySQL.
http://sql-info.de/mysql/gotchas.html On Thu, 2005-04-14 at 15:10, Bopolissimus Platypus Jr wrote: > On 4/14/05, Miguel A Paraz <[EMAIL PROTECTED]> wrote: > > > Yeah, but I'm wondering why they didn't make --enable-quotes the > > default. Historic reasons perhaps? > > speaking of historic reasons, here's a historic problem for you. mysql is > working mightily to upgrade their database so that it becomes fit for the > enterprise. they're making good progress. subselects are in there > already (not tested any of this, just repeating what i hear, but there's > no controversy on whether or not that functionality is really there > now). and transactions. user defined functions and triggers are going > to be in version 5. > > but what are they going to do about bonehead decisions like timestamp > fields being set to now() if they are set to null? > > e.g., > > mysql> create table test (dt timestamp); > Query OK, 0 rows affected (0.00 sec) > > mysql> insert into test values (null); > Query OK, 1 row affected (0.00 sec) > > mysql> select * from test; > +----------------+ > | dt | > +----------------+ > | 20050414150023 | > +----------------+ > 1 row in set (0.04 sec) > > i thought that only applied to the first timestamp field in > a table, but i created a table with two timestamp fields > and initialized them both to null and when i selected, > the values were the time of the insert. > > there are a few other things in mysql too that are dumb > like that, i might remember them if i thought about it. > > looks like they're just going to have to impose some > backward incompability and clean those things up > before mysql can be considered ready for serious > database work. > > credit where it's due though, they really have done a > great job adding features to mysql. > > tiger -- Philippine Linux Users' Group (PLUG) Mailing List plug@lists.q-linux.com (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
