Skip to:

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

DB2 "GENERATED ALWAYS AS" logic not snapshot-ed

Description

From http://forum.liquibase.org/topic/addcolumn-not-accepted

With table:

CREATE TABLE TEST ( TEST_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, TEST_PORTALUID VARCHAR(80) NOT NULL, TEST_LOGINID VARCHAR(80) NOT NULL GENERATED ALWAYS AS (UPPER(TEST_PORTALUID)), CONSTRAINT TEST_P PRIMARY KEY (TEST_ID), CONSTRAINT TEST_U1 UNIQUE (TEST_LOGINID) );

the "GENERATED ALWAYS AS (UPPER(TEST_PORTALUID))" clause is not picked up by the snapshot logic and so all that is executed is:

CREATE TABLE TEST ( TEST_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, TEST_PORTALUID VARCHAR(80) NOT NULL, TEST_LOGINID VARCHAR(80) NOT NULL, CONSTRAINT TEST_P PRIMARY KEY (TEST_ID), CONSTRAINT TEST_U1 UNIQUE (TEST_LOGINID) );

Environment

DB2

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created September 25, 2013 at 7:49 PM
Updated September 25, 2013 at 7:49 PM