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: 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 "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 "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 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" , "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 )

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" , "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 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: 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 "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 )