Hi all, Did anything ever come of this? I would be super keen to use H2 if it only did correct binary sorting!
Thanks Matt On Monday, December 10, 2012 1:14:01 PM UTC, Matthew Painter wrote: > > Hi all, > > Just wanted to check that this is a bug: > > create table bin( x binary(1) ); > insert into bin(x) values (x'09'),(x'0a'),(x'99'),(x'aa'); > select * from bin order by x; > > X > <http://localhost:8082/query.do?jsessionid=6f1c7d9767ef118f4a6200a29c62d7ab#> > 99aa090a(4 rows, 0 ms) > > The sorting should of course be: > > X > <http://localhost:8082/query.do?jsessionid=6f1c7d9767ef118f4a6200a29c62d7ab#> > 090a99aa(4 rows, 0 ms) > > Am I right in thinking this is a bug? Or is there an obscure setting to > correct his? > > > Thanks :) > > > Matt -- 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, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
