[Hsqldb-developers] Re: Issue with SEQUENCE

[fredt]

SYSTEM_SEQUENCES should not be used for getting sequence values. Use your own tables. For example   SELECT NEXT VALUE FOR login_password_SEQ FROM  my_table;   Sequences are designed mainly for inserting new rows, or for updating existing rows, e.g.   INSERT INTO my_table (a, b, c) VALUES (NEXT VALUE FOR login_password_seq, 10, 'a string');   Fred ----- Original Message ----- From: Nitin Uchil To: hsqldb-developers@lists.sourceforge.net ; [EMAIL PROTECTED] Sent: 21 April 2006 18:31 Subject: Issue with SEQUENCE 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