title: Oracle Sequence starting with 2 instead of 1
body: <p><strong>Unexpected behavior:</strong></p>
  
  <p>I am encountering strange behavior of Oracle sequences with 11g (works with 10g):</p>
  
  <pre><code>CREATE SEQUENCE test_sequence START WITH 1;
  CREATE TABLE test_table ( val INT );
  
  INSERT INTO test_table VALUES ( test_sequence.NEXTVAL );
  </code></pre>
  
  <p></p>
  
  <p>Even though the sequence starts with <strong>1</strong>, the first value inserted is <strong>2</strong>:</p>
  
  <pre><code>SELECT * FROM test_table;
  
         VAL
  ----------
           2
  </code></pre>
  
  <hr>
  
  <p><strong>Expected behavior:</strong></p>
  
  <p>Selecting <code>NEXTVAL</code> without the insert works as expected:</p>
  
  <pre><code>CREATE SEQUENCE test_sequence_2 START WITH 1;
  
  SELECT test_sequence_2.NEXTVAL FROM dual
  
     NEXTVAL
  ----------
           1
  </code></pre>
  
  <hr>
  
  <p><strong>Question:</strong></p>
  
  <p>Can anyone reproduce this using Oracle 11g? Is this a known issue?</p>
  
  <p>I'm using<br>
  <code>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production</code>.</p>