Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

nebula 2.6 ttl int type does not work #3923

Closed
QingZ11 opened this issue Feb 22, 2022 · 2 comments
Closed

nebula 2.6 ttl int type does not work #3923

QingZ11 opened this issue Feb 22, 2022 · 2 comments
Assignees
Labels
community Source: who proposed the issue type/bug Type: something is unexpected
Milestone

Comments

@QingZ11
Copy link
Contributor

QingZ11 commented Feb 22, 2022

Describe the bug

The int type field sets the ttl attribute, and it can still be queried after expiration.

Expired data match cannot be queried, but fetch can still be queried.

How to query the setting of ttl, the desc tag cannot be viewed.

Your Environments (required)

nebula version: 2.6.1

ref: https://discuss.nebula-graph.com.cn/t/topic/7268

@QingZ11 QingZ11 added the type/bug Type: something is unexpected label Feb 22, 2022
@QingZ11 QingZ11 assigned QingZ11 and panda-sheep and unassigned QingZ11 Feb 22, 2022
@Sophie-Xie Sophie-Xie added this to the v3.1.0 milestone Feb 22, 2022
@panda-sheep
Copy link
Contributor

panda-sheep commented Mar 28, 2022

Use the latest code and test as follows, no problem.
The case is as follows:

case one: without ttl,data exists

create tag player1(age int);
show create tag player1;
create tag index player1_index on player1(age);

insert vertex player1(age) values "11":(1); 
insert vertex player1(age) values "22":(2); 
insert vertex player1(age) values "33":(3); 
insert vertex player1(age) values "44":(4); 

rebuild tag index player1_index
FETCH PROP ON player1 "11" yield player1.age;
MATCH (v:player1) return v;
MATCH (v:player1) where v.player1.age == 1 return v;

case two: use ttl, data not exists

create tag player(age int) ttl_duration= 100, ttl_col = "age";
create tag index player_index on player(age);
show create tag player;

insert vertex player(age) values "11":(1); 
insert vertex player(age) values "22":(2); 
insert vertex player(age) values "33":(3); 
insert vertex player(age) values "44":(4); 

rebuild tag index player_index
FETCH PROP ON player "11" yield player.age;

image

@minxinqing
Copy link

Use the latest code and test as follows, no problem. The case is as follows:

case one: without ttl,data exists

create tag player1(age int);
show create tag player1;
create tag index player1_index on player1(age);

insert vertex player1(age) values "11":(1); 
insert vertex player1(age) values "22":(2); 
insert vertex player1(age) values "33":(3); 
insert vertex player1(age) values "44":(4); 

rebuild tag index player1_index
FETCH PROP ON player1 "11" yield player1.age;
MATCH (v:player1) return v;
MATCH (v:player1) where v.player1.age == 1 return v;

case two: use ttl, data not exists

create tag player(age int) ttl_duration= 100, ttl_col = "age";
create tag index player_index on player(age);
show create tag player;

insert vertex player(age) values "11":(1); 
insert vertex player(age) values "22":(2); 
insert vertex player(age) values "33":(3); 
insert vertex player(age) values "44":(4); 

rebuild tag index player_index
FETCH PROP ON player "11" yield player.age;

image

问题依然存在呀。看截图时间,我把过期时间设置为了10秒,插入数据后,10秒后再查依然能查到,跟你的截图中区别在于,属性值是当前时间。
我对ttl的理解有误?
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community Source: who proposed the issue type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

4 participants