Re: A BUG in IDS7.3UC2

Pazicky Ludovit wrote: >After playing a while I experienced following: > >1. When I ran the script as it was I became the same results as Octav >2. When I dropped the index and re-created it, the query returned the >correct result set >3. Then I tried to drop the index, re-create it, updated the row to the >original state, updated as in script - correct result set >4. Last experiment was drop the index, update the row to the original >state, re-create index, update as in script - wrong result set. > >It looks as the index does not work properly after update. > RIGHT. You could try to create the table with CREATE statement (instead of SELECT .. INTO TEMP). In this case on my system the update behaviour is correct. 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