babelfish-for-postgresql / babelfish_extensions

74%

BABEL_4_X_DEV: 75%

LAST BUILD ON BRANCH BABEL_3_X_DEV

branch: SELECT

CHANGE BRANCH

x

Sync Branches

• No branch selected
• 15-6-raydhkim
• 16-2-raydhkim
• 4_2_stable_vector
• 4x_psql_vector_syntax
• 4x_vector_typmod
• 5173-test
• acl_cheack_new
• actions_maven_verbose
• add_parallel_query_test_man_5592
• alias_without_as_empty_check
• alter-proc-poc
• alter_proc_recompile
• alter-rename-db
• antlr4-link-fix
• atat_user_vars
• atatvar_fix
• aws_ml_failures
• aws_ml_failures_4x
• babel_11506
• BABEL-1878
• babel-2177-15
• babel-2177-16
• babel-3254-3x
• babel-3254-4x
• babel-3254-fix-3x
• babel-3254-fix-4x
• babel-3401-3x
• babel-3401-4x
• BABEL_3466
• BABEL_3466_4_X
• BABEL_3571
• BABEL_3571_3_X
• BABEL_3571_4_X
• BABEL_3_5_STABLE
• babel-3-6-stable
• BABEL_3_6_STABLE
• babel_3799
• babel-3799
• BABEL-3799
• babel-3-7-init
• BABEL_3_7_STABLE
• BABEL-3883-4x
• BABEL_3_8_STABLE
• BABEL_3_X_DEV
• BABEL-4128
• BABEL-4128-3-X
• BABEL_4_1_STABLE
• babel-4200-3_stable
• babel-4200-jira
• BABEL-4212
• BABEL-4212-3X
• babel-429-3x-fix
• babel-429-3x-test-fix
• babel-429-babel3x
• babel-429-rds-proxy-support
• babel-4-2-stable
• BABEL_4_2_STABLE
• babel_4328
• babel_4328_3x
• BABEL-4332-UDT-4_X
• BABEL_4360
• BABEL_4360_4_X
• babel-4-3-init
• BABEL_4_3_STABLE
• babel-4430
• babel-4475-3x
• babel-4475-4-x
• BABEL-4489
• BABEL-4489-3-X
• BABEL-4498
• BABEL-4498-4x
• BABEL_4_4_STABLE
• babel-4511
• babel-4511-4x
• babel-4517-15
• babel-4517-16
• BABEL-4518
• BABEL-4518-3X
• babel-4538
• babel-4538-4-x
• BABEL_4553
• BABEL_4553_4X
• BABEL-4554
• BABEL_4566
• BABEL_4585
• BABEL-4590
• BABEL-4590-4x
• BABEL-4590-fix
• babel-4595
• babel_4600
• babel_4600_3x
• babel_4600_new
• BABEL_4605
• BABEL-4634
• BABEL-4634-4x
• BABEL-4641
• BABEL-4641-3-X
• babel-4662-3x
• babel-4663-fix
• BABEL-4672
• BABEL-4672-pg15
• BABEL-4672-testcasefix
• BABEL-4672-testcasefix-pg15
• BABEL-4709-4_X
• babel-4739-3x
• babel-4739-4x
• BABEL_4740
• BABEL_4740_3X
• babel-4748
• babel-4748-4x
• BABEL-4750
• BABEL_4782
• BABEL-4788
• BABEL-4788-3x
• BABEL-4793
• BABEL-4793-15
• BABEL_4797
• BABEL_4797_3X
• babel_4811_space_function_fix
• babel_4811_space_function_fix_3_x
• babel_4813
• babel-4815
• babel-4815-15
• BABEL_4817_3X
• BABEL_4817_4X
• babel-4824-rds-proxy-support
• babel-4825-rds-proxy-support
• babel-4826-rds-proxy-support
• babel-4829
• babel-4829-13
• BABEL-4836
• BABEL-4836-3-X
• BABEL-4836-revert
• BABEL-4836-test-upgrade
• BABEL-4839
• BABEL-4839-3-X
• BABEL-4839-3-X-test-fix
• BABEL_4850
• BABEL_4859
• BABEL_4859_3X
• BABEL-4864
• BABEL-4864-3x
• BABEL-4865-3x
• BABEL-4865-4x
• BABEL_4877
• BABEL_4877_4_X
• BABEL_4881
• babel-4886-3x
• babel_4891
• BABEL-4896
• BABEL-4896-3-X
• BABEL-4896-3-X-revert
• BABEL-4896-revert
• BABEL-4896-revert-3-6-stable
• BABEL-4896-revert-stable
• BABEL-4926
• babel-4926_3x
• BABEL_4928
• BABEL_4928_4x
• BABEL_4933
• BABEL-4933
• BABEL_4933_3X
• BABEL-4933-RE
• babel_4934_sel_into
• babel_4939
• BABEL_4940_test_fix
• BABEL_4940_test_fix_4_X
• BABEL_4982
• BABEL_4982_3X
• BABEL_4983
• BABEL_4983_3X
• BABEL-4986-3x
• BABEL-4986-4x
• BABEL_4_X_DEV
• BABEL-5008
• BABEL-5031
• BABEL-5031-3-X
• BABEL-5033
• babel-5059
• babel-5069-3x
• babel-5069-4x
• babel-5070
• babel-5070-15
• BABEL-5071
• BABEL_5072_3X
• BABEL-5079
• BABEL-5079-3X
• babel_5099_sys_sequences
• BABEl-5099_sys_sequences_3_x
• BABEL-5101
• BABEL-5101-3_X
• BABEL-5103-3_X
• BABEL-5103-4_X
• BABEL-5103-schedule_15_9
• BABEL_5104
• BABEL_5118
• BABEL-5119
• BABEL-5119-3X
• BABEL-5136
• babel-5139
• babel-5139-15
• BABEL-5144
• BABEL_5153
• BABEL_5153_3_X
• BABEL-5156
• BABEL-5156-4-X
• BABEL_5169
• BABEL_5169_STABLE_BRANCH
• babel-5173-3x
• BABEL-5179
• BABEL-5179-3_X
• babel_5186
• babel_5186_3x
• BABEL-5214
• BABEL-5214_3x
• BABEL-5222
• babel_5237
• babel_5237_3x
• babel_5237_schedule
• BABEL_5246
• BABEL-5246-3X
• BABEL_5249
• BABEL_5253
• babel_5272
• babel_5272_3x
• BABEL-5290-4x
• BABEL_5294
• babel-5311
• BABEL-5324
• BABEL_5334_3X
• BABEL_5335
• BABEL_5344
• BABEL_5361
• babel-5362-4x
• babel-5362-5x
• BABEL-5397
• BABEL_5_X_DEV
• babel_720
• babel_726_3_x
• babel-726-3x-fix
• babel-726-fix
• BABEL-862
• BABEL-862-3-X
• babel_dep
• babel-fix-reset-conn-test
• babel-jira-4200
• babel-jira-4430
• babel_longdb
• babel_role_val
• babel_set_reset_3_x
• babel_set_reset_role
• babel-sysconfig-test-fix
• backend_memory_profiler
• bbf-3.8
• bbf-4.4
• bbf-fixes-pg17
• bbf_role_admin
• bbl-3x
• bbl-4x
• bcp_fixes
• bcp_fixes_3x
• bcp_leak_datums
• bcp_leak_decimal
• bcp_leak_decimal_3x
• bcp_leak_indices
• bcp_leak_plp
• bcp_leak_plp_3x
• bump-vector-version
• cache_inval
• cache_inval_new
• catalogs_dbo_sys
• code-cov-demo
• comment_on_pg_trigger
• comment_on_pg_trigger_3x
• concat-3x
• concat-4x
• create_ptn_scheme_quotes
• cross-db-update
• cursor_cleanup_3X
• cursor_reset_4X
• database_metadata
• date-cherrypick-3x
• date-cherrypick-4x
• dbreader-pg-read-all-data
• dddhamel-dev-3x
• ddladmin-5-x
• declare_atatglobalvars
• dependabot/maven/test/JDBC/org.postgresql-postgresql-42.4.3
• dependabot/maven/test/JDBC/org.postgresql-postgresql-42.4.4
• dipesh-test
• disable_temp_table_ut
• dotnet_reset_3x
• dotnet_reset_con
• drop_index
• drop_index_upgrade_test
• drop_index_upgrade_tests
• dummy-PR
• empty_double_quoted_string
• enable-coredump
• enable-coredump-3x
• exec_proc_in_udf
• finalize-3_7
• finalize-4_3
• fix
• fix-4.x
• fix-babel-3592
• fix-babel3-pivot-upgrade-script
• fix-build-failure
• fix-build-failure-3x
• fix-cmakelist
• fix_code_coverage
• fix-date-flaky-3x
• fix-date-flaky-4x
• fix_dependabot_sqlclient_version
• fix-drop_user
• fix_drop_user_4_x
• fix-dump-ga
• fix-dump-ga-3.x
• fix-issue-in-JDBC-testframework
• fix-metadata
• fix-metadata_4_X
• fix-mvu-issue
• fix-mvu-issue-3_8_stable
• fix-mvu-issue-3x
• fix-mvu-issue-4_4_stable
• fix-odbc-tests
• fix-odbc-tests-rel16
• fix-parallel-query-tests
• fix-pg-upgrade
• fix-python-action
• fix-tests
• fix-tests_4_X
• fix-upgrade-script
• fix_upgrade_varchar
• geospatial_tsql_syntax_mod
• geospatial_tsql_syntax_mod_4_x
• geospatial_upgrade
• geospatial_upgrade_4x
• geospatial_views_metadata
• geo_upgrade_file
• getdate_test-3_8_Stable
• getdate_test-3_X
• getdate_test-4_4_Stable
• getdate_test-4_X
• github_action_change
• github_action_change-4_X
• grant-on-schema
• grant-on-schema-3x
• grant-schema-3x
• grant-schema-4x
• guc_fix_x3
• issue#2423
• jdbc_code_cov
• jira-5173-3_6_stable
• jira-5173-3_7_stable
• jira-5173-4_2_stable
• jira-5173-4_3_stable
• jira-babel-1528-vasavi
• jira-babel-2661-4x
• jira-babel-2736
• jira-babel-2736-3-stable
• jira-babel-2736-3x
• jira-babel-2736-4-stable
• jira-babel-2736-new
• jira-babel-2961
• jira-babel-3311
• jira-babel-3311-rel15
• jira-babel-3385
• jira-babel-3385-3x
• JIRA-BABEL-3395
• JIRA-BABEL-3395-4x
• jira-BABEL-3401
• jira-babel-3427-4049
• jira-babel-3427-4049-cherry-pick
• jira-babel-3650
• jira-babel-3650-4x
• jira-babel-3650-revert
• jira-babel-3668
• jira-babel-3668-15x
• jira-babel-3668-16
• jira-babel-3820-15x
• jira-babel-3820-16x
• jira-babel-3820-3-6
• jira-babel-3820-4-2
• jira-babel-4053
• jira-babel-4053-cherry-pick
• JIRA-BABEL-4139
• JIRA-BABEL-4139-3x
• JIRA-BABEL-4139-fix
• JIRA-BABEL-4370
• JIRA-BABEL-4379-fixes
• JIRA-BABEL-4390
• jira-babel-4550
• jira-babel-4562
• jira-babel-4586
• jira-babel-4599
• jira-babel-4625-3x
• jira-babel-4625-4x
• JIRA-BABEL-4651
• jira-babel-4701
• jira-babel-4701-3
• jira-babel-4701-3x
• jira-babel-4701-4x
• JIRA-BABEL-4707
• JIRA-BABEL-4707-4x
• JIRA-BABEL-4710
• jira-babel-4720
• jira-babel-4721
• jira-babel-4721-cherry-pick
• JIRA-BABEL-4742
• jira-babel-4751
• jira-babel-4752
• jira-babel-4752-babel-3
• jira-babel-4752-disable4x
• JIRA-BABEL-4753
• JIRA-BABEL-4753_3_x
• JIRA-BABEL-4756
• JIRA-BABEL-4756_3_x
• jira-babel-4764-4765
• jira-babel-4769
• JIRA-BABEL-4785
• jira-babel-4791
• jira-babel-4791-2
• jira-babel-4791-3x
• jira-babel-4791-column-constraints
• jira-babel-4791-upgrade-tests
• jira-babel-4792
• jira-babel-4851
• jira-babel-4851-3.x
• JIRA-BABEL-4863
• JIRA-BABEL-4863-3x
• jira-babel-4867
• jira-babel-4867-rel15
• jira-babel-4868
• jira-babel-4869
• jira-babel-4869-3x
• jira-babel-4869-modify
• jira-BABEL-4870
• JIRA-BABEL-4873
• jira-babel-4876
• jira-babel-4876-3x
• jira-babel-4888
• jira-babel-4888-cherry-pick
• jira-babel-4892
• jira-BABEL-4905
• jira-BABEL-4905-4x
• jira-babel-4912
• jira-babel-4931
• jira-babel-4931-3x
• jira-babel-4934-3-x
• jira-babel-4937
• jira-babel-4937-15x
• jira-babel-4953
• jira-babel-4953-2
• jira-babel-4956
• jira-babel-4956-cherry-pick
• jira-babel-4957
• jira-babel-4957-3x
• jira-babel-4961
• jira-babel-4961-3x
• jira-babel-4971
• jira-babel-4971-15x
• jira-babel-4976
• jira-babel-4980
• jira-BABEL-4980-4x
• JIRA-BABEL-4987
• jira-babel-4998
• jira-babel-4998-3x
• jira-babel-5006
• JIRA-BABEL-5010
• JIRA-BABEL-5010-3x
• jira-babel-5029
• jira-babel-5029-cherry-pick
• jira-babel-5039
• jira-babel-5040
• jira-babel-5068
• jira-babel-5068-3-6
• jira-babel-5068-3-x
• jira-babel-5068-4-x
• jira-babel-5074
• jira-babel-5074-15x
• jira-babel-5074-3-6
• jira-babel-5074-4-2stable
• JIRA-BABEL-5075
• JIRA-BABEL-5075-3x
• jira-babel-5078
• jira-babel-5078-36
• jira-babel-5078-42
• JIRA-BABEL-5080
• JIRA-BABEL-5080-3x
• jira-babel-5081
• jira-babel-5081-3x
• jira-babel-5086
• jira-babel-5086-36
• jira-babel-5086-3x
• jira-babel-5086-42
• jira-babel-5089
• jira-babel-5089-3.x
• jira-BABEL-5091-3x
• jira-babel-5108-3x
• jira-babel-5108-4x
• jira-BABEL-5111
• jira-BABEL-5111-3_x
• jira-babel-5120
• jira-babel-5121
• jira-babel-5129
• jira-babel-5129-3x
• jira-babel-5132
• jira-babel-5141
• jira-babel-5141-3x
• jira-babel-5155
• jira-BABEL-5173
• jira-babel-5188
• jira-babel-5203
• jira-babel-5206
• jira-babel-5206-cherry-pick
• jira-babel-5213
• jira-babel-5247
• jira-babel-5247-babel3
• jira-babel-5254
• jira-babel-5254-3x
• JIRA-BABEL-5263
• JIRA-BABEL-5263-3x
• jira-babel-5273
• jira-babel-5283
• jira-babel-5309
• jira-babel-5314
• jira-babel-5371
• jira-BABEL-5380
• jira-BABEL-5380-3-8-stable
• jira-BABEL-5380-3_x
• jira-BABEL-5380-4-4-stable
• jira-babel-5389
• jira-babel-5389-3x
• jira-babel-5389-4x
• jira-babel-5389-fix-3x
• jira-babel-5389-fix-4x
• jira-BABEL-5413
• jira-babel-5415
• jira-babel-5422
• jira-babel-5422-stable
• jira-drop-db-3x
• jira-drop-db-4x
• jira-update-row
• jtds_issue_2137
• jtds_prelogin
• jtds_test_harness
• klejao-babel-4716-3x
• klejao-babel-4716-4x
• klejao-babel-4737-3x
• klejao-babel-4737-4x
• klejao-babel-4923
• klejao-babel-4923-3x
• klejao-babel-4923-4x
• klejao-babel-cache-3x
• klejao-babel-cache-4x
• klejao-babel-pom-xml
• local_locks
• local_locks_and_cache_inval
• login_token
• login_token_4x
• lshalini-run-mvu
• merge-15.7
• merge-15.8
• merge-16.3
• merge-16.4
• merge_4x
• metadata-check
• metadata-check-3x
• modify-sp-columns-100
• modify-sp-columns-100-temporarily
• multi-db-jdbc
• nirmit-3x-5219
• nirmit-3x-5235
• nirmit-dev
• nirmit-dev-2
• object_id_test_3x
• object_id_test_4x
• oid-rework
• oid-rework-4x
• ON_ERROR_STOP_3_X
• operator_atatvar
• operator_binary_upgrade_test
• operator_binary_whitespace
• operator_whitespace
• order_by_offset_fetch_rows
• output_identity_fix
• performance-5215-3x
• performance_5251
• pg16-db_reader
• pivot-cte-fix
• pivot-cte-fix-pg15
• pivot-join-cte-pg15
• pivot-view-deparse
• pivot-view-deparse-babel3
• pivot-view-fix-pg16
• pivot-view-support
• pivot-view-support-babel3
• pr-code-cov
• psql_vector_syntax
• rcv-cherry-pick-atatvar-reviewed-4xdev
• rcv-cherry-pick-bitwise-operators-4xdev
• rcv-cherry-pick-drop-index-tests-4xdev
• rcv-cherry-pick-dropix-upgrade-tests-4xdev
• rcv-cherry-pick-orderby-offset-fetch-4xdev
• rcv-cherry-pick-table-constraint-nocomma-4xdev
• refactor
• refactor_3X
• remove-temp-change
• rename-bbf-schema-catalog
• resetdb_3
• resetDbContext
• reset_gucs
• restrict-func-overload
• revert-2866-BABEL-4933
• revert_4x
• revert-babel-3395-3_X
• revert-grant-schema
• revert-grant-schema-4x
• revert-jira-babel-4751
• revert-locks
• revert-select-into-3-7-stable
• revert-select-into-3-8-stable
• revert-select-into-3-x
• revert-select-into-4-3-stable
• revert-select-into-4-4-stable
• revert-select-into-4-x
• ritanwar-pg17-fixes
• schedule-fix
• server-database-roles-4-x
• server-db-fixed-role-5-x
• sharu-dev-3-9-dev
• sharu-dev-3x-fix-warnings
• sharu-dev-4-5-dev
• sharu-dev-babel-4768
• sharu-dev-comment-quote
• sharu-dev-db_owner
• sharu-dev-db_owner-5x
• sharu-dev-db-principals-fix
• sharu-dev-db-principals-fix-4x
• sharu-dev-is_member
• sharu-dev-is_member-4x
• sharu-dev-move-test
• sharu-dev-move-test-3x
• sharu-dev-ssl-4-1-stable
• sharu-dev-stable-3-8
• sharu-dev-stable-4-4
• sharu-dev-store-func-args-4x
• sptables_tabletype_quotes
• sptables_tabletype_quotes_3x
• sql-mod-4x
• ssms-fix
• ssms-fix-3-x
• store-func-sign
• string_empty_debug_crash
• stuff
• stuff-4x
• substring-3x
• substring-4x
• sumiji-add-ddl-export-test
• sumiji-add-metadata-consistency-test
• sumiji-block-rename-partition
• sumiji-cherry-pick
• sumiji-fix-bug
• sumiji-fix-bug-3x
• sumiji-fix-config
• sumiji-fix-config-3x
• sumiji-fix-devtool
• sumiji-fix-devtool-3x
• sumiji-fix-error
• sumiji-partitioning-support
• sumiji-support-dollar-partition-func
• sumiji-support-partitioning-4x
• sumiji-support-partition-views
• sumiji-update-readme
• support-parallel-worker-15
• support-parallel-worker-16
• table_constraint_without_comma
• tablock_hints
• tabvar_in_function
• tabvar_in_function_ansi
• tanyagp-dev-readme-fix
• tanyagp-dev-readme-fix-3x
• tdsvector
• temp-branch
• temp_table_code_cleanup
• temp-verify-dump
• test-bbf-PQ
• test-pr-upgrade
• test_sql_validation_dummy
• translate-3x
• translate-4x
• unary_plus_op_string
• update-db_collation_prep
• update-db_collation-prep-4-4-stable
• update_fix_3x
• update_fix_5x
• update-tag
• update-tag-3x
• update_ut_test_status_condition
• upgrade_15_7_16_3
• upgrade_15_7_schedule_fix
• upgrade-path-fix-3x
• upgrade-path-fix-4x
• upgrade_script_fix_after_sptables
• upgrade_scripts_3X
• upgrade_scripts_4X
• upgrade_tests_replace
• upper-lower-3x
• upper-lower-4x
• valgrind_db_rename
• valgrind-fix-3x
• valgrind-fix-4x
• valgrind_fixes
• varbinary_cast_crash
• vector_0_7_0
• vector_3_stable
• vector_3_x_dev
• vector_3x_dev
• vector_4x
• vector_support
• vector_tests_3x
• vector_tests_4x
• vole-3-8-stable
• vole-4-4-stable
• with_recompile

Build # 12036365292

Build Type

push

github

Committed by web-flow

Commit Message

Fix resetting some GUCs at the time of TDSResetConnection (#3163)

Some GUCs had an issue with being reset at time of TDSResetConnection:

1. Explain GUCs, they were not getting setting reset after TDSResetConnection. To fix this we need to reset it at time TDSResetConnection AND also at time of sys.sp_reset_connection execution(which would otherwise have given explain output).
2. ANSI_DEFAULTS and IMPLICIT_TRANSACTION related GUCs. These were getting set when driver sends some TDS flags. But after ResetConnection they were being rolled-back. To avoid this we implement TdsResetLoginFlags a wrapper to Re-ProcessLoginFlags.
3. We restrict the setting and re-setting of important GUCs like "babelfishpg_tsql.migration_mode" and "role", since once set, cannot be reset.

Issues Resolved:
BABEL-5280, BABEL-5276, BABEL-5278

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

Run Details

12 of 12 new or added lines in 5 files covered. (100.0%)

77 existing lines in 3 files now uncovered.

43085 of 58476 relevant lines covered (73.68%)

142215.77 hits per line