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

[fredt <fr...@us...>]

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

Fred
  ----- Original Message -----=20
  From: Nitin Uchil=20
  To: hsq...@li...=20
  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

  =20
  On 4/20/06, fredt <fr...@us...> wrote:=20
    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"=20

    Fred
    ----- Original Message -----=20
    From: Nitin Uchil=20
    To: fr...@us... ; =
hsq...@li....=20
    Sent: 20 April 2006 12:32
    Subject: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

    =20
    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
    =20



  --=20
  Nitin Uchil
  (734)945-6463