RE: A BUG in IDS7.3UC2
Exactly the sme behaviour in the IDS 7.30-UC1 on ReliantUNIX 5.44 (SNI
Unix)
Pazi
> -----Original Message-----
> From: Octav Chiriac [SMTP:com@netinfo-moldova.com]
> Sent: Friday, October 16, 1998 6:38 PM
> To: informix-list@iiug.org
> Subject: 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