I am having a problem with MERGE and I think that I found a post in this group that relates to the same problem:
http://groups.google.com/group/h2-database/browse_frm/thread/727560ce01c04a54/039121e1477fac6b?lnk=gst&q=merge+contains+null#039121e1477fac6b (I can't reply to the post directly but do not know why. That's why I created a new post.) I have created a test case with a couple of SQLs: create table existingCustomers(l_id integer, b_id integer, name varchar(255)) create table newCustomers(l_id integer, b_id integer, name varchar(255)) insert into existingCustomers values (1, 1001, 'Herbert') insert into existingCustomers values (2, 1001, 'Ronald') insert into existingCustomers values (3, 1001, 'Lisa') insert into existingCustomers values (4, 1002, 'Donald') insert into existingCustomers values (5, 1002, 'Ozzy') insert into newCustomers values (1, 1001, 'Herbert Hawkins') insert into newCustomers values (2, 1001, 'Ronald McDonald') insert into newCustomers values (6, 1001, 'Markus McAttkins') MERGE INTO existingCustomers(name) KEY(l_id, b_id) select name from newCustomers Now when I run the last MERGE statement I am getting the error message: Column "L_ID" contains null values; I am using the MERGE Statement incorrectly or is there a problem in the h2 db? Btw, I am using H2 Version 1.2.143 Thanks & Regards, Jens -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
