Skip to content

Automatic Dependency Submission (Maven) #2

Sign in to view logs

Automatic Dependency Submission (Maven)

Automatic Dependency Submission (Maven) #2

GitHub Actions / JUnit Test Report failed Dec 6, 2024 in 0s

30 tests run, 20 passed, 0 skipped, 10 failed.

Annotations

Check failure on line 82 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.sql-from-file.misconfigured_FAIL 

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
Raw output 
org.testng.TestException: 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
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:138)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: 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
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:82)
... 14 more

Check failure on line 85 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.nmb_of_results.Exception_assert_equal_FAIL 

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
Raw output 
org.testng.TestException: 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
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:138)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: 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
at uk.co.objectivity.test.db.comparators.NmbOfResultsComparator.compare(NmbOfResultsComparator.java:67)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:85)
... 14 more

Check failure on line 110 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.minus_many_xml_files.PersonAddress_SQL_SERVER_first_FAIL 

Differences in SQL queries found -  expected [0] but found [2]
Raw output 
java.lang.AssertionError: Differences in SQL queries found -  expected [0] but found [2]
at org.testng.Assert.fail(Assert.java:110)
at org.testng.Assert.failNotEquals(Assert.java:1413)
at org.testng.Assert.assertEqualsImpl(Assert.java:149)
at org.testng.Assert.assertEquals(Assert.java:131)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:110)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

Check failure on line 106 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.key_comparator.ContactType.KeyContactType_FAIL 

Among 2 compared rows, some differences in SQL queries results found -  expected [0] but found [1]
Raw output 
java.lang.AssertionError: Among 2 compared rows, some differences in SQL queries results found -  expected [0] but found [1]
at org.testng.Assert.fail(Assert.java:110)
at org.testng.Assert.failNotEquals(Assert.java:1413)
at org.testng.Assert.assertEqualsImpl(Assert.java:149)
at org.testng.Assert.assertEquals(Assert.java:131)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:106)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

Check failure on line 110 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.minus_on_union.SQL_SERVER_union_withIndicator_FAIL 

Differences in SQL queries found -  expected [0] but found [2]
Raw output 
java.lang.AssertionError: Differences in SQL queries found -  expected [0] but found [2]
at org.testng.Assert.fail(Assert.java:110)
at org.testng.Assert.failNotEquals(Assert.java:1413)
at org.testng.Assert.assertEqualsImpl(Assert.java:149)
at org.testng.Assert.assertEquals(Assert.java:131)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:110)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

Check failure on line 110 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.minus_on_union.SQL_SERVER_union_noIndicator_FAIL 

Differences in SQL queries found -  expected [0] but found [2]
Raw output 
java.lang.AssertionError: Differences in SQL queries found -  expected [0] but found [2]
at org.testng.Assert.fail(Assert.java:110)
at org.testng.Assert.failNotEquals(Assert.java:1413)
at org.testng.Assert.assertEqualsImpl(Assert.java:149)
at org.testng.Assert.assertEquals(Assert.java:131)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:110)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

Check failure on line 110 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.minus_many_xml_files.PersonAddress_SQL_SERVER_diffTableSize_0_FAIL 

Differences in SQL queries found -  expected [0] but found [2]
Raw output 
java.lang.AssertionError: Differences in SQL queries found -  expected [0] but found [2]
at org.testng.Assert.fail(Assert.java:110)
at org.testng.Assert.failNotEquals(Assert.java:1413)
at org.testng.Assert.assertEqualsImpl(Assert.java:149)
at org.testng.Assert.assertEquals(Assert.java:131)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:110)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

Check failure on line 106 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.fetch_compare_test.from_file_sql_MySQL_PostgreSQL_FAIL 

Among 37 compared rows, some differences in SQL queries results found -  expected [0] but found [10]
Raw output 
java.lang.AssertionError: Among 37 compared rows, some differences in SQL queries results found -  expected [0] but found [10]
at org.testng.Assert.fail(Assert.java:110)
at org.testng.Assert.failNotEquals(Assert.java:1413)
at org.testng.Assert.assertEqualsImpl(Assert.java:149)
at org.testng.Assert.assertEquals(Assert.java:131)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:106)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

Check failure on line 85 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.minus_many_xml_files.ExceptionPersonAddress_SQL_SERVER_first_FAIL 

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
        
        )
Raw output 
org.testng.TestException: 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
        
        )
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:138)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: 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
        
        )
at uk.co.objectivity.test.db.comparators.MinusComparator.compare(MinusComparator.java:76)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:85)
... 15 more

Check failure on line 85 in images/DBTestCompare.png

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DBTestCompare.fetch_compare_test.Exception_inline_sql_SQL_SERVER_PostgreSQL_FAIL 

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;
Raw output 
org.testng.TestException: 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;
        
        
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:138)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.testng.internal.invokers.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:136)
at org.testng.internal.invokers.TestInvoker.invokeMethod(TestInvoker.java:658)
at org.testng.internal.invokers.TestInvoker.invokeTestMethod(TestInvoker.java:219)
at org.testng.internal.invokers.MethodRunner.runInSequence(MethodRunner.java:50)
at org.testng.internal.invokers.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:923)
at org.testng.internal.invokers.TestInvoker.invokeTestMethods(TestInvoker.java:192)
at org.testng.internal.invokers.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
at org.testng.internal.invokers.TestMethodWorker.run(TestMethodWorker.java:128)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: 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;
        
        
at uk.co.objectivity.test.db.comparators.FetchComparator.compare(FetchComparator.java:81)
at uk.co.objectivity.test.db.DBTestCompare.testSQLResults(DBTestCompare.java:85)
... 14 more
View more details on GitHub Actions