#12 1 more install bug and strange Ora errs

[Alex Sokol]

The following excerpt from ut_assertion.tab script
causes unique constraint violation:
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');

Also, install is trying to add an existing column to the
tables and generate an Ora error:

ALTER TABLE ut_config ADD fileextension
VARCHAR2 (200) DEFAULT '.UTF'
*
ERROR at line 1:
ORA-01430: column being added already exists in table

SP2-0734: unknown command beginning "studious:0..." -
rest of line ignored.
SP2-0042: unknown command " /" - rest of line ignored.

--- and

ALTER table ut_argument ADD assertion_id INTEGER
*
ERROR at line 1:
ORA-01430: column being added already exists in table

I couldn't find anything wrong with the scripts, except
the first problem.

Installation was performed on Sun Ultra 2 running Oracle
8.1.6 release 3.

I also would like to add that right before the described
above installation i was able to execute the full install in
a brand new database on Windows 2000 running 8.1.7

Alex

[Paul Walker]

I have installed the current version (2.2) numerous times and not encountered this. From looking at the current code, it looks like these issues have been addressed in the interim.