# Data\_intersection sorted input error

**URL:** <https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894>\
**Category:** CloverDX Platform\
**Created:** [July 19, 2011, 12:00am UTC](https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894 "2011-07-19T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dnrickner](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@dnrickner](https://forum.cloverdx.com/u/dnrickner)\
**Post date:** [July 19, 2011, 12:00am UTC](https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894/1 "2011-07-19T00:00:00Z")

</div>

I am receiving an error that says:

Data input B is not sorted in ascending order.

This seems to happen when we have either a null or empty string in the field we are specifying as a join key, and we are sorting by this join key. We need this to work with an empty string coming through. Is this a bug?

attached is my graph that demonstrates this. We are running on SQL Server 2008.

- [testdata\_intersection.grf](https://cdn.cloverdx.com/forum/11640%5F4705d15e2671a5981336265321c23902/testdata%5Fintersection.grf)

---

<div class="post-metadata">

**Author:** ![dnrickner](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@dnrickner](https://forum.cloverdx.com/u/dnrickner)\
**Post date:** [July 20, 2011, 12:38pm UTC](https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894/2 "2011-07-20T12:38:54Z")

</div>

I forgot to mention that I am using Clover 3.1 commercial version.

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [July 20, 2011, 2:17pm UTC](https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894/3 "2011-07-20T14:17:42Z")

</div>

Hello,  
unfortunately it’s really bug.  
As a workaround, please add a Partitioner before the DataIntersection - it will send the records with null key to “flow B” directly, as you don’t want to regard null as equals values.

- [testdata\_intersection.grf](https://cdn.cloverdx.com/forum/417%5Fd96397baeaa6c6e78e1684c1a31390ea/testdata%5Fintersection.grf)

---

<div class="post-metadata">

**Author:** ![dnrickner](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@dnrickner](https://forum.cloverdx.com/u/dnrickner)\
**Post date:** [July 20, 2011, 3:12pm UTC](https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894/4 "2011-07-20T15:12:25Z")

</div>

Since it’s a bug, could you post the bug tracking link?

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [July 21, 2011, 6:25am UTC](https://forum.cloverdx.com/t/data-intersection-sorted-input-error/894/5 "2011-07-21T06:25:55Z")

</div>

Ii is logged [here](https://bug.javlin.eu/browse/CL-1856). Please use guest/guest credentials for browsing.
