Statements with IN(..) conditions could produce the wrong result when using views or nested select statements.