Re: A BUG in IDS7.3UC2
cxvale@promarkone.com wrote:
>In article <707t6l$rc5$1@news.xmission.com>,
> Octav Chiriac <com@netinfo-moldova.com> wrote:
>> Hello,
>> ...
>>
>> -- 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
>> ;
>>
>
>
>We found that composite indexes on temporary tables do not work in 7.30UC1.
>Our platform is solaris 2.5.1.
>
I have changed the index type to be just on col2. The same results.
This error doesn't occur in case I create the tmp_test table using
"CREATE TABLE". It only appear when I'm "Selecting .. into temp tmp_test".
Kind Regards,
Octav
--
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