[bug]: data not found with not in filter(if tag value not exist)

[kevin6025]

[bug]: data not found with not in filter(if tag value not exist)

[joyant]

lindb/query/operator/series_filtering.go

Line 73 in 2d5b7ec

if err != nil {

The series filtering operator in Lindb considers it an error when a tag value does not exist. In such cases, SeriesIDsAfterFiltering is empty, resulting in an empty query result.

This may seem a bit illogical, as in the case of a nonexistent specified tag value, it might be better to query for all tag values. However, another perspective could be that the person writing the query should be aware of the tag values associated with the metric, and entering incorrect tag values is not desirable.

If @stone1100 believe this is a bug, I can fix it.

[stone1100]

Maybe the root cause is not cache tag filter results in query context when tag value not found doing tag filter.
https://github.com/lindb/lindb/blob/main/query/operator/tag_values_lookup.go#L73-L79

After that will get error when do series filter.

lindb/query/operator/series_filtering.go

Line 109 in 2d5b7ec

return 0, nil, fmt.Errorf("%w, expr: %s", constants.ErrTagValueFilterResultNotFound, expr.Rewrite())

I think cache an empty tag filter result can fix this bug. (https://github.com/lindb/lindb/blob/main/query/operator/tag_values_lookup.go#L73-L79)

The not expression filter logic as below:

1. tag value filter and get tag value ids A => node in('local')
2. series ids filter based on tag value ids <- go error
3. get all series ids by tag key(node)
4. do Bitmap NotAnd operator

@joyant