The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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)