[Hsqldb-developers] Issue with SEQUENCE

[Nitin Uchil]

I have recently started using SEQUENCES in HSQLDB (version 1.8.0.4)

 

CREATE SEQUENCE login_password_SEQ
AS INTEGER
START WITH 1
INCREMENT BY 1;

 

When I issue:

SELECT NEXT VALUE FOR login_password_SEQ FROM  INFORMATION_SCHEMA.SYSTEM_SEQUENCES

 

It produces 46 values! The first time it creates 1 thru 46, the second 47 thru 92......

 

This is true for any other SEQUENCE also.

 

What am I doing wrong?

--
Nitin Uchil