Skip to content

Loading…

DBAL-472: Oracle schema modification - incorrect SQL to change the nullable status of column #1672

Closed
doctrinebot opened this Issue · 5 comments

2 participants

@doctrinebot

Jira issue originally created by user acp:

When updating the nullable status of a column the sql generated is

ALTER TABLE MET MODIFY (METAR VARCHAR2(2000) DEFAULT NULL)

This will set the default column value to null but does not modify the nullable status of the column. The correct sql would be

ALTER TABLE MET MODIFY (METAR VARCHAR2(2000) NULL)

The field definition changed from
{quote}
metar:
type: string
length: 2000
nullable: false
column: METAR
{quote}

to
{quote}
metar:
type: string
length: 2000
nullable: true
column: METAR
{quote}

@doctrinebot

Comment created by @beberlei:

Works for me strangely.

@doctrinebot

Comment created by @deeky666:

Patch supplied in PR: #467

@doctrinebot

Comment created by @doctrinebot:

A related Github Pull-Request [GH-467] was closed:
#467

@doctrinebot

Issue was closed with resolution "Fixed"

@doctrinebot doctrinebot added the Bug label
@deeky666 deeky666 was assigned by doctrinebot
@doctrinebot doctrinebot added this to the 2.5 milestone
@doctrinebot doctrinebot closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.