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)