MySQL compatibility: support REPLACE

[GoogleCodeExporter]

Hello 
We are using h2database for a while, and we like to migrate a Application
from mySql to h2. But the Application using a lot of REPLACE Statement.
We know this is not SQL Standard, but it is a nice feature.

Thank for your great work.

best regards
Thomas Feldmann

Original issue reported on code.google.com by thomas.f...@swissbyte.com on 31 Mar 2009 at 12:47

[GoogleCodeExporter]

Original comment by thomas.t...@gmail.com on 31 Mar 2009 at 3:30

• Added labels: Type-Enhancement

[GoogleCodeExporter]

Did you have a look at the MERGE statement?

Original comment by thomas.t...@gmail.com on 3 Apr 2009 at 12:34

• Changed title: MySQL compatibility: support REPLACE

[GoogleCodeExporter]

Feature requests are tracked in the Roadmap at
http://www.h2database.com/html/roadmap.html
I will move this request there and close it here.
There will be a link to this issue.

Original comment by thomas.t...@gmail.com on 3 Apr 2009 at 12:34

• Changed state: InRoadmap

[GoogleCodeExporter]

I have started to add basic support for REPLACE statement. As Thomas suggested, 
I checked Merge statement which is quite similar to REPLACE. I would be glad 
that if someone check and review my patch. Please note that this is a 
preliminary support for Mysql Replace and I will continue to add other 
possibilities such as using unique index and other replace statement syntax as 
well. 

Original comment by cemalettin.koc@gmail.com on 16 Oct 2013 at 1:45

Attachments:

• replacePatch.patch

[GoogleCodeExporter]

"I wrote the code, it's mine, and I'm contributing it to H2 for distribution 
multiple-licensed under the H2 License, version 1.0, and under the Eclipse 
Public License, version 1.0 (http://h2database.com/html/license.html)."

Original comment by cemalettin.koc@gmail.com on 22 Oct 2013 at 8:07

[GoogleCodeExporter]

Patch committed in revision 5254

Original comment by noelgrandin on 22 Oct 2013 at 9:17

• Changed state: Fixed