Inconsistency in Polls column NULL settings and default values after applying Sakai 2.8.0 MySQL 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:

Neal Caidin September 19, 2013 at 8:43 AM

This ticket looks like it has been incorporated and fixed by

Neal Caidin August 14, 2012 at 11:18 AM

Refer to Horowitz comment in and it is a one line fix.

Matthew Jones August 3, 2012 at 1:57 PM

Zhen, Seth suggests that no fix it needed for mysql.

It looks like a conversion is still needed for Oracle though.
http://collab.sakaiproject.org/pipermail/sakai-dev/2012-January/015228.html

Zhen Qian June 27, 2012 at 8:44 AM

has addressed the Oracle conversion script problem, but left the mysql conversion script unchanged. Should do the same for the latter.

Fixed

Details

Priority

Affects versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Environment

MySql
Created June 27, 2012 at 8:43 AM
Updated June 21, 2014 at 8:22 AM
Resolved September 19, 2013 at 9:50 AM