Informix - Problembeschreibung
Problem IT26200 | Status: Geschlossen |
SUBSTRING OPERATOR DOES NOT WORK IN WHERE CLAUSE | |
Produkt: | |
IBM INFORMIX 4G / 5724C6680 / 750 - Informix 7.50 | |
Problembeschreibung: | |
The substring operator "[]" does not work when used in a WHERE clause. For example, you have a table defined as: create table t1( c1 char(6), c2 char(6) ); You have a 4GL program: ]$ cat sub.4gl DEFINE r_c1 char(7), r_c2 char(7) MAIN DATABASE test LET r_c1 = "Testing" LET r_c2 = "Testing" INSERT INTO t1(c1, c2) VALUES (r_c1[1,4], r_c2) END MAIN When the program above is run, the following values are inserted into the table: c1 c2 Testing Testing | |
Problem-Zusammenfassung: | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
Product is working as designed. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 06.09.2018 17.05.2019 17.05.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |