A list of Result and update counts that can be returned by ResultQuery#fetchMany() calls and other calls that produce multiple cursors and update counts.

For backwards-compatibility (e.g. with ResultQuery#fetchMany()), this type extends List containing only the Result, not the rows, update counts, exceptions of interleaved updates. In order to get them all, call resultsOrRows() upon the results.

Exceptions

Some databases support raising several errors or exceptions per statement batch (e.g. SQLDialect#SQLSERVER):

INSERT INTO t VALUES (1),(2),(3);
RAISERROR('message 1', 16, 2, 3);
RAISERROR('message 2', 16, 2, 3);
SELECT * FROM t;
RAISERROR('message 3', 16, 2, 3);

The above batch will produce:

• An update count (3)
• 2 exceptions
• A result set
• 1 exception

By default (or when explicitly specifying ThrowExceptions#THROW_ALL in Settings#getThrowExceptions()), this particular batch will produce a single exception corresponding to "message 1", with additional exceptions for "message 2" and "message 3" attached to SQLException#getNextException(), recursively.

When specifying ThrowExceptions#THROW_FIRST, only "message 1" is propagated. When specifying ThrowExceptions#THROW_NONE, then all exceptions are collected as results and are made available through resultsOrRows() in ResultOrRows#exception().

result.resultsOrRows()
      .stream()
      .filter(r -> r.result() != null)
      .map(r -> r.result())
      .collect(Collectors.toList())
      .equals(result);