Operand data type bit is invalid for max operator
mariojsnunes opened this issue · 5 comments
mariojsnunes commented
Getting "Operand data type bit is invalid for max operator" error when using this on a query:
x.With<BooleanFieldIndex>(field => field.ContentField == nameof(BaseContentPart.Property)).OrderByDescending(x => x.Boolean)
Started working again after I commented it.
Is there any change in the past 2-3 months could cause this? I updated OC to the latest preview today.
sebastienros commented
Yes, we are using GROUP BY now to eliminate duplicate documents. I will add a similar unit test.
mariojsnunes commented
Hi there. Is there any plans to support ordering boolean fields again?
sebastienros commented
Can you give it a try and attempt to fix it?
mariojsnunes commented
@sebastienros Sure. I've made a PR #503 to try to replicate the issue. Can you allow for tests to run?
jtkech commented
Done