Hi, Sorry I can't reproduce the problem. My test case is:
drop table test; create table test(username varchar, city varchar); create index test_user on test(username); create index test_city on test(city); insert into test select x || ' user', (x / 20) || ' city' from system_range(1, 500000); select * from test where username = '134 user'; select * from test where city = '134 city'; Could you change the test case so it better matches what you do? Regards, Thomas On Thu, Dec 3, 2009 at 10:49 AM, Cheenu <[email protected]> wrote: > Temporary file test.123.temp.db is being created, but I can't > understand why - there are no more that 20 username in 1 city. > > -- > > 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. > > > -- 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.
