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 to http://www.h2database.com/p.html and then send me the link.
Regards, Thomas On Mon, Apr 6, 2009 at 3:54 AM, fed <fury...@gmail.com> 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 h2-database@googlegroups.com To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
