Skip to content

NOTEQUAL filter selectivity is incorrect when source NDV is 1 #26685

@aaneja

Description

@aaneja

Setup

  1. Source variable with null_fraction as 0, and NDV count as 1
  2. Input plan node has 100 rows
  3. A filter like name <> 'foo'

Expected behavior

Filter selectivity is non-zero

Observed behavior

Filter selectivity is 0, the planner assumes no rows will be selected
See aaneja@31732a8 for a repro test case

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    Status

    🆕 Unprioritized

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions