Inconsistent behaviour between ADO.NET with Microsoft SQL Server and with Vertica
I've identified two distinctions between SQL Server and Vertica ADO.NET implementations:
- Vertica returns a result for non-query statements as part of a batch; e.g. CREATE TABLE; INSERT ...; SELECT ...; -> 3 results in Vertica, 1 in SQL Server
- ColumnOrdinal in the schema table returned by VerticaDataReader.GetSchema() is one-based, versus zero-based in SQL Server (note that both implementations are compliant with the ADO.NET specification)
0