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.

Comments

sumanchalki created an issue. See original summary.

suman.abc’s picture

Issue summary: View changes
suman.abc’s picture

Issue summary: View changes
suman.abc’s picture

Issue summary: View changes
suman.abc’s picture

Patch attached.

suman.abc’s picture

Status: Active » Needs review
suman.abc’s picture