Inconsistencies in Profile2 column sizes after applying Sakai 2.8.0 Oracle conversion scripts
GENERAL
TESTING
GENERAL
TESTING
Description
cloned from
is depended on by
relates to
Activity
Show:
Steve Swinsburg March 6, 2011 at 6:09 PMEdited
Missed a merge to p2 1.4.x which adds the size of the external fields. Already in p2 trunk and trunk conversion, as well as 2.8 conversion.
Hudson CI Server February 25, 2011 at 9:10 PM
Integrated in sakai trunk #449 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/449/)
fix inconsistencies in column sizes between ddl and upgrade
Hudson CI Server February 25, 2011 at 3:21 AM
Integrated in profile2 trunk (build and deploy) #377 (See http://builds.sakaiproject.org:8080/job/profile2%20trunk%20(build%20and%20deploy)/377/)
fix inconsistencies in column sizes between ddl and upgrade
Steve Swinsburg February 25, 2011 at 3:17 AM
docs/conversion 2.8.x r89090
Steve Swinsburg February 25, 2011 at 3:16 AM
1.4.x, r89089
Fixed
Created February 24, 2011 at 5:26 PM
Updated July 15, 2014 at 7:12 AM
Resolved February 25, 2011 at 3:09 AM
When comparing a fresh auto-ddl'd 2.8 rc01 database against an upgraded 2.7.1 database, the following inconsistencies were found:
– PROFILE_COMPANY_PROFILES_T.COMPANY_DESCRIPTION
2.8 auto.ddl: VARCHAR2(4000 BYTE)
2.7.1 converted: VARCHAR2(255 BYTE)
– PROFILE_GALLERY_IMAGES_T.RESOURCE_MAIN
2.8 auto.ddl: VARCHAR2(4000 BYTE)
2.7.1 converted: VARCHAR2(255 BYTE)
– PROFILE_GALLERY_IMAGES_T.RESOURCE_THUMB
2.8 auto.ddl: VARCHAR2(4000 BYTE)
2.7.1 converted: VARCHAR2(255 BYTE)
– PROFILE_IMAGES_T.RESOURCE_MAIN
2.8 auto.ddl: VARCHAR2(4000 BYTE)
2.7.1 converted: VARCHAR2(255 CHAR)
– PROFILE_IMAGES_T.RESOURCE_THUMB
2.8 auto.ddl: VARCHAR2(4000 BYTE)
2.7.1 converted: VARCHAR2(255 CHAR)
(You can ignore the BYTE/CHAR discrepancy at the moment.)