Loïc Veillard

Sweep: Add query tests

1

### Details Context: This repo is an ORM that supports queries for surrealDB and typeDB. The tests are run for both, with the same tests, using the common BQL (Blitz...

### Is your feature request related to a problem? No ### Describe the solution In the same way this works: ``` CREATE A:1 SET users += [C:1,C:2]; UPDATE A:1 SET...

Bug: Return breaks loops and no way to return them

1

### Describe the bug I know RETURN behaviour has changed on purpose but I think there are some cases where the current behaviour is confusing. ### Steps to reproduce Take...

Bug: Scopes are not respected in v2.alpha6

3

### Describe the bug The way the scopes of transactions work has ben changed in 2.x, they no longer respect the outer RETURN clause ### Steps to reproduce This same...

### Is your feature request related to a problem? I wish surrealDB reserved words where not colliding with my own props. I mean things like enforcing property 'id' to be...

Bug: 2.Alpha bug UPSERT not working in EVENT

1

### Describe the bug The UPSERT does not work in EVENTS if the target exists in the same transaction ### Steps to reproduce ``` DEFINE TABLE toy SCHEMAFULL PERMISSIONS FULL;...

### Is your feature request related to a problem? Right now it is not possible to add an event to a field. explains how the onRead works but should not...

### Describe the bug While 1.x just treats property names as NONE, 2.x actually appends them as objects, instead of accessing their content or ignoring them ### Steps to reproduce...

Bug: Can't use record::id(id) inside WHERE

4

### Describe the bug Using filters on optional props might throw errors. ### Steps to reproduce ``` CREATE A:1 SET b=(CREATE ONLY B:1); CREATE A:2 SET b=(CREATE ONLY B:2); CREATE...

Bug: Can't filter by null property on <future> field

2

### Describe the bug `WHERE !propertyName` works but `propertyName = NULL` does not ### Steps to reproduce ```sql DEFINE FIELD test ON TABLE A VALUE {RETURN NULL}; CREATE A:1 SET...