milvus-io/milvus

[Feature]: Support ALL, ANY for Array types

Open

#23,867 opened on May 4, 2023

View on GitHub
 (4 comments) (0 reactions) (2 assignees)Go (4,000 forks)batch import
good first issuekind/feature

Repository metrics

Stars
 (44,298 stars)
PR merge metrics
 (Avg merge 7d) (314 merged PRs in 30d)

Description

Is there an existing issue for this?

  • I have searched the existing issues

Is your feature request related to a problem? Please describe.

SELECT ProductName FROM Products WHERE ProductID = ANY,ALL (LISTType); ALL = equals to any element in ListType != not equal to any element in ListType

larger than the smallest value in list < smaller than the largest value in list

ALL = equals to all elements in ListType != not equal to at least one element in ListType

larger than the largest value in list < smaller than the smalled value in list

Describe the solution you'd like.

No response

Describe an alternate solution.

No response

Anything else? (Additional Context)

No response

Contributor guide

Research direction
Study Milvus's existing array type handling and query execution. Look for how IN operator is implemented for arrays, then design ALL/ANY operators following SQL semantics. Examine the query parser for WHERE clause support.
Tech stack
go
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GoSQLMilvus architecture
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40