# Abnormal behavior on expectation expect\_column\_pair\_values\_a\_to\_be\_greater\_than\_b

**URL:** <https://discourse.greatexpectations.io/t/abnormal-behavior-on-expectation-expect-column-pair-values-a-to-be-greater-than-b/2120>\
**Category:** GX Core Support\
**Tags:** help-wanted\
**Created:** [March 6, 2025, 6:24pm UTC](https://discourse.greatexpectations.io/t/abnormal-behavior-on-expectation-expect-column-pair-values-a-to-be-greater-than-b/2120 "2025-03-06T18:24:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jose.correia](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/jose.correia/32/251_2.png) [@jose.correia](https://discourse.greatexpectations.io/u/jose.correia)\
**Post date:** [March 6, 2025, 6:24pm UTC](https://discourse.greatexpectations.io/t/abnormal-behavior-on-expectation-expect-column-pair-values-a-to-be-greater-than-b/2120/1 "2025-03-06T18:24:59Z")

</div>

Hi all,

I have been observing an abnormal bahavior on this expectation on the GX 0.18.8 on Spark, Databricks.  
Basically what is happening is that it is processing around 1.6Million rows and failing only 11 records in most cases, however, it is providing the unexpected\_count = 0 and unexpected\_index\_list = .  
Other times, it is still providing unexpected\_count = 0, but unexpected\_index\_list comes filled with values.  
Moreover, it is marking the status of the expectation as success, sample below.

 ![image](https://canada1.discourse-cdn.com/flex031/uploads/greatexpectations/original/1X/299860f59ee0cc3fb3e456a73baca938bbc5214a.png)  
Do you have any idea on what might be happening? Can it be due to very low number of failures compared to the input data and some approximations are happening?  
It is also crazy that this expectation is working properly on other use cases, so any tip would be appreciated.  
Note: I am not providing the mostly parameter, so it should fail even if a single record is failing, as the default is 100%.

Thanks in advance.

Best Regards,  
José Correia

---

<div class="post-metadata">

**Author:** ![adeola](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@adeola](https://discourse.greatexpectations.io/u/adeola)\
**Post date:** [March 31, 2025, 6:44pm UTC](https://discourse.greatexpectations.io/t/abnormal-behavior-on-expectation-expect-column-pair-values-a-to-be-greater-than-b/2120/2 "2025-03-31T18:44:19Z")

</div>

unfortunately we no longer offer support for version 0.18.8 but we’d be happy to take a look if this behavior is still present in latest versions. I’d recommend upgrading at your earliest convenience and if this is still an issue in that case, please let us know