A BUG in IDS7.3UC2
Hello,
I think I have found a bug in IDS 7.30UC2. My system
is running on SCO OpenServer 5.0.4. The same test (and with the
same results) I have run on IDS 7.30UC2 Workgroup Edition on SCO OS 5.0.0.
Could you try the followng script on your systems ?
I have sent one of this type to Informix Tech Support yesterday.
Is this a known bug ?
Thank you,
Octav
---------------- SCRIPT ---- CUT HERE --------------------------------
create temp table tmp_test_tst (
col1 Int,
col2 Int,
col3 Int
) with no log;
insert into tmp_test_tst values(1,1,1);
insert into tmp_test_tst values(1,2,2);
insert into tmp_test_tst values(1,3,3);
insert into tmp_test_tst values(1,4,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
insert into tmp_test_tst values(2,14,4);
Select *
from tmp_test_tst
into temp tmp_test with no log;
-- While using this index the problem arises
-- Without this index all is Ok.
CREATE INDEX tmp_ix1345 ON
tmp_test(col1, col2);
update tmp_test
set (col2) = (3)
where col3 = 4
and col1=1
;
-- This select should return 2 records,
-- but it returns only one
select * from tmp_test
where col2 = 3
and col1=1;
-- If we are using this select
-- (without the filter on tree_type) all is Ok. We receive 2 records.
-- This select just doesn't use the index.
select * from tmp_test
where col2=3;
-- So - when using the index created above we have an error.
---------------- SCRIPT ---- CUT HERE --------------------------------
--
Octav Chiriac Phone: (373) 2 21 20 96
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 24 00 83
Moldova, Republic of mailto:com@netinfo-moldova.com