Export Tables->Sql Inserts bug

[adriansi]

Hello.
There is a bug in Export Tables->Sql inserts.
It seems that when commit option it used and no. or rows after a commit is issued >0 one row is missing before the first commit; this row is added just before the last commit.
E.g. :
-- Drop table
DROP TABLE zzz_exp;
-- Create table
create table zzz_exp
(
C1 VARCHAR2(1),
N1 NUMBER
);
-- Insert 10 rows
insert into zzz_exp (C1, N1) values ('O', 1);
insert into zzz_exp (C1, N1) values ('C', 2);
insert into zzz_exp (C1, N1) values ('A', 3);
insert into zzz_exp (C1, N1) values ('D', 4);
insert into zzz_exp (C1, N1) values ('T', 5);
insert into zzz_exp (C1, N1) values ('J', 6);
insert into zzz_exp (C1, N1) values ('T', 7);
insert into zzz_exp (C1, N1) values ('M', 8);
insert into zzz_exp (C1, N1) values ('G', 9);
insert into zzz_exp (C1, N1) values ('T', 10);
commit;

--Export table zzz_exp
/*prompt PL/SQL Developer import file
set feedback off
set define off
prompt Deleting ZZZ_EXP...
delete from ZZZ_EXP;
commit;
prompt Loading ZZZ_EXP...
insert into ZZZ_EXP (C1, N1)
values ('O', 1);
insert into ZZZ_EXP (C1, N1)
values ('C', 2);
insert into ZZZ_EXP (C1, N1)
values ('A', 3);
insert into ZZZ_EXP (C1, N1)
values ('D', 4);
insert into ZZZ_EXP (C1, N1)
values ('T', 5);
insert into ZZZ_EXP (C1, N1)
values ('J', 6);
insert into ZZZ_EXP (C1, N1)
values ('T', 7);
insert into ZZZ_EXP (C1, N1)
values ('M', 8);
insert into ZZZ_EXP (C1, N1)
values ('G', 9);
commit;
prompt 10 records committed...
insert into ZZZ_EXP (C1, N1)
values ('T', 10);
commit;
prompt 10 records loaded
set feedback on
set define on
prompt Done*/.

--insert new 10 rows
--

--new export
/*prompt PL/SQL Developer import file
set feedback off
set define off
prompt Deleting ZZZ_EXP...
delete from ZZZ_EXP;
commit;
prompt Loading ZZZ_EXP...
insert into ZZZ_EXP (C1, N1)
values ('O', 1);
insert into ZZZ_EXP (C1, N1)
values ('C', 2);
insert into ZZZ_EXP (C1, N1)
values ('A', 3);
insert into ZZZ_EXP (C1, N1)
values ('D', 4);
insert into ZZZ_EXP (C1, N1)
values ('T', 5);
insert into ZZZ_EXP (C1, N1)
values ('J', 6);
insert into ZZZ_EXP (C1, N1)
values ('T', 7);
insert into ZZZ_EXP (C1, N1)
values ('M', 8);
insert into ZZZ_EXP (C1, N1)
values ('G', 9);
commit;
prompt 10 records committed...
insert into ZZZ_EXP (C1, N1)
values ('T', 10);
insert into ZZZ_EXP (C1, N1)
values ('A', 1);
insert into ZZZ_EXP (C1, N1)
values ('D', 2);
insert into ZZZ_EXP (C1, N1)
values ('D', 3);
insert into ZZZ_EXP (C1, N1)
values ('C', 4);
insert into ZZZ_EXP (C1, N1)
values ('T', 5);
insert into ZZZ_EXP (C1, N1)
values ('G', 6);
insert into ZZZ_EXP (C1, N1)
values ('V', 7);
insert into ZZZ_EXP (C1, N1)
values ('M', 8);
insert into ZZZ_EXP (C1, N1)
values ('H', 9);
commit;
prompt 20 records committed...
insert into ZZZ_EXP (C1, N1)
values ('N', 10);
commit;
prompt 20 records loaded
set feedback on
set define on
prompt Done.*/

 

[Marco Kalter]

We'll fix it.

 

[adriansi]

Hi Marco,

Is almost fixed in release 6.0.6 pre-release :
In this version prompt is inserted well (after N rows) but with wrong number : N+1.

Output:

prompt PL/SQL Developer import file
prompt Created on Tuesday, October 18, 2005 by adrian
set feedback off
set define off
prompt Deleting ZZZ_EXP...
delete from ZZZ_EXP;
commit;
prompt Loading ZZZ_EXP...
insert into ZZZ_EXP (C1, N1)
values ('O', 1);
insert into ZZZ_EXP (C1, N1)
values ('C', 2);
insert into ZZZ_EXP (C1, N1)
values ('A', 3);
insert into ZZZ_EXP (C1, N1)
values ('D', 4);
insert into ZZZ_EXP (C1, N1)
values ('T', 5);
insert into ZZZ_EXP (C1, N1)
values ('J', 6);
insert into ZZZ_EXP (C1, N1)
values ('T', 7);
insert into ZZZ_EXP (C1, N1)
values ('M', 8);
insert into ZZZ_EXP (C1, N1)
values ('G', 9);
insert into ZZZ_EXP (C1, N1)
values ('T', 10);
commit;
prompt 11 records committed...
insert into ZZZ_EXP (C1, N1)
values ('O', 1);
insert into ZZZ_EXP (C1, N1)
values ('C', 2);
insert into ZZZ_EXP (C1, N1)
values ('A', 3);
insert into ZZZ_EXP (C1, N1)
values ('D', 4);
insert into ZZZ_EXP (C1, N1)
values ('T', 5);
insert into ZZZ_EXP (C1, N1)
values ('J', 6);
insert into ZZZ_EXP (C1, N1)
values ('T', 7);
insert into ZZZ_EXP (C1, N1)
values ('M', 8);
insert into ZZZ_EXP (C1, N1)
values ('G', 9);
insert into ZZZ_EXP (C1, N1)
values ('T', 10);
commit;
prompt 20 records loaded
set feedback on
set define on
prompt Done.

 

[adriansi]

Hi Marco,

I verified this problem in the new 7.0.0.1026 Beta 1 and i found that the problem still exists.

Is not very nice that a problem reported on 28-03-2005 is not fixed after more then 8 months.

I relly hope that this problem will be fixed, because is a very very simple bug.
Please ask the Test Team to pay more atention when they verify/close bugs.

And another thing : When we will be able to see on your website the list of enhancement requests ?
Are you thinking also to create a list of current bugs ?

Thank you.

 

[Marco Kalter]

The version 7 beta does not yet incorporate all planned fixes. The beta focusses on new features.

This will be fixed in 7.0.0.

 

[adriansi]

Fixed in 7.0 beta 3