Open logiclabs opened 6 years ago
Using NOT in AQL queries doesn't seem to work correctly for some operators.
For example, NOT IN linq query: dbq.Where(ev => !AQL.In(ev.Category, new [] {"a","b"}));
dbq.Where(ev => !AQL.In(ev.Category, new [] {"a","b"}));
generates AQL filter: filter not ev.Category in ['a','b']
filter not ev.Category in ['a','b']
This looks OK, but the statement doesn't work correctly, and returns no results.
Alternatives that give correct results are:
filter not(ev.Category in ['a','b'])
filter ev.Category not in ['a','b']
Using NOT in AQL queries doesn't seem to work correctly for some operators.
For example, NOT IN linq query:
dbq.Where(ev => !AQL.In(ev.Category, new [] {"a","b"}));
generates AQL filter:
filter not ev.Category in ['a','b']
This looks OK, but the statement doesn't work correctly, and returns no results.
Alternatives that give correct results are:
filter not(ev.Category in ['a','b'])
filter ev.Category not in ['a','b']