4.2.0 diffs for Oracle 10gR2

Below are some small diffs.

BTW my SQL is rusty but why are you converting scrips.template
to a string when its a reference to templates.id?
John
groenveld@acm.org

— etc/upgrade/4.1.1/schema.Oracle Sat Oct 5 15:05:15 2013
*** 11,17 ****
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
! ALTER TABLE Scrips ADD COLUMN Disabled int2 NOT NULL DEFAULT 0;

INSERT INTO ObjectScrips(
id, Scrip, Stage, ObjectId,
— 11,17 ----
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE
);
! ALTER TABLE Scrips ADD ( Disabled NUMBER(11,0) DEFAULT 0 NOT NULL );

INSERT INTO ObjectScrips(
id, Scrip, Stage, ObjectId,

— etc/upgrade/4.1.5/schema.Oracle Sat Oct 5 15:49:16 2013
*** 1,5 ****

Template column

ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld;
! ALTER TABLE Scrips ADD COLUMN Template VARCHAR2(200) NOT NULL;
! UPDATE TABLE Scrips SET Template = CAST(TemplateOld AS varchar2);
ALTER TABLE Scrips DROP COLUMN TemplateOld;
— 1,6 ----

Template column

ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld;
! ALTER TABLE Scrips ADD ( Template VARCHAR2(200) );
! UPDATE Scrips SET Template = CAST(TemplateOld AS varchar2(200));
! ALTER TABLE Scrips MODIFY ( Template VARCHAR2(200) NOT NULL );
ALTER TABLE Scrips DROP COLUMN TemplateOld;

— etc/upgrade/4.1.22/schema.Oracle Sat Oct 5 15:34:26 2013
*** 1 ****
! ALTER TABLE Users ADD COLUMN SMIMECertificate CLOB;
— 1 ----
! ALTER TABLE Users ADD ( SMIMECertificate CLOB );

Below are some small diffs.

Are these diffs because you encountered errors or because it’s cleaner
oracle syntax?

If they are to fix errors, please send them as unified diffs (diff -u)
along with the errors you see to the bug tracker:
http://www.bestpractical.com/rt/issues.html

BTW my SQL is rusty but why are you converting scrips.template
to a string when its a reference to templates.id?

4.0 set scrips.template to an id.
4.2 uses scrips.template as a name.

-kevin

In message 20131007150925.GE1751@jibsheet.com, Kevin Falcone writes:

Are these diffs because you encountered errors or because it’s cleaner
oracle syntax?

They error, not warn in 10G.

John
groenveld@acm.org