Sorry, I hit send too soon. The result is: banana a yellow
(with a tab character in between "banana", "a", and "yellow". - Doug On Sun, Dec 22, 2013 at 10:57 AM, Doug Judd <[email protected]> wrote: > Consider the following HQL: > > create table issue1175 (a); > insert into issue1175 values ("banana", "a", "yellow"),("cherry", "a", > "red"); > compact table issue1175; > pause 45; > select * from issue1175 where 'apple' < ROW <= 'cherry' limit 1; > > Just two rows are inserted into the database ("banana" and "cherry"). The > query is a row range query over the key space ("apple".."cherry"] with a > LIMIT 1. Since the key "apple" is not in the database, the first row that > is encountered in the range should be returned (i.e. "banana"). In fact, > the above HQL is now part of our regression testing. If you run the above > query on Hypertable version 0.9.7.13 it returns no results, if you run it > on Hypertable 0.9.7.14 (which includes the fix) will will get the following > correct result: > > bananaa yellow > > > > > > On Sun, Dec 22, 2013 at 4:59 AM, David <[email protected]> wrote: > >> Hi Doug, >> "I believe the condition was that the first row in the ROW range query >> does not exist in the database *and* the data to be returned existed in >> a CellStore (not the CellCache)." >> I don' t understand this word, what is the difference between "the first >> row" and "the data to be returned"? if i query limit 1, i think that both >> are same. Why did you say that the first row exist in a CellStore instead >> of database? is not the CellStore part of the database? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Hypertable Development" 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/hypertable-dev. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > Doug Judd > CEO, Hypertable Inc. > -- Doug Judd CEO, Hypertable Inc. -- You received this message because you are subscribed to the Google Groups "Hypertable Development" 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/hypertable-dev. For more options, visit https://groups.google.com/groups/opt_out.
