[ 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)