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

"where" statement in nql doesn't work well #6019

Open
rendawudi opened this issue Mar 26, 2025 · 0 comments
Open

"where" statement in nql doesn't work well #6019

rendawudi opened this issue Mar 26, 2025 · 0 comments
Labels
affects/none PR/issue: this bug affects none version. severity/none Severity of bug type/bug Type: something is unexpected

Comments

@rendawudi
Copy link

version: 3.6

nql:

MATCH (v:huadi) where (timestamp() - timestamp(v.huadi.filing_time_44)) < 365 return id(v) as bk_inst_id, timestamp() as d1,timestamp(v.huadi.filing_time_44) as d2, (timestamp() - timestamp(v.huadi.filing_time_44)) < 365 as result

output:

bk_inst_id | d1 | d2 | result -- | -- | -- | -- huadi_0100003 | 1742896011 | 1701619200 | false huadi_0100004 | 1742896011 | 1733966587 | false huadi_0100005 | 1742896011 | 1734491580 | false huadi_0100006 | 1742896011 | 1733797787 | false huadi_0100007 | 1742896011 | 1733712065 | false huadi_0100008 | 1742896011 | 1734479795 | false huadi_0100009 | 1742896011 | 1734404673 | false

while where statement returning false, the final result ignores where statement's result and returns all matched data

@rendawudi rendawudi added the type/bug Type: something is unexpected label Mar 26, 2025
@github-actions github-actions bot added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Mar 26, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/none PR/issue: this bug affects none version. severity/none Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

1 participant