Bug: $parent doesn't work in if statement in subquery

[agufagit]

Describe the bug

$parent doesn't work in if statement in subquery

Steps to reproduce

nothing returns

select 1 from [{id: 1}] WHERE (SELECT true FROM 1 WHERE (IF 1=1 then $parent.id=1 else false end)) 

Expected behaviour

returns

[
    {
        "1": 1
    }
]

SurrealDB version

surreal 1.4.0

Contact Details

No response

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct

[phughk]

Hey @agufagit , this is because your subquery IF 1=1 then $parent.id=1 else false end is evaluating the expression $parent.id=1 instead of returning it. So the outter expression SELECT true FROM 1 WHERE ... will result in SELECT true FROM 1 WHERE true which won't return anything. I think - could be wrong.
Please let us know if that solves the issue.

[agufagit]

let me rewrite this query

select 1 from [{id: 1}] WHERE array::len(SELECT true FROM 1 WHERE (IF 1=1 then $parent.id=1 else false end)) > 0

SELECT true FROM 1 where true does return

[
    {
        "true": true
    }
]