Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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)