Hi guys, I'm getting *Error: java.lang.ArrayIndexOutOfBoundsException (state=08000, code=101)*, while doing a query like the following:
UPSERT INTO A (PK, COL2) SELECT A.PK, A.COL1 * B.COL1 FROM A LEFT JOIN B ON A.COL3=B.COL2; Some additional info: - Table A has around 140k records, while table B only has around 100. - In reality, Table A has around 140 columns, but they're not part of the UPSERT in any way. - A.COL2 is DECIMAL. - A.COL1 is FLOAT - B.COL1 is DECIMAL. *- Running only the SELECT statement, successfully prints the results on the screen.* To be honest, I have no idea what to look for or where. Any ideas? Thanks, -Jaime
