title: Create sequence in h2 database
body: <p>I want to create a sequence in h2 database for the below entity</p>
  
  <pre><code>public class Label {
  
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "label_sequence")
    @SequenceGenerator(name = "label_sequence", sequenceName = "label_sequence", allocationSize = 100)
    private Long id;
  
    private String name;
  
    private String value;
  }
  </code></pre>
  
  <p>Below is the sql command I am executing</p>
  
  <pre><code>CREATE SEQUENCE label_sequence
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1;
  </code></pre>
  
  <p>I am getting the following error:</p>
  
  <pre><code>Syntax error in SQL statement "CREATE SEQUENCE LABEL_SEQUENCE
    START WITH 1
    INCREMENT BY 1
    MINVALUE[*] 1 "; SQL statement:
  CREATE SEQUENCE label_sequence
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1 [42000-140]
  </code></pre>
  
  <p>The below query works</p>
  
  <pre><code>CREATE SEQUENCE label_sequence
    START WITH 1
    INCREMENT BY 1;
  </code></pre>
  
  <p>But I am getting ID values less than 1 because of the allocation size I guess.</p>
  
  <p>How can I make sure the ID values never go below 1?</p>