Inconsistency in Polls column NULL settings and default values after applying Sakai 2.8.0 Oracle conversion

Description

When comparing a fresh auto-ddl'd 2.8 rc01 database against an upgraded 2.7.1 database, the following inconsistency was found:

– POLL_POLL.POLL_IS_PUBLIC
2.8 auto.ddl: nullable, default NULL
2.7.1 converted: not nullable, default "0"

The relevant line in the conversion script is:

alter table POLL_POLL add POLL_IS_PUBLIC Number(1,0) default 0 not null;

Activity

Show:

Zhen Qian June 27, 2012 at 8:46 AM

reviewed the conversion script. Close the ticket.

Opened a new one - POLL-146, to address the MySQL side of problem.

Zhen Qian June 27, 2012 at 8:41 AM

was introduced by changes

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

Integrated in sakai trunk #462 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/462/)
resolve column-type and default-value inconsistency in conversion script

Seth Theriault March 11, 2011 at 11:12 AM

In 2.8.x, r89746

Seth Theriault March 11, 2011 at 9:59 AM

Change now in trunk, r89744.

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Environment

Oracle 9i
Created February 24, 2011 at 5:44 PM
Updated June 21, 2014 at 8:22 AM
Resolved March 14, 2011 at 7:29 PM