You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello, I am using the 1.2.0 release and am trying to run a query that is searching for a document that references a number of other documents. When I run the query using "containsAll" I get 0 items found. However if I do a query using "in" for each separate rid I get the expected result of 1 items found. Am I misusing the "containsAll" function in my queries or should it in fact be returning the result I am expecting?
Here is the query using "in" that works and it's results:
select from Parent where Child in [#11:1] and Child in [#11:0]
This is the query using "containsAll" that doesn't work
select from Parent where Child containsAll [#11:1, #11:0]
0 item(s) found.
The parent I am querying for only has two children and they are #11:0 and #11:1 which is why I was expecting "containsAll" to return a record. If it would help I can attach an export of the database I have since its some very small test data.
The text was updated successfully, but these errors were encountered:
Hello, I am using the 1.2.0 release and am trying to run a query that is searching for a document that references a number of other documents. When I run the query using "containsAll" I get 0 items found. However if I do a query using "in" for each separate rid I get the expected result of 1 items found. Am I misusing the "containsAll" function in my queries or should it in fact be returning the result I am expecting?
Here is the query using "in" that works and it's results:
select from Parent where Child in [#11:1] and Child in [#11:0]
---+---------+
#| RID |
---+---------+
0| #8:0|
---+---------+
1 item(s) found.
This is the query using "containsAll" that doesn't work
select from Parent where Child containsAll [#11:1, #11:0]
0 item(s) found.
The parent I am querying for only has two children and they are #11:0 and #11:1 which is why I was expecting "containsAll" to return a record. If it would help I can attach an export of the database I have since its some very small test data.
The text was updated successfully, but these errors were encountered: