id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc
945,Oracle migration problems using Boolean field with Default Value,goodrich@…,andrew,"FATAL ERROR - The following SQL query failed: CREATE TABLE ""CAMPUSFORMS_APPROVEDPRODUCT"" ( ""ID"" NUMBER(11) NOT NULL PRIMARY KEY, ""NAME"" NVARCHAR2(400) DEFAULT '' NULL , ""MANUFACTURE R"" NVARCHAR2(100) DEFAULT '' NULL , ""RESTRICTED"" NUMBER(1) CHECK (""RESTRICTED"" IN (0,1)) DEFAULT False NOT NULL );

It looks like there is issue with the placement of the CHECK() clause. It should come before both DEFAULT and NOT NULL.

The value of False is not valid as well (a separate issue).

I think similar tickets have been submitted but this one reflects the code from the tip as of now.

Here's the migration script the causes the error:

        # Adding model 'ApprovedProduct'
        db.create_table('campusforms_approvedproduct', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=400)),
            ('manufacturer', self.gf('django.db.models.fields.CharField')(max_length=100)),
            ('restricted', self.gf('django.db.models.fields.BooleanField')(default=False)),
        ))
        db.send_create_signal('campusforms', ['ApprovedProduct'])",defect,closed,major,,migrations,mercurial,fixed,oracle boolean default,