Feature: Live Query WHERE clause should process Params

[OTheNonE]

Original: Bug: Live Query using WHERE clause with variables does not work.

Describe the bug

Creating a Live Query using WHERE clause with variables does not work. It works to hardcode the statement for the WHERE clause, but if you are using a variable, it does not work.

Steps to reproduce

Create two LIVE queries in Surrealist for comparing. The first:

LIVE SELECT * FROM measurement WHERE location == 'A Location';

The second:

LET $location = 'A Location'
LIVE SELECT * FROM measurement WHERE location == $location;

Create a measurement record:

CREATE measurement CONTENT {
    location: 'A Location'
};

Expected behaviour

The expected behaviour is that both LIVE queries should give live updates on the changes to the table. What happens is that the first LIVE query gives live results, while the second LIVE query with the variable does not give any update.

SurrealDB version

1.4.2 for windows on x86_64

Contact Details

[email protected]

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]

This should be fixed in 1.5.0 . The beta should already be available.

[OTheNonE]

I tried v.1.5.0-beta.1, and it still does not work... Is there any other issue or PR that mentions this error?

[phughk]

I believed it was part of this
#3946
Will have a look some more thanks

[phughk]

I remember more context around this. The problem is that when we evaluate the WHERE part of the clause, instead of just resolving the parameter, the entire expression is resolved instead.
I am going to turn this into a feature, as this is a capability we do not support yet.

[jquesada2016]

I believe this is a breaking change if it's turned into a feature? This is something that used to work and recently stopped working for me.

[jquesada2016]

Perhaps in the meantime, could we get documentation to reference that paramters do not currently work, therefore not to rely on them in live query where clauses?