babelfish-for-postgresql / babelfish_extensions / 11124174166

74%

BABEL_5_X_DEV: 77%

push

github

Reset db context at the time TDS resets the connection (#2978)

T-SQL Behaviour suggests that if we connect to database db1 and if during the session we have changed the database context to db2 then at the time of reset connection, the server must reset the connection to db1. Earlier we were not resetting the database context to that of the database used to login, in the above example db1, this lead to clients being handed a stale connection.
To Fix this we reset the database context to that from the loginInfo which was maintained at time of login. Changes were also made to avoid sending the environment change token for the implicit "USE DB" being run at time of reset.

Issues Resolved
BABEL-5256

Signed off by: Kushaal Shroff <kushaal@amazon.com>

61 of 62 new or added lines in 4 files covered. (98.39%)

42925 of 58263 relevant lines covered (73.67%)

142127.77 hits per line