Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create view ITest.vUnitTestAssociation as
- select UnitTestId, DockerExecutionContextId, StartTime = MIN(powa.StartTime) from (
- select u.UnitTestId,
- d.DockerExecutionContextId,
- d.StartTime
- from (select u.UnitTestId,
- u.RequirementId,
- wo.CKTraitWordId
- from ITest.tUnitTest u
- INNER JOIN CK.tCKTrait t ON u.RequirementId = t.CKTraitId
- INNER JOIN CK.tCKTraitSet w on t.CKTraitId = w.CKTraitId
- inner join CK.tCKTraitWord wo on w.CKTraitWordId = wo.CKTraitWordId) u
- INNER JOIN (select d.DockerExecutionContextId,
- d.RequirementId,
- d.StartTime,
- wo.CKTraitWordId
- from ITest.tDockerExecutionContext d
- INNER JOIN CK.tCKTrait t ON d.RequirementId = t.CKTraitId
- INNER JOIN CK.tCKTraitSet w on t.CKTraitId = w.CKTraitId
- inner join CK.tCKTraitWord wo on w.CKTraitWordId = wo.CKTraitWordId) d ON u.CKTraitWordId = d.CKTraitWordId
- where (select count(*) from (select kzz.DockerExecutionContextId,
- kzz.RequirementId,
- kzz.StartTime,
- wo.CKTraitWordId
- from ITest.tDockerExecutionContext kzz
- INNER JOIN CK.tCKTrait t ON kzz.RequirementId = t.CKTraitId
- INNER JOIN CK.tCKTraitSet w on t.CKTraitId = w.CKTraitId
- inner join CK.tCKTraitWord wo on w.CKTraitWordId = wo.CKTraitWordId
- where kzz.DockerExecutionContextId = d.DockerExecutionContextId) b)
- >=
- (select count(*) from (select tre.UnitTestId,
- tre.RequirementId,
- wo.CKTraitWordId
- from ITest.tUnitTest tre
- INNER JOIN CK.tCKTrait t ON tre.RequirementId = t.CKTraitId
- INNER JOIN CK.tCKTraitSet w on t.CKTraitId = w.CKTraitId
- inner join CK.tCKTraitWord wo on w.CKTraitWordId = wo.CKTraitWordId where tre.UnitTestId = u.UnitTestId) poul)) powa group by powa.UnitTestId;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement