babelfish-for-postgresql / babelfish_extensions / 13538572623

76%

BABEL_5_X_DEV: 77%

Build Type

push

github

Committed by web-flow

Commit Message

SELECT INTO does not keep nullability or identity (#3499) (#3534)

* SELECT INTO does not keep nullability or identity

Previosuly, if the source table contains an identity column or a not
nullable column, then the desitination table where these columns are
SELECTed INTO did not keep their identity or nullability property.

In this commit, if the columns in the INTO clause, have the identity or
not nullable property attributed with them, we will implicitly create an
ALTER TABLE statement that would do the following:

 1. IDENTITY: ALTER TABLE dest_rel ADD COLUMN col. Where col is an
    IDENTITY column with the same properties as the source column.
 2. NOT NULL: ALTER TABLE dest_rel ALTER COLUMN col SET NOT NULL

Task: BABEL-5485

Signed-off-by: Sharu Goel <goelshar@amazon.com>

Run Details

48 of 48 new or added lines in 1 file covered. (100.0%)

341 existing lines in 2 files now uncovered.

47146 of 62854 relevant lines covered (75.01%)

186228.8 hits per line