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
