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.
--
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.
