Another issue, that came up with the update from IBO4.8 to IBO5.9 is a another problem with incremental search.

I have a table with several integer fields and a computed field from that integer fields and the computed field is a varchar field. Then I want to be able to display the computed field in a grid and to search incrementally by that field, but have the data sorted by the values of the integer fields. That worked well in IBO 4.8, but doesn't work any more in 5.9.

Here is an example.

The table is created that way:

create table test

(id integer not null primary key,

 field1 integer,

 field2 integer,

 field3 integer,

 field4 computed by (cast (field1 as varchar (10)) || '/' || cast (field2 as varchar (10)) || '-' || cast (field3 as varchar (10))))^

insert into test (id, field1, field2, field3)

values (1, 1, 1, 1)^

insert into test (id, field1, field2, field3)

values (2, 2, 2, 2)^

insert into test (id, field1, field2, field3)

values (3, 3, 3, 3)^

insert into test (id, field1, field2, field3)

values (4, 4, 4, 4)^

insert into test (id, field1, field2, field3)

values (5, 5, 5, 5)^

insert into test (id, field1, field2, field3)

values (6, 6, 6, 6)^

insert into test (id, field1, field2, field3)

values (7, 7, 7, 7)^

insert into test (id, field1, field2, field3)

values (8, 8, 8, 8)^

insert into test (id, field1, field2, field3)

values (9, 9, 9, 9)^

insert into test (id, field1, field2, field3)

values (10, 10, 10, 10)^

commit^