>> Brian and I had a short off-list discussion that touched on the >> IGNORE qualifier and I suggested that Drizzle would be better >> without it. In MySQL, IGNORE can qualify a number of different >> statements - INSERT, UPDATE, DELETE, REPLACE, CREATE, ALTER ...
The thing about IGNORE that makes it different from other ignore-bad-data things is that you have to explicitly say you want to ignore duplicates. (Except for LOAD DATA LOCAL INFILE, and maybe the protocol hacking is already eliminating the need for that?) It's really quite useful when you're cleaning up crappy data, which I have done a lot of. Or when you're restarting something that failed partway through. Ditto, done a lot of that. I don't see the harm in it, since it's not one of those on-by-default things; rather I see it as a useful extension like ON DUPLICATE KEY UPDATE, or some of the other non-relational extensions I proposed in an earlier thread. $0.02 :-) _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
