We had the same issue some time ago on the older version of H2 See http://groups.google.com/group/h2-database/browse_thread/thread/ee669f2d2bd211b1/565f05257287c514?lnk=gst&q=a701440#565f05257287c514 The only way we could recover was to recreate the index on the latest version of H2 (at the time it was 107). The funny thing was that the same index (exact copy of the index file) worked just fine on the older version of H2...
On Apr 6, 12:04 am, Thomas Mueller <[email protected]> wrote: > Hi, > > Could you send me the content of the table as well, and the index > definitions? Probably the simples way is to run SCRIPT in the H2 > Console and then send the result set. You can send it to the group or > to the support address 'db support at h2database dot com'. Or paste it > tohttp://www.h2database.com/p.htmland then send me the link. > > Regards, > Thomas > > On Mon, Apr 6, 2009 at 3:54 AM, fed <[email protected]> wrote: > > > Hi, > > > i have a strange problem with H2 (Version 1.1.110), i have this > > table: > > > create table dipendenti_stampa( > > id identity not null primary key, > > id_dipendente bigint not null, > > nome longvarchar not null, > > cognome longvarchar not null, > > matricola varchar(10) not null, > > badge varchar(10) not null, > > profilo_orario varchar(100), > > presente tinyint, > > timbratura_presenza varchar(100)); > > > if on this table i do > > "select * from dipendenti_stampa" i get the data back > > > but if i do > > > "select * from dipendenti_stampa order by id" i get NO data from it. > > > It's very strange.. i have to say that i had a similar problem with h2 > > when i tried to use "order by" on another table and on an index field > > (in this case id too is an index field). > > > Another important consideration: i tested that if i have less than 59 > > rows in the table i get this behaviour, with more or equal to 59 all > > works ok and i get the data from the query. > > > Bye thanks for the help. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
