Automatic Dependency Submission (Maven) #2
github-advanced-security[bot]Annotations
40 errors, 1 warning, and 4 notices
|
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.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.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.minus_on_union.SQL_SERVER_union_withIndicator_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_many_xml_files.PersonAddress_SQL_SERVER_diffTableSize_0_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.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.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_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_first_FAIL:
images/DBTestCompare.png#L110
Differences in SQL queries found - expected [0] but found [2]
|
|
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_diffTableSize_0_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.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_on_union.SQL_SERVER_union_noIndicator_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.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.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.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.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_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.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.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_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.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.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.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_many_xml_files.PersonAddress_SQL_SERVER_diffTableSize_0_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]
|
|
submit-maven
ubuntu-latest pipelines will use ubuntu-24.04 soon. For more details, see https://github.com/actions/runner-images/issues/10636
|
|
submit-maven
Using Java 21 (temurin) with Maven 3.8.8
|
|
submit-maven
Submitting snapshot...
|
|
submit-maven
{
"manifests": {
"DBTestCompare": {
"resolved": {
"pkg:maven/org.testng/[email protected]?type=jar": {
"package_url": "pkg:maven/org.testng/[email protected]?type=jar",
"relationship": "direct",
"scope": "runtime",
"dependencies": [
"pkg:maven/com.google.code.findbugs/[email protected]?type=jar",
"pkg:maven/com.beust/[email protected]?type=jar",
"pkg:maven/org.webjars/[email protected]?type=jar"
]
},
"pkg:maven/com.google.code.findbugs/[email protected]?type=jar": {
"package_url": "pkg:maven/com.google.code.findbugs/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": []
},
"pkg:maven/com.beust/[email protected]?type=jar": {
"package_url": "pkg:maven/com.beust/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": []
},
"pkg:maven/org.webjars/[email protected]?type=jar": {
"package_url": "pkg:maven/org.webjars/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": []
},
"pkg:maven/com.sun.xml.bind/[email protected]?type=jar": {
"package_url": "pkg:maven/com.sun.xml.bind/[email protected]?type=jar",
"relationship": "direct",
"scope": "runtime",
"dependencies": [
"pkg:maven/com.sun.xml.bind/[email protected]?type=jar",
"pkg:maven/com.sun.xml.fastinfoset/[email protected]?type=jar"
]
},
"pkg:maven/com.sun.xml.bind/[email protected]?type=jar": {
"package_url": "pkg:maven/com.sun.xml.bind/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": [
"pkg:maven/javax.xml.bind/[email protected]?type=jar",
"pkg:maven/com.sun.istack/[email protected]?type=jar"
]
},
"pkg:maven/javax.xml.bind/[email protected]?type=jar": {
"package_url": "pkg:maven/javax.xml.bind/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": []
},
"pkg:maven/com.sun.istack/[email protected]?type=jar": {
"package_url": "pkg:maven/com.sun.istack/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": []
},
"pkg:maven/com.sun.xml.fastinfoset/[email protected]?type=jar": {
"package_url": "pkg:maven/com.sun.xml.fastinfoset/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": [
"pkg:maven/javax.xml.bind/[email protected]?type=jar"
]
},
"pkg:maven/javax.xml.bind/[email protected]?type=jar": {
"package_url": "pkg:maven/javax.xml.bind/[email protected]?type=jar",
"relationship": "indirect",
"scope": "runtime",
"dependencies": []
},
"pkg:maven/javax.activation/[email protected]?type=jar": {
"package_url": "pkg:maven/javax.activation/[email protected]?type=jar",
"relationship": "direct",
|
|
submit-maven
Snapshot successfully created at 2024-12-06T11:44:01.071Z
|