title: RavenDB: .In() and .Where() yielding different results
body: <p>I have a field, that's indexed as</p>
  
  
  
  <pre class="lang-cs prettyprint-override"><code>Index(x =&gt; x.Status, FieldIndexing.Default);
  </code></pre>
  
  <p>in a collection with a total of 2566 records.</p>
  
  <p>Now when I query like this:</p>
  
  <pre class="lang-cs prettyprint-override"><code>var query = _ravenSession
      .Query&lt;MyIndex.ReduceResult, MyIndex&gt;()
      .Statistics(out stats);
  
  query = query.Where(x =&gt; x.Status != "inactive" &amp;&amp; x.Status != "invalid" &amp;&amp; x.Status != "sold");
  </code></pre>
  
  <p>I get a total result count of 2512.</p>
  
  <p>But if I query like this:</p>
  
  <pre class="lang-cs prettyprint-override"><code>query = query.Where(x =&gt; !x.Status.In("inactive", "invalid", "sold"));
  </code></pre>
  
  <p>I get a total result count of 2520. How can this count be different?</p>
  
  <p>I can see, that the first query translates to</p>
  
  <blockquote>
    <p>{((((-Status:inactive AND Status:*) AND -Status:invalid))
    AND -Status:sold)}</p>
  </blockquote>
  
  <p>and the second one:</p>
  
  <blockquote>
    <p>{(<em>:</em> AND -@in`&lt;Status&gt;:(inactive , invalid , sold) )}</p>
  </blockquote>