title: "correct" way to select next sequence value in HSQLDB 2.0.0-rc8
body: <p>suppose i have a sequence, called TEST_SEQ
  what would be the correct way of selecting its next value ?
  this does not work:</p>
  
  <pre><code>select next value for TEST_SEQ</code></pre>
  
  <p>probably because it expects a "FROM" clause.
  looking at HSQLDialect.getSequenceNextValString() in hibernate i see this:</p>
  
  <pre><code>"select next value for " + sequenceName + " from dual_" + sequenceName</code></pre>
  
  <p>which in my case would result in something like:</p>
  
  <pre><code>select next value for TEST_SEQ from dual_TEST_SEQ</code></pre>
  
  <p>which does not work for 2.0.0-rc8 (i only assume this works in pre-2.0 versions - havent verified)
  I've come across a solution that involves creating a simple table with 1 row called DUAL, in which case this will work (oracle style):</p>
  
  <pre><code>select next value for TEST_SEQ from DUAL</code></pre>
  
  <p>but hsqldb does not come with this table out of the box, and im not sure how i can get hibernate to generate such a table on "first boot".</p>
  
  <p>Im thinking there has to be a way to get the next value for a sequence out of the box and im just missing it.
  any ideas ?</p>