Hi! On Wed, Dec 17, 2008 at 3:09 AM, Arjen Lentz <[email protected]> wrote: >> I'm still not convinced this is relevant to this matter ;-) > > > I'm pretty sure it is. All the "do the best you can and keep going" logic > is not just something Monty cooked up out of thin air, it's a direct > consequence of having to deal with a non-transactional storage engine! It's > the coping mechanism.
I don't see why a coping mechanism should choose to 'keep going'. It could just as well stop instead. I know it is no use arguing MySQL should change behaviour, but my point still remains that the choice for this particular 'keep going' coping mechanism has in itself nothing to do with transactions. If it would, why is the same coping mechanism used even with transactional tables? > Drizzle is removing the core reason to need this (non-transactional > engines), thus cascading the reasoning to the point where we can also get > rid of this type of "do the best you can" logic. On invalid input you chuck > an error, simple. I wasn't aware drizzle was abandoning the MEMORY and CSV and ARCHIVE engines. But anyway - the UNIQUE constraint example does in fact do exactly that - even for non-transactional tables. Surely throwing an error in this case poses the same issues as throwing an error for NOT NULL violations? I just see two cases of invalid input (NULL data for NOT NULL column vs duplicate data for UNIQUE constraint), but different behaviours (insert a default and warn, vs throw an error and abort the statement) - regardless of the engine. The only engine specific thing is what should happen in case the statement is aborted. kind regards, Roland > > > Cheers, > Arjen. > -- > Arjen Lentz, Director @ Open Query (http://openquery.com.au) > Training and Expertise for MySQL and related tools > > OurDelta: free enhanced builds for MySQL @ http://ourdelta.org > > -- Roland Bouman http://rpbouman.blogspot.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
