title: Hibernate HQL Query Null Columns
body: <p>I have a simple HQL SELECT query. When the columns are not null, I'm able to retrieve the records. But if one of the columns are null, I don't get that record that has a null column.</p>
  
  <p>Here's a sample HQL query:</p>
  
  <pre><code>SELECT p.name as name, p.price as price
  FROM  Pets p
  </code></pre>
  
  <p>If name or price is null, I don't get any entry for that particular record. I thought Hibernate will just return a null value for that column when it's null? </p>
  
  <p>How can I provide an alternate value when the column is null?</p>
  
  <p>I have tested this with Hibernate Console.</p>