Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Inconsistencies in Profile2 column types after applying Sakai 2.8.0 Oracle conversion scripts

Description

When comparing a fresh auto-ddl'd 2.8 rc01 database against an upgraded 2.7.1 database, the following column-type inconsistencies were found:

– PROFILE_KUDOS_T.DATE_ADDED
2.8 auto.ddl: TIMESTAMP(6)
2.7.1 converted: DATE

– PROFILE_MESSAGES_T.DATE_POSTED
2.8 auto.ddl: TIMESTAMP(6)
2.7.1 converted: DATE

is depended on by

Activity

Show:

Hudson CI Server March 6, 2011 at 9:10 PM

Integrated in sakai trunk #457 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/457/)
adjust column type

Hudson CI Server March 6, 2011 at 6:07 PM

Integrated in profile2 trunk (build and deploy) #387 (See http://builds.sakaiproject.org:8080/job/profile2%20trunk%20(build%20and%20deploy)/387/)
adjust formats to tiemstamp

Steve Swinsburg March 6, 2011 at 6:03 PM

trunk reference/docs/conversion, r89331
2.8.x reference/docs/conversion, r89332

Steve Swinsburg March 6, 2011 at 5:59 PM

1.4.x r89330

Steve Swinsburg March 6, 2011 at 5:52 PM

r89329

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Environment

Oracle 9i
Created February 24, 2011 at 5:29 PM
Updated July 15, 2014 at 7:11 AM
Resolved March 6, 2011 at 5:52 PM