The standard doesn't say much about implementation details, and that seems like an implementation detail to me.
I think rolling back the statement is the right thing to do as well. I forget, did we keep INSERT IGNORE? If so, I think the big question is what happens with that? (I'd say it should just not insert that one row that's null, but not rollback).... -Sheeri On 12/16/08, Eric Bergen <[email protected]> wrote: > > With innodb as the default storage engine drizzle can handle multi row > and single row inserts the same way. If it errors on a single row and > rolls back the statement it should also error on mutli row and roll > back the statement. I'm not sure what the standard says about null > handling though. I prefer if I say not null and try to insert a null > value that it error and rollback the statement. > > > On Tue, Dec 16, 2008 at 10:53 AM, Jim Winstead <[email protected]> > wrote: > > On Tue, Dec 16, 2008 at 10:45 AM, Jay Pipes <[email protected]> wrote: > >> Ostensibly, the above behaviour was designed so that LOAD DATA and other > >> multi-row or batch operations would continue if a NULL value was > inserted > >> into a NOT NULL column. > > > > the behavior also probably pre-dates the implementation of the DEFAULT > keyword. > > > > of course, that just leads to the question of what DEFAULT means when > > the column doesn't have a specified DEFAULT. > > > > jim > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~drizzle-discuss > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~drizzle-discuss > > More help : https://help.launchpad.net/ListHelp > > > > > > > -- > Eric Bergen > [email protected] > http://www.provenscaling.com > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- - 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
