title: Azure CosmosDB IS_DEFINED vs NOT IS_DEFINED
body: <p>I was trying to query a collection, which had few documents. Some of the collections had "Exception" property, where some don't have.<br>
  My end query looks some thing like:  </p>
  
  <pre><code>Records that do not contain Exception: 
  
  **select COUNT(1) from doc c WHERE NOT IS_DEFINED(c.Exception)**  
  
  
  Records that contain Exception: 
  
  **select COUNT(1) from doc c WHERE IS_DEFINED(c.Exception)**
  </code></pre>
  
  <p>But this seems not be working. When NOT IS_DEFINED is returning some count, IS_DEFINED is returning 0 records, where it actually had data.</p>
  
  <p>My data looks something like (some documents can contain Exception property &amp; others don't):</p>
  
  <pre><code>[{
    'Name': 'Sagar',
    'Age': 26,
    'Exception: 'Object reference not set to an instance of the object', ...
  },
  {
    'Name': 'Sagar',
    'Age': 26, ...
  }]
  </code></pre>