Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ' From CurrencyCode'. Minus Query : (SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Expected' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate EXCEPT SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Expected' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate ) UNION ALL (SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Actual' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate EXCEPT SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Actual' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate )

Among 11 compared rows, some differences in SQL queries results found - expected [0] but found [10]

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.ProductModel EXCEPT SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.ProductModel ) UNION ALL (SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.ProductModel EXCEPT SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.ProductModel )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee ) UNION ALL (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.Store EXCEPT SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.Store ) UNION ALL (SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.Store EXCEPT SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.Store )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer ) UNION ALL (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.Illustration EXCEPT SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.Illustration ) UNION ALL (SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.Illustration EXCEPT SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.Illustration )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type geography cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Address EXCEPT SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Address ) UNION ALL (SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Address EXCEPT SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Address )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate EXCEPT SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate ) UNION ALL (SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate EXCEPT SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate )

Among 11 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Expected' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog EXCEPT SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Expected' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog ) UNION ALL (SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Actual' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog EXCEPT SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Actual' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Person EXCEPT SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Person ) UNION ALL (SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Person EXCEPT SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Person )

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Expected' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog EXCEPT SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Expected' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog ) UNION ALL (SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Actual' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog EXCEPT SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Actual' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ' From CurrencyCode'. Minus Query : (SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Expected' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate EXCEPT SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Expected' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate ) UNION ALL (SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Actual' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate EXCEPT SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Actual' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.Illustration EXCEPT SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.Illustration ) UNION ALL (SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.Illustration EXCEPT SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.Illustration )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer ) UNION ALL (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate EXCEPT SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate ) UNION ALL (SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate EXCEPT SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate )

Among 373 compared rows, some differences in SQL queries results found - expected [0] but found [10]

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type geography cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Address EXCEPT SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Address ) UNION ALL (SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Address EXCEPT SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Address )

Among 11 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.Store EXCEPT SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.Store ) UNION ALL (SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.Store EXCEPT SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.Store )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee ) UNION ALL (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee )

Among 11 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.ProductModel EXCEPT SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.ProductModel ) UNION ALL (SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.ProductModel EXCEPT SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.ProductModel )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Person EXCEPT SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Person ) UNION ALL (SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Person EXCEPT SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Person )

Among 385 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type geography cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Address EXCEPT SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Address ) UNION ALL (SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Address EXCEPT SELECT "AddressID" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceID" , "PostalCode" , "SpatialLocation" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Address )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer ) UNION ALL (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressType" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "Demographics" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.vIndividualCustomer )

Among 11 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate EXCEPT SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate ) UNION ALL (SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate EXCEPT SELECT "JobCandidateID" , "BusinessEntityID" , "Resume" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.JobCandidate )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ' From CurrencyCode'. Minus Query : (SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Expected' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate EXCEPT SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Expected' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate ) UNION ALL (SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Actual' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate EXCEPT SELECT "CurrencyRateID" , "CurrencyRateDate" , ",'Actual' as "Environment" From CurrencyCode" , "ToCurrencyCode" , "AverageRate" , "EndOfDayRate" , "ModifiedDate" FROM AdventureWorks2008R2.Sales.CurrencyRate )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Expected' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog EXCEPT SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Expected' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog ) UNION ALL (SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Actual' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog EXCEPT SELECT "DatabaseLogID" , "PostTime" , "DatabaseUser" , "Event" , "Schema" , "Object" , "TSQL" , "XmlEvent" ,'Actual' as "Environment" From AdventureWorks2008R2.dbo.DatabaseLog )

Among 11 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.Store EXCEPT SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Sales.Store ) UNION ALL (SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.Store EXCEPT SELECT "BusinessEntityID" , "Name" , "SalesPersonID" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Sales.Store )

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Expected' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee ) UNION ALL (SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee EXCEPT SELECT "BusinessEntityID" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "JobTitle" , "PhoneNumber" , "PhoneNumberType" , "EmailAddress" , "EmailPromotion" , "AddressLine1" , "AddressLine2" , "City" , "StateProvinceName" , "PostalCode" , "CountryRegionName" , "AdditionalContactInfo" ,'Actual' as "Environment" From AdventureWorks2008R2.HumanResources.vEmployee )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.ProductModel EXCEPT SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.ProductModel ) UNION ALL (SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.ProductModel EXCEPT SELECT "ProductModelID" , "Name" , "CatalogDescription" , "Instructions" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.ProductModel )

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.Illustration EXCEPT SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Production.Illustration ) UNION ALL (SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.Illustration EXCEPT SELECT "IllustrationID" , "Diagram" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Production.Illustration )

java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The data type xml cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable. Minus Query : (SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Person EXCEPT SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Expected' as "Environment" From AdventureWorks2008R2.Person.Person ) UNION ALL (SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Person EXCEPT SELECT "BusinessEntityID" , "PersonType" , "NameStyle" , "Title" , "FirstName" , "MiddleName" , "LastName" , "Suffix" , "EmailPromotion" , "AdditionalContactInfo" , "Demographics" , "rowguid" , "ModifiedDate" ,'Actual' as "Environment" From AdventureWorks2008R2.Person.Person )

Among 10 compared rows, some differences in SQL queries results found - expected [0] but found [10]

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: nuget/setup-nuget@v1, actions/upload-artifact@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/upload-artifact@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, nuget/setup-nuget@v1, actions/upload-artifact@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.