Re: [Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

[Nitin Uchil]

Thanks Fred:

 

WIll inform the posts that I have found.

 

What is the SEQUENCE_CATALOG field? When I added a sequence using:

 

CREATE SEQUENCE utility_content_SEQ

AS INTEGER

START WITH 1

INCREMENT BY 1;

 

I get null as the SEQUENCE_CATALOG.

 

 

On 4/20/06, fredt <[EMAIL PROTECTED]> wrote:

I'm not aware of the groups where such questions have been raised. If you know, please let them know.

 

Fred

----- Original Message -----

From: Nitin Uchil

To: hsqldb-developers@lists.sourceforge.net

Sent: 20 April 2006 14:02

Subject: Re: [Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

 

Thanks Fred - it works.

 

But in several use groups this question about SEQUENCES not working has popped up perhaps because they do not know that INFORMATION_SCHEMA needs to be prepended.

 

Best Regards.

 

Nitin

 

On 4/20/06, fredt <[EMAIL PROTECTED] > wrote:

You need to use:

 

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES

 

Please read the docs on SCHEMA and SEQUENCE support. Also note that you do not use the above query in order to access the sequences. The _expression_ used is "NEXT VALUE FOR a_sequence"

 

Fred

----- Original Message -----

From: Nitin Uchil

To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]

Sent: 20 April 2006 12:32

Subject: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

 

Hi Fred:

 

Looks like sequnces still do not work in version 1.8.0.4. I tried:

 

SELECT * FROM SYSTEM_SEQUENCES

 

and it gives a table not found error. We are migrating our databases from Oracle and mySQL and this is one thing that is holding us back.


Nitin Uchil
 

--
Nitin Uchil
(734)945-6463

--
Nitin Uchil
(734)945-6463