Bug with in-place editor in SQL Window

Kengoo.ru

Member
Hi, developers!

I've noticed I can't use in-place data editor with index-organized tables.

Test case:

Code:
create table test_table (
  a number(10) not null,
  b number(10) not null,
  constraint tt_PK primary key (a,b)
) organization index; -- non-IOTs work fine!
insert into test_table values (1,2);

-- editing this result works fine:
select rowid,t.* from test_table t where a=1
 for update;

-- editing this result fails:
select t.* from test_table t --where a=1
 for update

When updating I get a Warning messagebox saying "Record 1 has been deleted".
When deleting it just silently does nothing, thus writing in the status bar that "1 record deleted".

Support info:
PL/SQL Developer
Version 8.0.4.1514
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 2
 
Yes, possibly it's the same!
As I could see in Oracle traces, PL/SQL Developer adressed quite strange ROWID which had nothing similar with the actual one...
And the traces of tests with usual table and an IOT do differ: with usual table Developer does one more query:

select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

I not a scrap understand what is that :)
 
Back
Top