dynamobi/dynamobi — Issue #147: [LDB-175] Got errors other than validator's trying DML on read-only objects
Author: dynamobi-build
Created: 2011-12-30 02:16:56+00:00
State: open
Labels: LDB

[reporter="kvu", created="Tue, 22 Apr 2008 14:56:29 -0500 (GMT-05:00)"]
Delete/Insert on views/foreign tables:

create schema dt;

set schema 'dt';

create table t(i1 int);

create view v as select * from t;

delete from v;

Error: Optimizer failed to find a valid physical implementation for relational expression rel#6490:TableModificationRel.NONE(child=HepRelVertex#6500,table=[LOCALDB, DT, V],operation=DELETE,updateColumnList=[],flattened=true); see trace for partially optimized plan. Details: reason is [Node's traits (NONE) do not match required traits (ITERATOR)]; while preparing statement [delete from v]. (state=,code=0)

Merge into views/foreign tables:

merge into v as tgt

using t src

on tgt.i1 = src.i1

when matched then update set i1 = src.i1;

Error: java.lang.AssertionError: null (state=,code=0)