Informix - Problembeschreibung
Problem IT27521 | Status: Geschlossen |
-217 WITH INSTEAD OF TRIGGER ON VIEW TO A REMOTE TABLE IF THE COLUMN NAMES ON THE VIEW ARE DIFFERENT THAN THE REMOTE TABLE | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * 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: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.12.2018 08.10.2019 08.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC11 | |
Problem behoben lt. FixList in der Version |