#8 Bugs in install script

[Terje Kvambe]

I haven't used utplsql yet, but I figured I should
report the errors that occured during installation...

None of them seem to be very important, but it took
we some time to figure whether they were...

Installation was done on Oracle 8.1.7 on HP-UX.

If any of my workarounds are wrong, I would
appreciate if someone could notify me... ;)

-- 1 --
When the sub-script ut_assertion.tab is run it tries
to insert two records with the same PK (15).

INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (15, 'EVALUATE',
'General evaluation of specified
expression');

/* START username:STUDIOUS Date:01/11/2002
Task_id:42690
Description: Checking whether object exists */

INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (15, 'OBJEXISTS',
'Confirm that specified Object
exists');

Workaround:
I changed the second PK to 17, and run the inserts
for all 17 records manually.

-- 2 --
SQL*Plus seems to have some problems with /* */
comments. I get these messages from ut_assertion.tab:

SP2-0734: unknown command starts with studious:0... -
rest of line ignored. [Translated by me...]
SP2-0042: unknown command " /" - rest of line ignored.

Seems to be caused by the lines:
/*Modification History:
studious:01/20/2002:Assertion for object existance
*/

Workaround: No problem, Ignored.

-- 3 --
3 times the scripts are trying to add a coloumn to a
table that already has that coloumn. Excerpt from the
attached log file:

Creating UT_CONFIG...
[...]
ALTER TABLE ut_config ADD delimiter VARCHAR2(10)
DEFAULT '##'
*
Error on line 1:
ORA-01430: column being added already exists in table
[...]
Creating UT_ASSERTION...
[...]
ALTER TABLE ut_config ADD delimiter VARCHAR2(10)
DEFAULT '##'
*
Error on line 1:
ORA-01430: column being added already exists in table
[...]
Creating UT_ARGUMENT...
[...]
ALTER table ut_argument ADD assertion_id INTEGER
*
Error on line 1:
ORA-01430: column being added already exists in table

-- 4 --
I also tried to uninstall it a couple of times, and
there seems to be a problem with the order in which
the tables are dropped:

DROP TABLE UT_PACKAGE
*
Error on line 1:
ORA-02449: unique/primary keys in table referenced by
foreign keys

DROP TABLE UT_SUITE
*
Error on line 1:
ORA-02449: unique/primary keys in table referenced by
foreign keys

Workaround: Had to delete these tables manually.

That's all, no big deal really. Now I'm looking
forward to try the real thing!

Terje =)

[Terje Kvambe]

install log

[Paul Walker]

I think these have all been addressed at some point between this ticket being raised and the current version 2.2:

-- 1 --
This has been addressed at some point - it is correct in version 2.2

-- 2 --
This has been changed from a comment-block to single-line comments at some point - it is OK in version 2.2

-- 3 --
Looks like these have been addressed

-- 4 --
I think these must have been addressed - I've installed/uninstalled version 2.2 numerous times and not encountered this.