sharpen ut net #519
GitHub Actions / test-result-IT
failed
Aug 5, 2024 in 0s
4 tests run, 2 passed, 0 skipped, 2 failed.
Annotations
Check failure on line 34 in qacover-core/src/it/java/test4giis/qacover/it/ITTests.java
github-actions / test-result-IT
ITTests.testItQacoverSpring
There are 2 failed assertion(s)
Aggregated visual diffs at: target/diff-aggregated-testItQacoverSpring.html
Failure 1: Strings are different. First diff at line 2 column 12.
Differences comparing index.html.
- Visual diffs at: target/diff-it-src-test-resources-spring-petclinic-main-index.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.testItQacoverSpring(ITTests.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
Failure 2: Strings are different. First diff at line 2 column 12.
Differences comparing org.springframework.samples.petclinic.PetclinicIntegrationTests.html.
- Visual diffs at: target/diff-it-src-test-resources-spring-petclinic-main-org.springframework.samples.petclinic.PetclinicIntegrationTests.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:91)
at test4giis.qacover.it.ITTests.testItQacoverSpring(ITTests.java:58) expected:<...pe html>
<html lang=["en">
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container">
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr><td>TOTAL</td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td></tr>
<tr><td><a href="org.springframework.samples.petclinic.PetclinicIntegrationTests.html">org.springframework.samples.petclinic.PetclinicIntegrationTests</a></td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td></tr>
</table>
<div><span style="float:right;"><small>Generated by: QACover java - [version x.y.z]</small></span></div>
</div>
</body>
</html>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang="en">
<head>
<title>org.springframework.samples.petclinic.PetclinicIntegrationTests</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container fill">
<h4>org.springframework.samples.petclinic.PetclinicIntegrationTests</h4>
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading">
<table class="table table-striped table-sm">
<tr>
<td><a data-toggle="collapse" data-parent="#accordion" href="#query0">testFindAll:32</a>
<br/><strong></strong> (0/0) 1 run(s)
</td>
<td valign="top">select vet0_.id as id1_5_, vet0_.first_name as first_na2_5_, vet0_.last_name as last_nam3_5_ from vets vet0_
</td>
</tr>
</table>
</div>
<div class="panel-collapse collapse" id="query0">
<table class="table table-sm">
<tr><th>ID</th><th>dead</th><th>count</th><th>category</th><th>type</th><th>subtype</th><th>location</th></tr>
</table></div></div>
<div class="panel panel-default">
<div class="panel-heading">
<table class="table table-striped table-sm">
<tr>
<td><a data-toggle="collapse" data-parent="#accordion" href="#query1">testFindAll:32</a>
<br/><strong>66%</strong> (2/3) 6 run(s)
</td>
<td valign="top"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> specialtie0_.vet_id = ?1?
</td>
</tr>
</table>
</div>
<div class="panel-collapse collapse" id="query1">
<table class="table table-sm">
<tr><th>ID</th><th>dead</th><th>count</th><th>category</th><th>type</th><th>subtype</th><th>location</th></tr>
<tr><td><strong>1</strong></td><td>6</td><td>6</td>
<td>S</td><td>T</td><td>FF</td><td>1.w.1.[WHERE specialtie0_.vet_id = ?1?]</td></tr>
<td colspan="7" style="background:palegreen;" ><div class="row"><div class="col-5">--A set of joined tables such that:<br/>--The WHERE condition fulfills:<br/> --(F) specialtie0_.vet_id = ?1? is FALSE</div><div class="col-7"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> NOT(specialtie0_.vet_id = ?1?)</div></div></td></tr>
<tr><td><strong>2</strong></td><td>4</td><td>6</td>
<td>S</td><td>T</td><td>TF</td><td>1.w.1.[WHERE specialtie0_.vet_id = ?1?]</td></tr>
<td colspan="7" style="background:palegreen;" ><div class="row"><div class="col-5">--A set of joined tables such that:<br/>--The WHERE condition fulfills:<br/> --(T) specialtie0_.vet_id = ?1? is TRUE</div><div class="col-7"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> (specialtie0_.vet_id = ?1?)</div></div></td></tr>
<tr><td><strong>3</strong></td><td>0</td><td>6</td>
<td>J</td><td>R</td><td>O</td><td>1.j.1.[INNER JOIN]</td></tr>
<td colspan="7" style="background:lightyellow;" ><div class="row"><div class="col-5"><br/>--The JOIN tables fulfill:<br/>--COMMENT: Reduced conditions: [WHERE specialtie0_.vet_id = ?1?] ; <br/> --summary: [VET_SPECIALTIES specialtie0_] right [SPECIALTIES specialty1_] ON specialtie0_.specialty_id = specialty1_.id<br/> --There exist some row in table SPECIALTIES specialty1_<br/> --which does not join to any table in VET_SPECIALTIES specialtie0_</div><div class="col-7"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>RIGHT JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> (specialtie0_.SPECIALTY_ID IS NULL) AND (specialty1_.ID IS NOT NULL)</div></div></td></tr>
</table></div></div>
</div>
</div>
</body>
</html>]> but was:<...pe html>
<html lang=['en'>
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
.progress {margin-bottom: 0 !important; }
tr.class-row td { padding-top: 2px; padding-bottom: 2px; }
</style>
</head>
<body>
<div class='container'>
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr class='class-row'>
<td>TOTAL</td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td>
</tr>
<tr class='class-row'>
<td><a href="org.springframework.samples.petclinic.PetclinicIntegrationTests.html">org.springframework.samples.petclinic.PetclinicIntegrationTests</a></td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td>
</tr>
</table>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang='en'>
<head>
<title>org.springframework.samples.petclinic.PetclinicIntegrationTests</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
tr.line, tr.line td { line-height:18px; padding-top:0; padding-bottom:0 }
tr.query-run td, tr.rule-summary td, tr.rule-sql td, tr.rule-error td { padding-top:0; padding-bottom:0 } code { color: DimGray; position: absolute; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
tbody.query { background: lightgrey; }
td.nowrap { white-space: nowrap; }
td.covered { background:aquamarine; }
td.uncovered { background:lightyellow; }
.params { font-size: small; font-style: italic }
.rules-show, .rules-hide, .params-show, .params-hide { cursor: pointer; }
</style>
<script>
$(document).ready(function() {
$('.rules').show();
$('.rules-show').show();
$('.rules-hide').hide();
$('.params-show').show();
$('.params-hide').hide();
$('.rules').hide();
$('.params').hide();
$('.query br.canhide').hide();
$('.rules br.canhide').show();
if ($('#view-source').is(':checked')) { $('.method').hide(); } else { $('.method').show(); }
$('.rules-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').next('.rules').show(); });
$('.rules-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').next('.rules').hide(); });
$('.params-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').find('.params').show(); $(this).closest('.query').next('.rules').find('.params').show(); });
$('.params-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').find('.params').hide(); $(this).closest('.query').next('.rules').find('.params').hide(); });
$('#format-queries').change(function(){ if ($(this).is(':checked')) $('.query br.canhide').show(); else $('.query br.canhide').hide(); });
$('#format-rules').change(function(){ if ($(this).is(':checked')) $('.rules br.canhide').show(); else $('.rules br.canhide').hide(); });
$('#view-source').change(function() {
if ($(this).is(':checked')) { $('.line-code').show(); $('code').show(); $('.method').hide(); }
else { $('.line-code').hide(); $('code').hide(); $('.method').show(); }
}
)});
</script>
</head>
<body style='overflow-x: hidden;'>
<div class='container fill'>
<div class='sticky-md-top text-bg-light'>
<h4><a href='./index.html'>[Index]</a> org.springframework.samples.petclinic.PetclinicIntegrationTests</h4>
<div class='col-auto'>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='view-source' type='checkbox' value='' checked>
<label class='form-check-label' for='view-source'>View source</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-queries' type='checkbox' value=''>
<label class='form-check-label' for='format-queries'>Format queries</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-rules' type='checkbox' value='' checked>
<label class='form-check-label' for='format-rules'>Format rules</label>
</div>
</div>
</div>
<div>
<table class='table table-sm table-borderless'>
<thead><th>Line</th><th>Coverage</th><th>Source code/method, queries and rules</th></thead>
<tr class='line line-coverage'>
<td>32</td>
<td class='nowrap'><strong></strong> (0/0)</td>
<td colspan='2'>
<span class='text-primary font-weight-bold method'>testFindAll</span>
<code>(source code not available) (source code not available) (source code not available)</code>
</td>
</tr>
<tbody class='query'>
<tr class='query-run'>
<td></td>
<td class='nowrap'>
<span class='rules-show' title='Show rules'>▼</span><span class='rules-hide' title='Hide rules'>▲</span>
1 run(s)
<span class='params-show' title='Show run params'>▷</span><span class='params-hide' title='Hide run paramss'>◁</span>
</td>
<td colspan='2'>
<div class='params'>(run params not available)</div>
select vet0_.id as id1_5_, vet0_.first_name as first_na2_5_, vet0_.last_name as last_nam3_5_ from vets vet0_ </td>
</tr>
</tbody>
<tbody class='rules'>
<tr><td></td></tr>
</tbody>
<tr class='line line-coverage'>
<td>32</td>
<td class='nowrap'><strong>66%</strong> (2/3)</td>
<td colspan='2'>
<span class='text-primary font-weight-bold method'>testFindAll</span>
<code>(source code not available) (source code not available) (source code not available)</code>
</td>
</tr>
<tbody class='query'>
<tr class='query-run'>
<td></td>
<td class='nowrap'>
<span class='rules-show' title='Show rules'>▼</span><span class='rules-hide' title='Hide rules'>▲</span>
6 run(s)
<span class='params-show' title='Show run params'>▷</span><span class='params-hide' title='Hide run paramss'>◁</span>
</td>
<td colspan='2'>
<div class='params'>(run params not available)</div>
<strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> specialtie0_.vet_id = ?1? </td>
</tr>
</tbody>
<tbody class='rules'>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>1</strong> - dead: 6 count: 6</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: FF location: 1.w.1.[WHERE specialtie0_.vet_id = ?1?]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='covered'>--A set of joined tables such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(F) specialtie0_.vet_id = ?1? is FALSE</td>
<td class='covered'><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> NOT(specialtie0_.vet_id = ?1?)</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>2</strong> - dead: 4 count: 6</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: TF location: 1.w.1.[WHERE specialtie0_.vet_id = ?1?]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='covered'>--A set of joined tables such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(T) specialtie0_.vet_id = ?1? is TRUE</td>
<td class='covered'><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> (specialtie0_.vet_id = ?1?)</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>3</strong> - dead: 0 count: 6</td>
<td class='coverage' colspan='2'>
category: J type: R subtype: O location: 1.j.1.[INNER JOIN]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='uncovered'> <br class='canhide'/>--The JOIN tables fulfill: <br class='canhide'/>--COMMENT: Reduced conditions: [WHERE specialtie0_.vet_id = ?1?] ; <br class='canhide'/> --summary: [VET_SPECIALTIES specialtie0_] right [SPECIALTIES specialty1_] ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/> --There exist some row in table SPECIALTIES specialty1_ <br class='canhide'/> --which does not join to any table in VET_SPECIALTIES specialtie0_</td>
<td class='uncovered'><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>RIGHT JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> (specialtie0_.SPECIALTY_ID IS NULL) AND (specialty1_.ID IS NOT NULL)</td>
</tr>
<tr><td></td></tr>
</tbody>
</table>
</div>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
]>Raw output
org.junit.ComparisonFailure:
There are 2 failed assertion(s)
Aggregated visual diffs at: target/diff-aggregated-testItQacoverSpring.html
Failure 1: Strings are different. First diff at line 2 column 12.
Differences comparing index.html.
- Visual diffs at: target/diff-it-src-test-resources-spring-petclinic-main-index.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.testItQacoverSpring(ITTests.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
Failure 2: Strings are different. First diff at line 2 column 12.
Differences comparing org.springframework.samples.petclinic.PetclinicIntegrationTests.html.
- Visual diffs at: target/diff-it-src-test-resources-spring-petclinic-main-org.springframework.samples.petclinic.PetclinicIntegrationTests.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:91)
at test4giis.qacover.it.ITTests.testItQacoverSpring(ITTests.java:58) expected:<...pe html>
<html lang=["en">
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container">
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr><td>TOTAL</td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td></tr>
<tr><td><a href="org.springframework.samples.petclinic.PetclinicIntegrationTests.html">org.springframework.samples.petclinic.PetclinicIntegrationTests</a></td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td></tr>
</table>
<div><span style="float:right;"><small>Generated by: QACover java - [version x.y.z]</small></span></div>
</div>
</body>
</html>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang="en">
<head>
<title>org.springframework.samples.petclinic.PetclinicIntegrationTests</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container fill">
<h4>org.springframework.samples.petclinic.PetclinicIntegrationTests</h4>
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading">
<table class="table table-striped table-sm">
<tr>
<td><a data-toggle="collapse" data-parent="#accordion" href="#query0">testFindAll:32</a>
<br/><strong></strong> (0/0) 1 run(s)
</td>
<td valign="top">select vet0_.id as id1_5_, vet0_.first_name as first_na2_5_, vet0_.last_name as last_nam3_5_ from vets vet0_
</td>
</tr>
</table>
</div>
<div class="panel-collapse collapse" id="query0">
<table class="table table-sm">
<tr><th>ID</th><th>dead</th><th>count</th><th>category</th><th>type</th><th>subtype</th><th>location</th></tr>
</table></div></div>
<div class="panel panel-default">
<div class="panel-heading">
<table class="table table-striped table-sm">
<tr>
<td><a data-toggle="collapse" data-parent="#accordion" href="#query1">testFindAll:32</a>
<br/><strong>66%</strong> (2/3) 6 run(s)
</td>
<td valign="top"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> specialtie0_.vet_id = ?1?
</td>
</tr>
</table>
</div>
<div class="panel-collapse collapse" id="query1">
<table class="table table-sm">
<tr><th>ID</th><th>dead</th><th>count</th><th>category</th><th>type</th><th>subtype</th><th>location</th></tr>
<tr><td><strong>1</strong></td><td>6</td><td>6</td>
<td>S</td><td>T</td><td>FF</td><td>1.w.1.[WHERE specialtie0_.vet_id = ?1?]</td></tr>
<td colspan="7" style="background:palegreen;" ><div class="row"><div class="col-5">--A set of joined tables such that:<br/>--The WHERE condition fulfills:<br/> --(F) specialtie0_.vet_id = ?1? is FALSE</div><div class="col-7"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> NOT(specialtie0_.vet_id = ?1?)</div></div></td></tr>
<tr><td><strong>2</strong></td><td>4</td><td>6</td>
<td>S</td><td>T</td><td>TF</td><td>1.w.1.[WHERE specialtie0_.vet_id = ?1?]</td></tr>
<td colspan="7" style="background:palegreen;" ><div class="row"><div class="col-5">--A set of joined tables such that:<br/>--The WHERE condition fulfills:<br/> --(T) specialtie0_.vet_id = ?1? is TRUE</div><div class="col-7"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> (specialtie0_.vet_id = ?1?)</div></div></td></tr>
<tr><td><strong>3</strong></td><td>0</td><td>6</td>
<td>J</td><td>R</td><td>O</td><td>1.j.1.[INNER JOIN]</td></tr>
<td colspan="7" style="background:lightyellow;" ><div class="row"><div class="col-5"><br/>--The JOIN tables fulfill:<br/>--COMMENT: Reduced conditions: [WHERE specialtie0_.vet_id = ?1?] ; <br/> --summary: [VET_SPECIALTIES specialtie0_] right [SPECIALTIES specialty1_] ON specialtie0_.specialty_id = specialty1_.id<br/> --There exist some row in table SPECIALTIES specialty1_<br/> --which does not join to any table in VET_SPECIALTIES specialtie0_</div><div class="col-7"><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br/><strong>FROM</strong> vet_specialties specialtie0_ <br/><strong>RIGHT JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br/><strong>WHERE</strong> (specialtie0_.SPECIALTY_ID IS NULL) AND (specialty1_.ID IS NOT NULL)</div></div></td></tr>
</table></div></div>
</div>
</div>
</body>
</html>]> but was:<...pe html>
<html lang=['en'>
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
.progress {margin-bottom: 0 !important; }
tr.class-row td { padding-top: 2px; padding-bottom: 2px; }
</style>
</head>
<body>
<div class='container'>
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr class='class-row'>
<td>TOTAL</td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td>
</tr>
<tr class='class-row'>
<td><a href="org.springframework.samples.petclinic.PetclinicIntegrationTests.html">org.springframework.samples.petclinic.PetclinicIntegrationTests</a></td>
<td>66%</td>
<td><div style="width:90px;" class="progress">
<div style="width:66%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="66" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>7</td><td>2</td><td>0</td><td>2</td><td>3</td><td>0</td>
</tr>
</table>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang='en'>
<head>
<title>org.springframework.samples.petclinic.PetclinicIntegrationTests</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
tr.line, tr.line td { line-height:18px; padding-top:0; padding-bottom:0 }
tr.query-run td, tr.rule-summary td, tr.rule-sql td, tr.rule-error td { padding-top:0; padding-bottom:0 } code { color: DimGray; position: absolute; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
tbody.query { background: lightgrey; }
td.nowrap { white-space: nowrap; }
td.covered { background:aquamarine; }
td.uncovered { background:lightyellow; }
.params { font-size: small; font-style: italic }
.rules-show, .rules-hide, .params-show, .params-hide { cursor: pointer; }
</style>
<script>
$(document).ready(function() {
$('.rules').show();
$('.rules-show').show();
$('.rules-hide').hide();
$('.params-show').show();
$('.params-hide').hide();
$('.rules').hide();
$('.params').hide();
$('.query br.canhide').hide();
$('.rules br.canhide').show();
if ($('#view-source').is(':checked')) { $('.method').hide(); } else { $('.method').show(); }
$('.rules-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').next('.rules').show(); });
$('.rules-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').next('.rules').hide(); });
$('.params-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').find('.params').show(); $(this).closest('.query').next('.rules').find('.params').show(); });
$('.params-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').find('.params').hide(); $(this).closest('.query').next('.rules').find('.params').hide(); });
$('#format-queries').change(function(){ if ($(this).is(':checked')) $('.query br.canhide').show(); else $('.query br.canhide').hide(); });
$('#format-rules').change(function(){ if ($(this).is(':checked')) $('.rules br.canhide').show(); else $('.rules br.canhide').hide(); });
$('#view-source').change(function() {
if ($(this).is(':checked')) { $('.line-code').show(); $('code').show(); $('.method').hide(); }
else { $('.line-code').hide(); $('code').hide(); $('.method').show(); }
}
)});
</script>
</head>
<body style='overflow-x: hidden;'>
<div class='container fill'>
<div class='sticky-md-top text-bg-light'>
<h4><a href='./index.html'>[Index]</a> org.springframework.samples.petclinic.PetclinicIntegrationTests</h4>
<div class='col-auto'>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='view-source' type='checkbox' value='' checked>
<label class='form-check-label' for='view-source'>View source</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-queries' type='checkbox' value=''>
<label class='form-check-label' for='format-queries'>Format queries</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-rules' type='checkbox' value='' checked>
<label class='form-check-label' for='format-rules'>Format rules</label>
</div>
</div>
</div>
<div>
<table class='table table-sm table-borderless'>
<thead><th>Line</th><th>Coverage</th><th>Source code/method, queries and rules</th></thead>
<tr class='line line-coverage'>
<td>32</td>
<td class='nowrap'><strong></strong> (0/0)</td>
<td colspan='2'>
<span class='text-primary font-weight-bold method'>testFindAll</span>
<code>(source code not available) (source code not available) (source code not available)</code>
</td>
</tr>
<tbody class='query'>
<tr class='query-run'>
<td></td>
<td class='nowrap'>
<span class='rules-show' title='Show rules'>▼</span><span class='rules-hide' title='Hide rules'>▲</span>
1 run(s)
<span class='params-show' title='Show run params'>▷</span><span class='params-hide' title='Hide run paramss'>◁</span>
</td>
<td colspan='2'>
<div class='params'>(run params not available)</div>
select vet0_.id as id1_5_, vet0_.first_name as first_na2_5_, vet0_.last_name as last_nam3_5_ from vets vet0_ </td>
</tr>
</tbody>
<tbody class='rules'>
<tr><td></td></tr>
</tbody>
<tr class='line line-coverage'>
<td>32</td>
<td class='nowrap'><strong>66%</strong> (2/3)</td>
<td colspan='2'>
<span class='text-primary font-weight-bold method'>testFindAll</span>
<code>(source code not available) (source code not available) (source code not available)</code>
</td>
</tr>
<tbody class='query'>
<tr class='query-run'>
<td></td>
<td class='nowrap'>
<span class='rules-show' title='Show rules'>▼</span><span class='rules-hide' title='Hide rules'>▲</span>
6 run(s)
<span class='params-show' title='Show run params'>▷</span><span class='params-hide' title='Hide run paramss'>◁</span>
</td>
<td colspan='2'>
<div class='params'>(run params not available)</div>
<strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> specialtie0_.vet_id = ?1? </td>
</tr>
</tbody>
<tbody class='rules'>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>1</strong> - dead: 6 count: 6</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: FF location: 1.w.1.[WHERE specialtie0_.vet_id = ?1?]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='covered'>--A set of joined tables such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(F) specialtie0_.vet_id = ?1? is FALSE</td>
<td class='covered'><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> NOT(specialtie0_.vet_id = ?1?)</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>2</strong> - dead: 4 count: 6</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: TF location: 1.w.1.[WHERE specialtie0_.vet_id = ?1?]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='covered'>--A set of joined tables such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(T) specialtie0_.vet_id = ?1? is TRUE</td>
<td class='covered'><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>INNER JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> (specialtie0_.vet_id = ?1?)</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>3</strong> - dead: 0 count: 6</td>
<td class='coverage' colspan='2'>
category: J type: R subtype: O location: 1.j.1.[INNER JOIN]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='uncovered'> <br class='canhide'/>--The JOIN tables fulfill: <br class='canhide'/>--COMMENT: Reduced conditions: [WHERE specialtie0_.vet_id = ?1?] ; <br class='canhide'/> --summary: [VET_SPECIALTIES specialtie0_] right [SPECIALTIES specialty1_] ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/> --There exist some row in table SPECIALTIES specialty1_ <br class='canhide'/> --which does not join to any table in VET_SPECIALTIES specialtie0_</td>
<td class='uncovered'><strong>SELECT</strong> specialtie0_.vet_id AS vet_id1_4_0_ , specialtie0_.specialty_id AS specialt2_4_0_ , specialty1_.id AS id1_2_1_ , specialty1_.name AS name2_2_1_ <br class='canhide'/><strong>FROM</strong> vet_specialties specialtie0_ <br class='canhide'/><strong>RIGHT JOIN</strong> specialties specialty1_ ON specialtie0_.specialty_id = specialty1_.id <br class='canhide'/><strong>WHERE</strong> (specialtie0_.SPECIALTY_ID IS NULL) AND (specialty1_.ID IS NOT NULL)</td>
</tr>
<tr><td></td></tr>
</tbody>
</table>
</div>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
]>
at org.junit.Assert.assertEquals(Assert.java:117)
at giis.visualassert.FrameworkAssert.failNotEquals(FrameworkAssert.java:25)
at giis.visualassert.SoftVisualAssert.assertAll(SoftVisualAssert.java:120)
at test4giis.qacover.it.ITTests.tearDown(ITTests.java:34)
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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
at org.junit.internal.runners.statements.RunAfters.invokeMethod(RunAfters.java:46)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33)
at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:316)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:240)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:214)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:155)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:385)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:162)
at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:507)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:495)
Check failure on line 34 in qacover-core/src/it/java/test4giis/qacover/it/ITTests.java
github-actions / test-result-IT
ITTests.testItQacoverUber
There are 2 failed assertion(s)
Aggregated visual diffs at: target/diff-aggregated-testItQacoverUber.html
Failure 1: Strings are different. First diff at line 2 column 12.
Differences comparing index.html.
- Visual diffs at: target/diff-it-src-test-resources-qacover-uber-main-index.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.testItQacoverUber(ITTests.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
Failure 2: Strings are different. First diff at line 2 column 12.
Differences comparing TestUber.html.
- Visual diffs at: target/diff-it-src-test-resources-qacover-uber-main-TestUber.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:91)
at test4giis.qacover.it.ITTests.testItQacoverUber(ITTests.java:70) expected:<...pe html>
<html lang=["en">
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container">
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr><td>TOTAL</td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td></tr>
<tr><td><a href="TestUber.html">TestUber</a></td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td></tr>
</table>
<div><span style="float:right;"><small>Generated by: QACover java - [version x.y.z]</small></span></div>
</div>
</body>
</html>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang="en">
<head>
<title>TestUber</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container fill">
<h4>TestUber</h4>
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading">
<table class="table table-striped table-sm">
<tr>
<td><a data-toggle="collapse" data-parent="#accordion" href="#query0">runQuery1:-1</a>
<br/><strong>33%</strong> (1/3) 1 run(s)
</td>
<td valign="top">select * from test where text = 'abc'
</td>
</tr>
</table>
</div>
<div class="panel-collapse collapse" id="query0">
<table class="table table-sm">
<tr><th>ID</th><th>dead</th><th>count</th><th>category</th><th>type</th><th>subtype</th><th>location</th></tr>
<tr><td><strong>1</strong></td><td>0</td><td>1</td>
<td>S</td><td>T</td><td>FF</td><td>1.w.1.[WHERE text = 'abc']</td></tr>
<td colspan="7" style="background:lightyellow;" ><div class="row"><div class="col-5">--Some row in the table such that:<br/>--The WHERE condition fulfills:<br/> --(F) text = 'abc' is FALSE</div><div class="col-7"><strong>SELECT</strong> * <br/><strong>FROM</strong> test <br/><strong>WHERE</strong> NOT(text = 'abc')</div></div></td></tr>
<tr><td><strong>2</strong></td><td>1</td><td>1</td>
<td>S</td><td>T</td><td>TF</td><td>1.w.1.[WHERE text = 'abc']</td></tr>
<td colspan="7" style="background:palegreen;" ><div class="row"><div class="col-5">--Some row in the table such that:<br/>--The WHERE condition fulfills:<br/> --(T) text = 'abc' is TRUE</div><div class="col-7"><strong>SELECT</strong> * <br/><strong>FROM</strong> test <br/><strong>WHERE</strong> (text = 'abc')</div></div></td></tr>
<tr><td><strong>3</strong></td><td>0</td><td>1</td>
<td>S</td><td>N</td><td>NF</td><td>1.w.1.[text]</td></tr>
<td colspan="7" style="background:lightyellow;" ><div class="row"><div class="col-5">--Some row in the table such that:<br/>--The WHERE condition fulfills:<br/> --(N) text is NULL</div><div class="col-7"><strong>SELECT</strong> * <br/><strong>FROM</strong> test <br/><strong>WHERE</strong> (text IS NULL)</div></div></td></tr>
</table></div></div>
</div>
</div>
</body>
</html>]> but was:<...pe html>
<html lang=['en'>
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
.progress {margin-bottom: 0 !important; }
tr.class-row td { padding-top: 2px; padding-bottom: 2px; }
</style>
</head>
<body>
<div class='container'>
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr class='class-row'>
<td>TOTAL</td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td>
</tr>
<tr class='class-row'>
<td><a href="TestUber.html">TestUber</a></td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td>
</tr>
</table>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang='en'>
<head>
<title>TestUber</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
tr.line, tr.line td { line-height:18px; padding-top:0; padding-bottom:0 }
tr.query-run td, tr.rule-summary td, tr.rule-sql td, tr.rule-error td { padding-top:0; padding-bottom:0 } code { color: DimGray; position: absolute; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
tbody.query { background: lightgrey; }
td.nowrap { white-space: nowrap; }
td.covered { background:aquamarine; }
td.uncovered { background:lightyellow; }
.params { font-size: small; font-style: italic }
.rules-show, .rules-hide, .params-show, .params-hide { cursor: pointer; }
</style>
<script>
$(document).ready(function() {
$('.rules').show();
$('.rules-show').show();
$('.rules-hide').hide();
$('.params-show').show();
$('.params-hide').hide();
$('.rules').hide();
$('.params').hide();
$('.query br.canhide').hide();
$('.rules br.canhide').show();
if ($('#view-source').is(':checked')) { $('.method').hide(); } else { $('.method').show(); }
$('.rules-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').next('.rules').show(); });
$('.rules-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').next('.rules').hide(); });
$('.params-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').find('.params').show(); $(this).closest('.query').next('.rules').find('.params').show(); });
$('.params-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').find('.params').hide(); $(this).closest('.query').next('.rules').find('.params').hide(); });
$('#format-queries').change(function(){ if ($(this).is(':checked')) $('.query br.canhide').show(); else $('.query br.canhide').hide(); });
$('#format-rules').change(function(){ if ($(this).is(':checked')) $('.rules br.canhide').show(); else $('.rules br.canhide').hide(); });
$('#view-source').change(function() {
if ($(this).is(':checked')) { $('.line-code').show(); $('code').show(); $('.method').hide(); }
else { $('.line-code').hide(); $('code').hide(); $('.method').show(); }
}
)});
</script>
</head>
<body style='overflow-x: hidden;'>
<div class='container fill'>
<div class='sticky-md-top text-bg-light'>
<h4><a href='./index.html'>[Index]</a> TestUber</h4>
<div class='col-auto'>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='view-source' type='checkbox' value='' checked>
<label class='form-check-label' for='view-source'>View source</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-queries' type='checkbox' value=''>
<label class='form-check-label' for='format-queries'>Format queries</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-rules' type='checkbox' value='' checked>
<label class='form-check-label' for='format-rules'>Format rules</label>
</div>
</div>
</div>
<div>
<table class='table table-sm table-borderless'>
<thead><th>Line</th><th>Coverage</th><th>Source code/method, queries and rules</th></thead>
<tr class='line line-coverage'>
<td>-1</td>
<td class='nowrap'><strong>33%</strong> (1/3)</td>
<td colspan='2'>
<span class='text-primary font-weight-bold method'>runQuery1</span>
<code>(source code not available) (source code not available) (source code not available)</code>
</td>
</tr>
<tbody class='query'>
<tr class='query-run'>
<td></td>
<td class='nowrap'>
<span class='rules-show' title='Show rules'>▼</span><span class='rules-hide' title='Hide rules'>▲</span>
1 run(s)
<span class='params-show' title='Show run params'>▷</span><span class='params-hide' title='Hide run paramss'>◁</span>
</td>
<td colspan='2'>
<div class='params'>(run params not available)</div>
select * from test where text = 'abc' </td>
</tr>
</tbody>
<tbody class='rules'>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>1</strong> - dead: 0 count: 1</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: FF location: 1.w.1.[WHERE text = 'abc']
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='uncovered'>--Some row in the table such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(F) text = 'abc' is FALSE</td>
<td class='uncovered'><strong>SELECT</strong> * <br class='canhide'/><strong>FROM</strong> test <br class='canhide'/><strong>WHERE</strong> NOT(text = 'abc')</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>2</strong> - dead: 1 count: 1</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: TF location: 1.w.1.[WHERE text = 'abc']
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='covered'>--Some row in the table such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(T) text = 'abc' is TRUE</td>
<td class='covered'><strong>SELECT</strong> * <br class='canhide'/><strong>FROM</strong> test <br class='canhide'/><strong>WHERE</strong> (text = 'abc')</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>3</strong> - dead: 0 count: 1</td>
<td class='coverage' colspan='2'>
category: S type: N subtype: NF location: 1.w.1.[text]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='uncovered'>--Some row in the table such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(N) text is NULL</td>
<td class='uncovered'><strong>SELECT</strong> * <br class='canhide'/><strong>FROM</strong> test <br class='canhide'/><strong>WHERE</strong> (text IS NULL)</td>
</tr>
<tr><td></td></tr>
</tbody>
</table>
</div>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
]>Raw output
org.junit.ComparisonFailure:
There are 2 failed assertion(s)
Aggregated visual diffs at: target/diff-aggregated-testItQacoverUber.html
Failure 1: Strings are different. First diff at line 2 column 12.
Differences comparing index.html.
- Visual diffs at: target/diff-it-src-test-resources-qacover-uber-main-index.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.testItQacoverUber(ITTests.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
Failure 2: Strings are different. First diff at line 2 column 12.
Differences comparing TestUber.html.
- Visual diffs at: target/diff-it-src-test-resources-qacover-uber-main-TestUber.html.html
- Call Stack:
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:98)
at test4giis.qacover.it.ITTests.assertFiles(ITTests.java:91)
at test4giis.qacover.it.ITTests.testItQacoverUber(ITTests.java:70) expected:<...pe html>
<html lang=["en">
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container">
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr><td>TOTAL</td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td></tr>
<tr><td><a href="TestUber.html">TestUber</a></td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td></tr>
</table>
<div><span style="float:right;"><small>Generated by: QACover java - [version x.y.z]</small></span></div>
</div>
</body>
</html>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang="en">
<head>
<title>TestUber</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
<style>.fill { min-width: 100%; width: 100%; } .progress {margin-bottom: 0 !important;}</style>
</head>
<body>
<div class="container fill">
<h4>TestUber</h4>
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading">
<table class="table table-striped table-sm">
<tr>
<td><a data-toggle="collapse" data-parent="#accordion" href="#query0">runQuery1:-1</a>
<br/><strong>33%</strong> (1/3) 1 run(s)
</td>
<td valign="top">select * from test where text = 'abc'
</td>
</tr>
</table>
</div>
<div class="panel-collapse collapse" id="query0">
<table class="table table-sm">
<tr><th>ID</th><th>dead</th><th>count</th><th>category</th><th>type</th><th>subtype</th><th>location</th></tr>
<tr><td><strong>1</strong></td><td>0</td><td>1</td>
<td>S</td><td>T</td><td>FF</td><td>1.w.1.[WHERE text = 'abc']</td></tr>
<td colspan="7" style="background:lightyellow;" ><div class="row"><div class="col-5">--Some row in the table such that:<br/>--The WHERE condition fulfills:<br/> --(F) text = 'abc' is FALSE</div><div class="col-7"><strong>SELECT</strong> * <br/><strong>FROM</strong> test <br/><strong>WHERE</strong> NOT(text = 'abc')</div></div></td></tr>
<tr><td><strong>2</strong></td><td>1</td><td>1</td>
<td>S</td><td>T</td><td>TF</td><td>1.w.1.[WHERE text = 'abc']</td></tr>
<td colspan="7" style="background:palegreen;" ><div class="row"><div class="col-5">--Some row in the table such that:<br/>--The WHERE condition fulfills:<br/> --(T) text = 'abc' is TRUE</div><div class="col-7"><strong>SELECT</strong> * <br/><strong>FROM</strong> test <br/><strong>WHERE</strong> (text = 'abc')</div></div></td></tr>
<tr><td><strong>3</strong></td><td>0</td><td>1</td>
<td>S</td><td>N</td><td>NF</td><td>1.w.1.[text]</td></tr>
<td colspan="7" style="background:lightyellow;" ><div class="row"><div class="col-5">--Some row in the table such that:<br/>--The WHERE condition fulfills:<br/> --(N) text is NULL</div><div class="col-7"><strong>SELECT</strong> * <br/><strong>FROM</strong> test <br/><strong>WHERE</strong> (text IS NULL)</div></div></td></tr>
</table></div></div>
</div>
</div>
</body>
</html>]> but was:<...pe html>
<html lang=['en'>
<head>
<title>SQL Query Fpc Coverage</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
.progress {margin-bottom: 0 !important; }
tr.class-row td { padding-top: 2px; padding-bottom: 2px; }
</style>
</head>
<body>
<div class='container'>
<h2>SQL Query Fpc Coverage</h2>
<table class="table table-striped table-sm">
<tr><th>Class</th><th>%</th><th></th><th>qrun</th><th>qcount</th><th>qerror</th><th>dead</th><th>count</th><th>error</th></tr>
<tr class='class-row'>
<td>TOTAL</td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td>
</tr>
<tr class='class-row'>
<td><a href="TestUber.html">TestUber</a></td>
<td>33%</td>
<td><div style="width:90px;" class="progress">
<div style="width:33%;" class="progress-bar bg-success" role="progressbar" aria-valuenow="33" aria-valuemin="0" aria-valuemax="100"></div>
</div></td>
<td>1</td><td>1</td><td>0</td><td>1</td><td>3</td><td>0</td>
</tr>
</table>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
---------------------------
-------- Failure 2 --------
---------------------------
<!doctype html>
<html lang='en'>
<head>
<title>TestUber</title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1, shrink-to-fit=no'>
<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css' integrity='sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk' crossorigin='anonymous'>
<script src='https://code.jquery.com/jquery-3.5.1.slim.min.js' integrity='sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj' crossorigin='anonymous'></script>
<script src='https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js' integrity='sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js' integrity='sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI' crossorigin='anonymous'></script>
<style>
.fill { min-width: 100%; width: 100%; }
tr.line, tr.line td { line-height:18px; padding-top:0; padding-bottom:0 }
tr.query-run td, tr.rule-summary td, tr.rule-sql td, tr.rule-error td { padding-top:0; padding-bottom:0 } code { color: DimGray; position: absolute; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; }
tbody.query { background: lightgrey; }
td.nowrap { white-space: nowrap; }
td.covered { background:aquamarine; }
td.uncovered { background:lightyellow; }
.params { font-size: small; font-style: italic }
.rules-show, .rules-hide, .params-show, .params-hide { cursor: pointer; }
</style>
<script>
$(document).ready(function() {
$('.rules').show();
$('.rules-show').show();
$('.rules-hide').hide();
$('.params-show').show();
$('.params-hide').hide();
$('.rules').hide();
$('.params').hide();
$('.query br.canhide').hide();
$('.rules br.canhide').show();
if ($('#view-source').is(':checked')) { $('.method').hide(); } else { $('.method').show(); }
$('.rules-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').next('.rules').show(); });
$('.rules-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').next('.rules').hide(); });
$('.params-show').click(function(){ $(this).hide(); $(this).next().show(); $(this).closest('.query').find('.params').show(); $(this).closest('.query').next('.rules').find('.params').show(); });
$('.params-hide').click(function(){ $(this).hide(); $(this).prev().show(); $(this).closest('.query').find('.params').hide(); $(this).closest('.query').next('.rules').find('.params').hide(); });
$('#format-queries').change(function(){ if ($(this).is(':checked')) $('.query br.canhide').show(); else $('.query br.canhide').hide(); });
$('#format-rules').change(function(){ if ($(this).is(':checked')) $('.rules br.canhide').show(); else $('.rules br.canhide').hide(); });
$('#view-source').change(function() {
if ($(this).is(':checked')) { $('.line-code').show(); $('code').show(); $('.method').hide(); }
else { $('.line-code').hide(); $('code').hide(); $('.method').show(); }
}
)});
</script>
</head>
<body style='overflow-x: hidden;'>
<div class='container fill'>
<div class='sticky-md-top text-bg-light'>
<h4><a href='./index.html'>[Index]</a> TestUber</h4>
<div class='col-auto'>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='view-source' type='checkbox' value='' checked>
<label class='form-check-label' for='view-source'>View source</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-queries' type='checkbox' value=''>
<label class='form-check-label' for='format-queries'>Format queries</label>
</div>
<div class='form-check form-check-inline'>
<input class='form-check-input' id='format-rules' type='checkbox' value='' checked>
<label class='form-check-label' for='format-rules'>Format rules</label>
</div>
</div>
</div>
<div>
<table class='table table-sm table-borderless'>
<thead><th>Line</th><th>Coverage</th><th>Source code/method, queries and rules</th></thead>
<tr class='line line-coverage'>
<td>-1</td>
<td class='nowrap'><strong>33%</strong> (1/3)</td>
<td colspan='2'>
<span class='text-primary font-weight-bold method'>runQuery1</span>
<code>(source code not available) (source code not available) (source code not available)</code>
</td>
</tr>
<tbody class='query'>
<tr class='query-run'>
<td></td>
<td class='nowrap'>
<span class='rules-show' title='Show rules'>▼</span><span class='rules-hide' title='Hide rules'>▲</span>
1 run(s)
<span class='params-show' title='Show run params'>▷</span><span class='params-hide' title='Hide run paramss'>◁</span>
</td>
<td colspan='2'>
<div class='params'>(run params not available)</div>
select * from test where text = 'abc' </td>
</tr>
</tbody>
<tbody class='rules'>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>1</strong> - dead: 0 count: 1</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: FF location: 1.w.1.[WHERE text = 'abc']
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='uncovered'>--Some row in the table such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(F) text = 'abc' is FALSE</td>
<td class='uncovered'><strong>SELECT</strong> * <br class='canhide'/><strong>FROM</strong> test <br class='canhide'/><strong>WHERE</strong> NOT(text = 'abc')</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>2</strong> - dead: 1 count: 1</td>
<td class='coverage' colspan='2'>
category: S type: T subtype: TF location: 1.w.1.[WHERE text = 'abc']
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='covered'>--Some row in the table such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(T) text = 'abc' is TRUE</td>
<td class='covered'><strong>SELECT</strong> * <br class='canhide'/><strong>FROM</strong> test <br class='canhide'/><strong>WHERE</strong> (text = 'abc')</td>
</tr>
<tr class='rule-summary'>
<td></td>
<td class='coverage' rowspan='2'><strong>3</strong> - dead: 0 count: 1</td>
<td class='coverage' colspan='2'>
category: S type: N subtype: NF location: 1.w.1.[text]
<div class='params'>(run params not available)</div>
</td>
</tr>
<tr class='rule-sql'>
<td></td>
<td class='uncovered'>--Some row in the table such that: <br class='canhide'/>--The WHERE condition fulfills: <br class='canhide'/> --(N) text is NULL</td>
<td class='uncovered'><strong>SELECT</strong> * <br class='canhide'/><strong>FROM</strong> test <br class='canhide'/><strong>WHERE</strong> (text IS NULL)</td>
</tr>
<tr><td></td></tr>
</tbody>
</table>
</div>
<div><span style="float:right;"><small>
Generated by: QACover java - [version x.y.z]</a>
</small></span></div>
</div>
</body>
]>
at org.junit.Assert.assertEquals(Assert.java:117)
at giis.visualassert.FrameworkAssert.failNotEquals(FrameworkAssert.java:25)
at giis.visualassert.SoftVisualAssert.assertAll(SoftVisualAssert.java:120)
at test4giis.qacover.it.ITTests.tearDown(ITTests.java:34)
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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
at org.junit.internal.runners.statements.RunAfters.invokeMethod(RunAfters.java:46)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33)
at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:316)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:240)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:214)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:155)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:385)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:162)
at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:507)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:495)
Loading