Changeset 85600 in vbox for trunk

Timestamp:

Aug 3, 2020 1:52:32 PM (4 years ago)

Author:

vboxsync

Message:

TestManager: Try correct join in result listing so that we don't get duplicate entries if the valkit build was edited.

File:

• trunk/src/VBox/ValidationKit/testmanager/core/testresults.py (modified) (1 diff)

trunk/src/VBox/ValidationKit/testmanager/core/testresults.py

@@ -1360 +1360 @@
                   '                    ON TestSets.idGenTestBox     = TestBoxesWithStrings.idGenTestBox' \
                   '       LEFT OUTER JOIN Builds AS TestSuiteBits\n' \
-                  '                    ON TestSets.idBuildTestSuite = TestSuiteBits.idBuild\n' \
+                  '                    ON TestSuiteBits.idBuild     =  TestSets.idBuildTestSuite\n' \
+                  '                   AND TestSuiteBits.tsExpire    >  TestSets.tsCreated\n' \
+                  '                   AND TestSuiteBits.tsEffective <= TestSets.tsCreated\n' \
                   '       LEFT OUTER JOIN TestResultFailures\n' \
                   '                    ON     TestSets.idTestSet          = TestResultFailures.idTestSet\n' \