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
I have a table with composite partitioning using (ColumnA <string>, ColumnB <string>).
I have 4 rows, which match to a single value of ColumnA and ColumnB, let's say "day3" and "device" respectively.
I create the following query:
qb.In("ColumnA"),
qb.Eq("ColumnB")
and I bind the parameters as such: .Bind(days, device) where days is a list of strings and device is a single string.
I paginate by calling .PageState(pageState).PageSize(pageSize), where pageState is a base64 decoded string and pageSize is an int.
Let's suppose the values bound for days are ["day1", "day2", "day3", "day4"] and the value for device is simply "device".
pageState is nil and pageSize is 100.
My expectation is that a single page is returned with the 4 rows. The returned pageState is nil since there are no more pages.
What actually happens is that 4 different pages are created. Pages 1, 2 and 4 are empty, while page 3 contains the 4 rows. If I change the number of elements in the array bound to the In clause, the number of pages changes proportionally, one per element in the array. The only populated page (following this example) is that corresponding to the element in the array for which values are matched.
Is this the expected behavior?
The text was updated successfully, but these errors were encountered:
Cassandra version: 3.11.0
gocqlx version: v2.8.0
I have a table with composite partitioning using
(ColumnA <string>, ColumnB <string>)
.I have 4 rows, which match to a single value of ColumnA and ColumnB, let's say "day3" and "device" respectively.
I create the following query:
and I bind the parameters as such:
.Bind(days, device)
where days is a list of strings and device is a single string.I paginate by calling
.PageState(pageState).PageSize(pageSize)
, where pageState is a base64 decoded string and pageSize is an int.Let's suppose the values bound for days are
["day1", "day2", "day3", "day4"]
and the value for device is simply"device"
.pageState is nil and pageSize is 100.
My expectation is that a single page is returned with the 4 rows. The returned pageState is nil since there are no more pages.
What actually happens is that 4 different pages are created. Pages 1, 2 and 4 are empty, while page 3 contains the 4 rows. If I change the number of elements in the array bound to the
In
clause, the number of pages changes proportionally, one per element in the array. The only populated page (following this example) is that corresponding to the element in the array for which values are matched.Is this the expected behavior?
The text was updated successfully, but these errors were encountered: