Change Log must consistently rely on fixed_in_version

mantis · mantis · commit a602348d395b · 2012-10-13T01:39:07.000+01:00
Change Log used target_version instead of fixed_in_version to manage
issues' parent/child relationships. This caused unexpected behavior when
target version did not match fixed in version.

The SQL which retrieves the changelog issues now relies on
fixed_in_version.

Fixes #14788

Conflicts:

	changelog_page.php
diff --git a/changelog_page.php b/changelog_page.php
@@ -210,7 +210,7 @@ function print_project_header_changelog ( $p_project_name ) {
 			continue;
 		}
 
-		$t_query = "SELECT sbt.*, dbt.target_version AS parent_version, {bug_relationship}.source_bug_id FROM {bug} sbt
+		$t_query = "SELECT sbt.*, dbt.fixed_in_version AS parent_version, {bug_relationship}.source_bug_id FROM {bug} sbt
 				LEFT JOIN {bug_relationship} ON sbt.id={bug_relationship}.destination_bug_id AND {bug_relationship}.relationship_type=2
 				LEFT JOIN {bug} dbt ON dbt.id={bug_relationship}.source_bug_id
 				WHERE sbt.project_id=%d AND sbt.fixed_in_version=%s ORDER BY sbt.status ASC, sbt.last_updated DESC";

Original file line number	Diff line number	Diff line change
`@@ -210,7 +210,7 @@ function print_project_header_changelog ( $p_project_name ) {`
`210`	`210`	`continue;`
`211`	`211`	`}`
`212`	`212`
`213`		`- $t_query = "SELECT sbt.*, dbt.target_version AS parent_version, {bug_relationship}.source_bug_id FROM {bug} sbt`
	`213`	`+ $t_query = "SELECT sbt.*, dbt.fixed_in_version AS parent_version, {bug_relationship}.source_bug_id FROM {bug} sbt`
`214`	`214`	`LEFT JOIN {bug_relationship} ON sbt.id={bug_relationship}.destination_bug_id AND {bug_relationship}.relationship_type=2`
`215`	`215`	`LEFT JOIN {bug} dbt ON dbt.id={bug_relationship}.source_bug_id`
`216`	`216`	`WHERE sbt.project_id=%d AND sbt.fixed_in_version=%s ORDER BY sbt.status ASC, sbt.last_updated DESC";`