INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

With the following scenario:

Instance A (remote)

create table "informix".t1
  (
    c1 char(20),
    c2 char(20),
    c3 char(20)
  );

revoke all on "informix".t1 from "public" as "informix";

Instance B (local):

create view "informix".v_t1 (v1,v2,v3) as
  select x0.c1 ,x0.c2 ,x0.c3 from
testpmrs@ol_informix1170:"informix"
    .t1 x0 ;

create trigger "informix".t_v_insert instead of insert on
"informix"
    .v_t1 referencing new as n
    for each row
        (
        insert into testpmrs@ol_informix1170:"informix".t1 (c1,
    c2,c3)  values (n.v1 ,n.v2 ,'H' ));

When trying to insert using view. i.e.

    insert into v_t1 (v1,v2) VALUES ("xxxxx", "yyyyy")

You'll get

   217: Column (v1) not found in any table in the query (or SLV
is undefined).

If the column names on the view are the same as the table, it
works successfully.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC10 or older versions.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* -217 With INSTEAD OF trigger on view to a remote table if    *
* column names on view are different than remote table.        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

24.12.2018
08.10.2019
08.10.2019

12.10.xC11