Feature: Add a way to create ranges from parameters.

[finalclass]

Describe the bug

I want to use range query with variables but there is no way to do that.

Steps to reproduce

dg/test> create item:ulid() set index = 12
[
    {
        id: item:01HGE6SKP0YM6X1PT0QTSKW6PD,
        index: 12
    }
]

dg/test> create item:ulid() set index = 22;
[
    {
        id: item:01HGE6SPXM4Y7007SP7XX1Q0CK,
        index: 22
    }
]

dg/test> select * from item:01HGE6SKP0YM6X1PT0QTSKW6PD..;
[
    {
        id: item:01HGE6SKP0YM6X1PT0QTSKW6PD,
        index: 12
    },
    {
        id: item:01HGE6SPXM4Y7007SP7XX1Q0CK,
        index: 22
    }
]

dg/test> let $seq="01HGE6SKP0YM6X1PT0QTSKW6PD";
[]
dg/test> select * from item:$seq; --< Parse error: Failed to parse query at line 1 column 19 expected one of WITH, WHERE, SPLIT, GROUP, ORDER, LIMIT, START, FETCH, VERSION, TIMEOUT, PARELLEL, or EXPLAIN
  |
1 | select * from item:$seq;

dg/test> select * from type::thing("item", $seq)..; --< Parse error: Failed to parse query at line 1 column 41 expected an identifier
  |
1 | select * from type::thing("item", $seq)..;
  |

Expected behaviour

select * from type::thing("item", $seq)..; does not produce a parse error

SurrealDB version

1.2.1

Contact Details

s@finalclass.net

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

[DelSkayn]

This is indeed invalid syntax. There doesn't seem to be, currently, a way to create ranges from params. I agree that this would probably worth while to add but I am not sure if select * from type::thing("item", $seq)..; would be the right syntax for this feature. I think implementing type::range would be a better way to support this requirement.

[finalclass]

Nice! Thanks