TestLink

Environment:

• MySql 5.1.41
• Apache 2.2.14 (Win32)
• PHP 5.3.1
• TestLink 1.9 RC 1

The calculation "Not Run" in General Test Plan Metrics does not work or very slow if a user assigned to cases:

Steps To Reproduce

• Create a test suite
• Create 6 test cases
• Create a test plan
• Add test cases to test plan
• Create a build
• Do not assign user to a test case
• Execute two cases as "Passed"
• Goto General Test Plan Metrics

The sql command to calculate "Not Run" will result 0:
SELECT COUNT(UA.id) FROM testlink_1_9_rc1_mod.user_assignments UA
LEFT OUTER JOIN testlink_1_9_rc1_mod.testplan_tcversions TPTCV ON UA.feature_id = TPTCV.id
LEFT OUTER JOIN testlink_1_9_rc1_mod.executions E ON TPTCV.tcversion_id = E.tcversion_id AND UA.build_id = E.build_id AND TPTCV.platform_id = E.platform_id
WHERE UA.build_id = 1 AND E.status IS NULL AND UA.type = 1

I think the select must be only over testplan_tcversions and executions.

Excuse my bad English!