Alex Kasko
Alex Kasko
Added support for returning sql_variant time and datetime2 values as nvarchar. Also moved all "date-to-string" conversion code into `tdstimestamp.c` and used `pg_strftime` where applicable instead of manual date formatting. Remaining...
Added support for fetchtype `INFO` in [sp_cursorfetch](https://github.com/MicrosoftDocs/sql-docs/blob/58ab43939746c2f3879e9c3892f0a60b8abeb332/docs/relational-databases/system-stored-procedures/sp-cursorfetch-transact-sql.md) call, it fixes `TestCursorFetchNext` test for all cases except `cursor.last()` that in jTDS relies on the number of rows in cursor (that is...
Added (re-enabled existing) proof of concept support for [sp_cursorprepare](https://github.com/MicrosoftDocs/sql-docs/blob/58ab43939746c2f3879e9c3892f0a60b8abeb332/docs/relational-databases/system-stored-procedures/sp-cursorprepare-transact-sql.md) that allows to pass the following part of `TestCursorPrepExecFetchNext` on jTDS: ``` cursor#!#open#!#prepst#!#SELECT * FROM test_cursor_prep_exec_fetch_next WHERE a > @a #!#INT|-|a|-|-2#!#TYPE_SCROLL_INSENSITIVE#!#CONCUR_READ_ONLY#!#CLOSE_CURSORS_AT_COMMIT...
Added support for [sp_cursorprepare](https://github.com/MicrosoftDocs/sql-docs/blob/58ab43939746c2f3879e9c3892f0a60b8abeb332/docs/relational-databases/system-stored-procedures/sp-cursorprepare-transact-sql.md), this fixes `TestCursorPrepExecFetchNext` with the exception of `cursor.last()` that is excluded the same way as with `TestCursorFetchNext`. Remaining failures (fractional parts of records inserted with jTDS...
Fixed the remaining tests: For `TestDecimal` filed #2678 and added a workaround described there (don't know if this workaround should go in - up to reviewers). For `TestDatetime2`, added rounding...
Just for the record (if someone will need this for release notes in future), `useCursors` jTDS option ([all options list](https://jtds.sourceforge.net/faq.html)) is not supported on Babelfish. This option is `false` by...
@kuntalghosh , @Deepesh125 , thanks for the reviews! I've filed #2860 with the PRELOGIN change and copied review comments there. Going to follow up with JDBC test framework changes.
Submitted test harness changes in #2861.
Just FYI, I will be able to respond to review comments and follow up with cursor and datatype changes in about 2 weeks.
@sftim #2860 needs to be pushed (AFAIU it passed the review) to proceed with #2861 and the following parts of this PR.