Rob Verschoor

### Description T-SQL supports **EXECUTE WITH RECOMPILE** and **CREATE PROCEDURE ... WITH RECOMPILE**. For **EXECUTE WITH RECOMPILE**, an ad-hoc plan is generated for that particular execution. For **CREATE PROCEDURE WITH...

Support JTDS driver

1

The JTDS driver for SQL Server is not currently supported with Babelfish. When connecting to the Babelfish endpoint an error is raised: Spring boot versions: 1.4.0 and 2.6.1 Java Version:...

Currently, Babelfish ignores all hints, of any type. When it comes to table hints related to locking, this can affect result correctness. If SELECT is performed WITH (UPDLOCK), which, in...

For connection pooling, some of the SQL Server drivers may call `sp_reset_connection` system procedure to reset the current connection. We need to implement the same in Babelfish. More information: https://www.google.com/search?q=sp_reset_connection

Babelfish modifies certain names of indexes (and some constraints) in order to satisfy the PG requirement that these names are unique in a schema. Error messages should report the original...

The INDEX_COL() T-SQL function returns the name of the Nth column in an index. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/functions/index-col-transact-sql.md

For the FORMAT() function, Babelfish supports the lowercase 'f' mask, but not the uppercase 'F': ``` 1> select FORMAT(getdate(), 'HH:mm:ss.ffff') 2> go format ---------------------------------------------- 14:33:49.2330 1> select FORMAT(getdate(), 'HH:mm:ss.FFFF') 2>...

The FORMAT() function does not currently supports the format masks '#,##' and '00.00'. For the examples below, Babelfish raises an error message shown for all numeric datatypes. SQL Server: ```...

SET DATEFORMAT defines the order of the month, day, and year date parts for interpreting date character strings for the current session. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/statements/set-dateformat-transact-sql.md

The COALESCE() T-SQL function throws invalid input syntax error when its arguments are of not the same data type: ``` 1> SELECT COALESCE(NULL, 1, 2, 'I am a string') 2>...