dynamobi/dynamobi — Issue #801: [FRG-69] attempt to join to mofClassName pseudocolumn causes internal error in MedMdrJoinRule
Author: dynamobi-build
Created: 2011-12-30 03:49:38+00:00
State: open
Labels: FRG, MDR Foreign Data Wrapper

[reporter="jvs", created="Sun, 12 Mar 2006 11:53:04 -0500 (GMT-05:00)"]
From Zelaine's email:

create schema s;

set schema 's';

create table t(a int primary key, b char(20) not null, c char(20) not null, n varchar(128) not null);

explain plan for select t.*, s."name", s."visibility", s."mofClassName"

from t inner join sys_cwm."Relational"."Schema" s

on t.c = s."mofClassName";

It asserts in MedMdrJoinRule.onMatch() with an index out of bounds exception, trying to access element 4 in an array with only 3 members.