Re: [h2] My sequences are not in the correct order

2019-08-20 Thread Evgenij Ryazanov
> > Do you have an option to enable this on h2? > What exactly do you want to enable? You can use GENERATED BY DEFAULT AS IDENTITY (CACHE 1) instead of AUTO_INCREMENT to disable the cache of the sequence. The default cache size is 32. Cached identities may be lost on abnormal termination of the

Re: [h2] My sequences are not in the correct order

2019-08-20 Thread Bruno Santos Silva
Do you have an option to enable this on h2? Em terça-feira, 20 de agosto de 2019 10:07:51 UTC-3, Noel Grandin escreveu: > > Sequences are not specified to be continuous, they can have gaps, and on > some databases they can even be allocated out > of order. > -- You received this message

Re: [h2] My sequences are not in the correct order

2019-08-20 Thread Noel Grandin
Sequences are not specified to be continuous, they can have gaps, and on some databases they can even be allocated out of order. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it,

[h2] My sequences are not in the correct order

2019-08-20 Thread Bruno Santos Silva
Good morning friends, I'm using h2 where I backup and restore my versions and created 2 tables to be compared to the database versions, I'm having the following problem I'm using the sequence in one of the columns and these same sequences work normally until I stop the bank and start again, it

Re: [h2] Re: LINEKED TABLE contains a select query to a row name with slachs

2019-08-20 Thread Evgenij Ryazanov
Could you try to build H2 from its current sources and re-test your code? Sources are here: https://github.com/h2database/h2database Building instructions are here: https://h2database.com/html/build.html#building You need the jar target. -- You received this message because you are subscribed