dynamobi/dynamobi — Issue #195: [LDB-126] Attempting to use UPDATE should give a good error message (feature not supported).
Author: dynamobi-build
Created: 2011-12-30 02:20:49+00:00
State: closed
Labels: LDB, Optimizer

[reporter="jvs", created="Tue, 22 Aug 2006 18:29:35 -0500 (GMT-05:00)"]
Anil tried it (not knowing that we didn't support it) and got back the message below. It looks like you put in a feature check for MERGE already.

Error: java.sql.SQLException: Optimizer failed to find a valid physical implementation for relational expression rel#9715:TableModificationRel.NONE(child=HepRelVertex#9722,table=[LOCALDB, LucidEra Analytics, LS_USER],operation=UPDATE,updateColumnList=[SOURCE_CREATED_BY_AGENT_KEY],flattened=true); see trace for partially optimized plan, SQL State: null, Error Code: