title: HSQL sequence creation from max id in a cloumn
body: <p>I want to create sequence for max(id) and increment it by 1 in HSQL</p>
  
  <pre><code>CREATE SEQUENCE test1_seq [AS {INTEGER | BIGINT}]
      [START WITH (Select max(id) from test)] [INCREMENT BY 1];
  </code></pre>
  
  <p>but it is not working</p>