[h2] Insert adding null to the database, possible bug?

I"m using H2 Version 2.3.232 The database consists of 3 tables. Table A CREATE TABLE A (A_ID INTEGER AUTO_INCREMENT, A_STR VARCHAR(50), PRIMARY KEY (A_ID)) Table B CREATE TABLE B (B_ID INTEGER AUTO_INCREMENT, B_STR VARCHAR(50), PRIMARY KEY (B_ID)) Table AB - Maps a Many-to-Many relationship b

[h2] Merge adding nulls... possible bug?

"m using H2 Version 2.3.232 The database consists of 3 tables. Table A CREATE TABLE A (A_ID INTEGER AUTO_INCREMENT, A_STR VARCHAR(50), PRIMARY KEY (A_ID)) Table B CREATE TABLE B (B_ID INTEGER AUTO_INCREMENT, B_STR VARCHAR(50), PRIMARY KEY (B_ID)) Table AB - Maps a Many-to-Many relationship be

[h2] Merge adding null values, possible bug?

I"m using H2 Version 2.3.232 The database consists of 3 tables. Table A CREATE TABLE A (A_ID INTEGER AUTO_INCREMENT, A_STR VARCHAR(50), PRIMARY KEY (A_ID)) Table B CREATE TABLE B (B_ID INTEGER AUTO_INCREMENT, B_STR VARCHAR(50), PRIMARY KEY (B_ID)) Table AB - Maps a Many-to-Many relationship b

Re: [h2] Extremely slow update performance

Thanks for the tips. I did try limiting it to fewer rows. I didn't mean to delete the OP, I meant to forward it to someone else. If someone else sees this question, the content of the first post talked about an update query that involved a single table, where the value stored in a weight colum

[h2] Extremely slow update performance

I'm using the latest version of H2. I have a table named STR with 4 columns: AUTO_ID integer (pk) STR_VALUE varchar(100) STR_COUNT double STR_WEIGHT double I have all of the columns populated except for the STR_WEIGHT column. If I run the following updated query to calculate the weight: UPDATE S

[h2] Extremely slow update performance

I'm using the latest version of H2. I have a table named STR with 4 columns: AUTO_ID integer (pk) STR_VALUE varchar(100) STR_COUNT double STR_WEIGHT double I have all of the columns populated except for the STR_WEIGHT column. If I run the following update query to calculate the weight: UPDATE ST