Hi, The workaround is to sort twice on the same row. My test case is:
create table test(id int primary key) as select x from system_range(1, 200); delete from test; insert into test(id) values(1); select * from test order by id; -- fails select * from test order by id, id; -- works drop table test; Regards, Thomas On Tue, Apr 7, 2009 at 6:27 PM, Mike Goodwin <[email protected]> wrote: > Actually I have a question. Is there a workaround? For example, would using > 'where true' as a condition prevent the problem from occurring? > > thanks, > > mike > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
