Re: A BUG in IDS7.3UC2
In article <707t6l$rc5$1@news.xmission.com>, Octav Chiriac <com@netinfo-
moldova.com> writes
>
>
>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>;
I tried this orginal script under 7.30.UC3 on Solaris 2.6 and got
the same problem.
select from * from table
can see two rows with col1=1 col2=3
select from table where
where col2=3 and
col1!=1
returns 0 rows!!
Hence in the table I can see 2 rows.
0 fail to match
1 matches
???? Bug. Looking in the Techinfo Centre on Informix's Website I
cannot see a similar looking bug logged. I will log it tomorrow as
we use temp tables and it could afect us. Please logg is as well....
My work e-mail address is djw@ampsys.co.uk
Please e-mail me your case id and I'll link the two cases...
>
>-- 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 --------------------------------
>
>
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care