SQL error when apply distinct from query settings

SQL error is generating if we use distinct from views query settings with views version 3.x. If we use pure distinct then there is no error. In the SELECT statement following is getting added at the end of field list and before the FROM clause - linkchecker_link. AS linkchecker_link_, which is causing the error.