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 -- Gerald Timothy Quimpo http://bopolissimus.blogspot.com [EMAIL PROTECTED] [EMAIL PROTECTED] Public Key: "gpg --keyserver pgp.mit.edu --recv-keys 672F4C78" "SELinux can do that sort of thing quite easily. Well, as easily as SELinux does anything, I guess..." -- 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
