Hi
Thanks for the explanation. Patch committed.
Nice working with you!
Regards, Noel.
On 2013-10-22 11:05, Cemo wrote:
CREATE TABLE `BAD_WORD` (
`BAD_WORD_ID` int(11) NOT NULL AUTO_INCREMENT,
`WORD` varchar(128) NOT NULL,
PRIMARY KEY (`BAD_WORD_ID`)
);
this statement is totally legal:
REPLACE INTO `bad_word` ( `WORD`) VALUES('bad_boy');
This statement does not raise an exception. It does not need an PK field
too. And I thought that It would be better to optimize process by
skipping update. Because there is any field to help us for an update
statement. If I throw an exception in this case, I can not insert any
statement without a PK field. Hope that It would help you to make clearer.
Please let me know for further details.
Thanks
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
