Hello Did someone encountered this type of message since 2.0?
I get this message on a request that has always worked with version 1.4 Here is the request UPDATE `DATA`.`CDQITT_000304` AS T SET (`Engzr_POASTMorder`, `Engzr_PONature`)=(SELECT `Engzr_POASTMorder`, `Engzr_PONature` FROM `DATA`.`CDQFTT_000098` AS TT, `TMP`.`CDCPL_Temp` AS Tmp WHERE Tmp.RecNo = T.T_RecNo02_IT AND TT.None_CDLang = T.None_CDLang AND TT.Engzr_POASTM=Tmp.Engzr_POASTM) if I understand the error that would mean that the SELECT result is NULL... but that's not the case, I get 20 lines with the following request : SELECT T.T_RecNo02_IT, TT.None_CDLang, TT.`Engzr_POASTMorder`, `TT`.`Engzr_PONature` FROM `DATA`.`CDQITT_000304` AS T, `DATA`.`CDQFTT_000098` AS TT, `TMP`.`CDCPL_Temp` AS Tmp WHERE Tmp.RecNo = T.T_RecNo02_IT AND TT.None_CDLang = T.None_CDLang AND TT.Engzr_POASTM=Tmp.Engzr_POASTM; So why do I get this error? this update request should update 20 lines / 28 on the destination tables, and only 2 columns / 4 (there is 6 columns including 2 for the primary key) and there is no null value from the select (but all rows/cols except keys are null before update on destination table) regards -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/d75d00b7-3a54-4e0f-b28c-8d629d9c49efn%40googlegroups.com.
