On 8/21/08, Arjen Lentz <[EMAIL PROTECTED]> wrote: > > > I think this behaviour is fairly messy. If no default is specified, the >> server should chuck an error on an insert that doesn't have a value for that >> column (aka sql_mode=strict_trans_all_tables I believe). Because in the >> above, there's still the built-in what I call "default default" that's >> applied when no explicit default is specified. >> >> bad RDBMS, no biscuit. The database shouldn't try to anticipate what I >> want, if I don't give it the right parameters it should warn or give me an >> error. >> > > I tend to agree, but it means we either can't have non-transactional > engines, or have to abort operations in mid flight and leave a table in a > messy state. It's one thing or the other....
The database should abort, leaving the table in a *not* messy state. If I don't specify a default value on table create, don't guess one for me, I'd rather have the error. Basically, either the developer (on insert/update) or the schema designer (on table create) can be lazy; but not both. Seriously. This isn't rocket science. It's data entry principles at this point. If I don't specify a default, don't try to be smart and put one in for me. So....Brian, does that answer your question??? >> > > > > Cheers, > Arjen. > -- > Arjen Lentz, Founder @ Open Query > Training and Expertise for MySQL in Australia and New Zealand > http://openquery.com.au/training/ (ph. +61-7-3103 0809) > > > > > > -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
