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

[Nitin Uchil]

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