Another bug of IPLOAD !
IPLoad in the Bugland, Part II
I don't know if I am cursed or not, but this is the second time I have a
serious
problem with the High Performance Loader provided with Online 7.20.
Today's menu: ipload and serial type.
Try this:
create table zetable( ser serial );
insert into zetable values(0);
insert into zetable values(0);
insert into zetable values(666);
insert into zetable values(0);
select * from zetableWhat you get is:
1
2
666
667 (because the current serial value was 667 after inserting 666).
You'll find out the current serial value is now 668 by using oncheck -pt
on
zetable (great ! that's what it should be !).
Now, unload zetable to a file; for example, zetable.unl (great name...).
Drop and recreate your table.
Insert into your table using ipload (okay, zetable is small, but just doit).
Finally, check the current serial value with oncheck -pt.
You'll get 1 !!! Aaaaarg ! This is pure s... !
Valery Fouques valou@hotmail.com
SYSADM GOSPORT-FRANCE /\\oO/\\
_ __/|
\\`O.o' "A path without obstacles
=(_ _)= probably leads nowhere."
U