Oracle 11.2.0.1 Sequence bug

11.2.0.1 sequence bug,在插入语句的时候不是从最小值开始，从第2个值开始。下面以1测试



Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as dingjun123

SQL> 
SQL> DROP SEQUENCE seq;

Sequence dropped
SQL> CREATE SEQUENCE seq
  2  START WITH 1
  3  INCREMENT BY 1;

Sequence created
SQL> DROP TABLE t;

Table dropped
SQL> CREATE TABLE t(ID NUMBER);

Table created

--直接访问没有问题

SQL> SELECT seq.NEXTVAL FROM dual;

   NEXTVAL
----------
         1

SQL> 
SQL> DROP SEQUENCE seq;

Sequence dropped
SQL> CREATE SEQUENCE seq
  2  START WITH 1
  3  INCREMENT BY 1;

Sequence created

--靠，插入的时候从第2个开始了，是BUG吗？我想应该是BUG
SQL> INSERT INTO t  VALUES(seq.NEXTVAL);

1 row inserted

SQL> select id from t;

        ID
----------
         2