0011468: can't sort custom field with date type

ID	Project	Category	View Status	Date Submitted	Last Update
0011468	mantisbt	custom fields	public	2010-02-04 03:02	2011-12-23 06:16

Reporter	mein227	Assigned To	atrol
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	duplicate
Product Version	1.2.0rc2

Summary	0011468: can't sort custom field with date type
Description	First I created custom filed named "due date" with date type. And sort custom filed "due date" in view page then database query wrong. Is my setting problem or others ?
Additional Information	APPLICATION ERROR 0000401 Database query failed. Error received from database was 0001052: Column 'due_date' in order clause is ambiguous for the query: SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted, mantis_custom_field_string_table_1.value due_date FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_1 ON mantis_bug_table.id = mantis_custom_field_string_table_1.bug_id AND mantis_custom_field_string_table_1.field_id = 1 WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.status in (?, ?, ?, ?, ?, ?, ?, ?) ) ORDER BY due_date DESC, mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC.
Tags	No tags attached.

mein227 2010-02-04 03:06 reporter ~0024308	I created two custom fields, Fixed Date and Due Date, both are "date" type. The "Due Date" place in the last column in view page. I sort "Fixed Date" workable without any issue. But sort "Due Date" will broken.