Update restoreBackup.ps1 #53
Annotations
20 errors
DBTestCompare.nmb_of_results.Exception_assert_equal_FAIL:
images/DBTestCompare.png#L85
java.lang.Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near ";"
Position: 170
Assert Query : select COUNT(*) from (
SELECT addressid, addressline1, addressline2, city, stateprovinceid, postalcode, modifieddate
FROM public.personaddress
LIMIT 1;
--query raise SQL Exception
) countTable
|
DBTestCompare.fetch_compare_test.Exception_inline_sql_SQL_SERVER_PostgreSQL_FAIL:
images/DBTestCompare.png#L85
java.lang.Exception: org.testng.TestException:
Queries results have a different number of columns 6 / 7
Query 1:
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
--,[City]
,[StateProvinceID]
,[PostalCode]
,convert(varchar(30),[ModifiedDate],121)
FROM [AdventureWorks2008R2].[Person].[Address]
WHERE ModifiedDate BETWEEN '2003-02-21 00:00:00.000' AND '2004-02-21 00:00:00.000'
order by AddressID
--query raise SQL Exception
Query 2:
SELECT addressid, addressline1, addressline2, city, stateprovinceid, postalcode, modifieddate
FROM public.personaddress
WHERE modifieddate BETWEEN '2003-02-21 00:00:00.000' AND '2004-02-21 00:00:00.000'
order by addressid;
|
DBTestCompare.minus_many_xml_files.ExceptionPersonAddress_SQL_SERVER_first_FAIL:
images/DBTestCompare.png#L85
java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Minus Query : (
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
--,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 1
--query raise SQL Exception
EXCEPT
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 2
) UNION ALL (
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 2
EXCEPT
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
--,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 1
--query raise SQL Exception
)
|
DBTestCompare.minus_many_xml_files.PersonAddress_SQL_SERVER_first_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.sql-from-file.misconfigured_FAIL:
images/DBTestCompare.png#L82
org.testng.TestException:
Element SQL should have the filename attribute or sql value defined (NOT both). Test file is invalid /home/runner/work/DBTestCompare/DBTestCompare/target/test-definitions/sql-from-file/misconfigured_FAIL.xml
|
DBTestCompare.minus_many_xml_files.PersonAddress_SQL_SERVER_diffTableSize_0_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.minus_on_union.SQL_SERVER_union_noIndicator_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.fetch_compare_test.from_file_sql_MySQL_PostgreSQL_FAIL:
images/DBTestCompare.png#L106
Among 37 compared rows, some differences in SQL queries results found - expected [0] but found [10]
|
DBTestCompare.key_comparator.ContactType.KeyContactType_FAIL:
images/DBTestCompare.png#L106
Among 2 compared rows, some differences in SQL queries results found - expected [0] but found [1]
|
DBTestCompare.minus_on_union.SQL_SERVER_union_withIndicator_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.minus_many_xml_files.PersonAddress_SQL_SERVER_diffTableSize_0_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.minus_on_union.SQL_SERVER_union_noIndicator_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.minus_on_union.SQL_SERVER_union_withIndicator_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.sql-from-file.misconfigured_FAIL:
images/DBTestCompare.png#L82
org.testng.TestException:
Element SQL should have the filename attribute or sql value defined (NOT both). Test file is invalid /home/runner/work/DBTestCompare/DBTestCompare/target/test-definitions/sql-from-file/misconfigured_FAIL.xml
|
DBTestCompare.minus_many_xml_files.PersonAddress_SQL_SERVER_first_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
DBTestCompare.key_comparator.ContactType.KeyContactType_FAIL:
images/DBTestCompare.png#L106
Among 2 compared rows, some differences in SQL queries results found - expected [0] but found [1]
|
DBTestCompare.fetch_compare_test.Exception_inline_sql_SQL_SERVER_PostgreSQL_FAIL:
images/DBTestCompare.png#L85
java.lang.Exception: org.testng.TestException:
Queries results have a different number of columns 6 / 7
Query 1:
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
--,[City]
,[StateProvinceID]
,[PostalCode]
,convert(varchar(30),[ModifiedDate],121)
FROM [AdventureWorks2008R2].[Person].[Address]
WHERE ModifiedDate BETWEEN '2003-02-21 00:00:00.000' AND '2004-02-21 00:00:00.000'
order by AddressID
--query raise SQL Exception
Query 2:
SELECT addressid, addressline1, addressline2, city, stateprovinceid, postalcode, modifieddate
FROM public.personaddress
WHERE modifieddate BETWEEN '2003-02-21 00:00:00.000' AND '2004-02-21 00:00:00.000'
order by addressid;
|
DBTestCompare.minus_many_xml_files.ExceptionPersonAddress_SQL_SERVER_first_FAIL:
images/DBTestCompare.png#L85
java.lang.Exception: com.microsoft.sqlserver.jdbc.SQLServerException: All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Minus Query : (
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
--,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 1
--query raise SQL Exception
EXCEPT
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 2
) UNION ALL (
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 2
EXCEPT
SELECT [AddressID]
,[AddressLine1]
,[AddressLine2]
--,[City]
,[StateProvinceID]
,[PostalCode]
,[ModifiedDate]
FROM [AdventureWorks2008R2].[Person].[Address]
where AddressID <> 1
--query raise SQL Exception
)
|
DBTestCompare.fetch_compare_test.from_file_sql_MySQL_PostgreSQL_FAIL:
images/DBTestCompare.png#L106
Among 37 compared rows, some differences in SQL queries results found - expected [0] but found [10]
|
DBTestCompare.nmb_of_results.Exception_assert_equal_FAIL:
images/DBTestCompare.png#L85
java.lang.Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near ";"
Position: 170
Assert Query : select COUNT(*) from (
SELECT addressid, addressline1, addressline2, city, stateprovinceid, postalcode, modifieddate
FROM public.personaddress
LIMIT 1;
--query raise SQL Exception
) countTable
|
Artifacts
Produced during runtime
Name | Size | |
---|---|---|
DBTestCompare1.9.5
|
15.1 MB |
|
DBTestCompare1.9.5.TestDefinitionsResults.53
|
43.8 KB |
|
DBTestCompare1.9.5.TestResults.53
|
112 KB |
|