You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Xikui Wang (Jira)" <ji...@apache.org> on 2020/08/30 18:59:00 UTC
[jira] [Updated] (ASTERIXDB-2770) primary key searches on datasets
having primary key meta parts not use index search
[ https://issues.apache.org/jira/browse/ASTERIXDB-2770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xikui Wang updated ASTERIXDB-2770:
----------------------------------
Description:
{code}
drop dataverse KeyVerse if exists;
create dataverse KeyVerse;
use KeyVerse;
create type DocumentType as open{
attr: int64
};
create type KVMetaType as open{
`key`:string,
vbucket:int32,
cas:int64,
expiration:int32,
flags:int32,
revSeq:int64,
seq:int64,
lockTime:int32
};
create dataset KVStore(DocumentType) with meta(KVMetaType) primary key meta().`key`;
select * from KVStore WHERE meta().`key` > 11;
{code}
was:
{code}
drop dataverse KeyVerse if exists;
create dataverse KeyVerse;
use KeyVerse;
create type DocumentType as open{
attr: int64
};
create type KVMetaType as open{
`key`:string,
vbucket:int32,
cas:int64,
expiration:int32,
flags:int32,
revSeq:int64,
seq:int64,
lockTime:int32
};
create dataset KVStore(DocumentType) with meta(KVMetaType) primary key meta().`key`;
select * from KVStore WHERE meta().`key` > 11;
{code}
> primary key searches on datasets having primary key meta parts not use index search
> -----------------------------------------------------------------------------------
>
> Key: ASTERIXDB-2770
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2770
> Project: Apache AsterixDB
> Issue Type: Bug
> Reporter: Xikui Wang
> Priority: Major
>
> {code}
> drop dataverse KeyVerse if exists;
> create dataverse KeyVerse;
> use KeyVerse;
> create type DocumentType as open{
> attr: int64
> };
> create type KVMetaType as open{
> `key`:string,
> vbucket:int32,
> cas:int64,
> expiration:int32,
> flags:int32,
> revSeq:int64,
> seq:int64,
> lockTime:int32
> };
> create dataset KVStore(DocumentType) with meta(KVMetaType) primary key meta().`key`;
> select * from KVStore WHERE meta().`key` > 11;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)