test failures with SQL Server + Posit Pro Drivers

[simonpcouch]

Related to #972.

I see a number of SQL server test failures with CI "DBs + Posit Pro Drivers (Linux) / database":

✖ | 5   152 3511 | driver-sql-server [25.3s]
────────────────────────────────────────────────────────────────────────────────
Failure ('test-driver-sql-server.R:406:3'): Mixed success multiple result-sets (#924)
Expected `nrow(res)` to equal 3.
Differences:
  `actual`: 1.0
`expected`: 3.0


Failure ('test-driver-sql-server.R:412:3'): Mixed success multiple result-sets (#924)
Expected `nrow(res)` to equal 3.
Differences:
  `actual`: 1.0
`expected`: 3.0


Failure ('test-driver-sql-server.R:418:3'): Mixed success multiple result-sets (#924)
Expected `nrow(res)` to equal 3.
Differences:
  `actual`: 1.0
`expected`: 3.0


Failure ('test-driver-sql-server.R:424:3'): Mixed success multiple result-sets (#924)
Expected `nrow(res)` to equal 3.
Differences:
  `actual`: 0.0
`expected`: 3.0


Error ('test-driver-sql-server.R:456:3'): Table-valued parameters
<nanodbc::programming_error/C++Error/error/condition>
Error: Error: invalid tvp param type
Backtrace:
     ▆
  1. ├─DBI::dbGetQuery(...) at test-driver-sql-server.R:456:3
  2. └─odbc::dbGetQuery(...)
  3.   └─odbc (local) .local(conn, statement, ...)
  4.     ├─DBI::dbSendQuery(...) at odbc/R/dbi-connection.R:239:5
  5.     └─odbc::dbSendQuery(...)
  6.       └─odbc (local) .local(conn, statement, ...)
  7.         └─odbc:::OdbcResult(...) at odbc/R/dbi-connection.R:89:5
  8.           ├─DBI::dbBind(res, params = params) at odbc/R/dbi-result.R:29:5
  9.           └─odbc::dbBind(res, params = params)
 10.             └─odbc (local) .local(res, params, ...)
 11.               └─odbc:::result_bind(res@ptr, params, batch_rows) at odbc/R/dbi-result.R:164:5

[simonpcouch]

The relevant change + test was introduced in June, preceding the most recent CRAN release in September. (Note that these tests are not ran on CRAN.)

[simonpcouch]

Oliver confirms this can wait for a later release.