babelfish-for-postgresql / babelfish_extensions / 13923703363

77%

push

github

Reseed identity for new table created using select into and only inherit nullability for simple queries (#3571)

This commit fixes following for SELECT...INTO... command

1. Reseed identity sequence for new table created using SELECT INTO statement. For reseeding we will run following
internal sub command post SELECT INTO processing -- 
```
SELECT setval(seq, SELECT MAX(identity_column) FROM new_table);
```
Note that If identity is decreasing then we will use MIN instead of MAX.

2. Only carry over nullability when the query has single table reference in FROM clause. Table could be either
permanent or temporary. In other words -- nullability will not be carried over when JOINing of table is involved.

Task: BABEL-5661
Signed-off-by: Tanzeel Khan <tzlkhan@amazon.com>

62 of 68 new or added lines in 3 files covered. (91.18%)

47429 of 63196 relevant lines covered (75.05%)

187926.31 hits per line