Re: AssertionError while executing SQL

Prasad, This is a bug. It doesn't let you use fields of sub-select results in WHERE conditions. I filed a JIRA ticket for it: IGNITE-9156 Thank you for the report! You can embed the equality condition into the sub-select to avoid this problem.

AssertionError while executing SQL

I am getting Assertion error while executing following SQL. Please check this highlighted part which causing this error. Can someone please advise? Is this a bug or am I doing something wrong? SELECT tmp.assetGroupId, tmp.name, tmp.businessImpact, tmp.userId , tmp.modifiedBy, tmp.creat