Skip to content

ESQL: INLINE STATS null grouping/joining #139887

@bpintea

Description

@bpintea

Description

There's a difference between how STATS behaves compared to INLINE STATS caused by null grouping/joining that we should look into:

ROW x = 1
| STATS c = COUNT(*) BY n = null
| KEEP c, n
| LIMIT 1

yields:

       c       |       n       
---------------+---------------
1              |null           

However,

ROW x = 1
| INLINE STATS c = COUNT(*) BY n = null
| KEEP c, n
| LIMIT 1

yields:

       c       |       n       
---------------+---------------
null           |null           

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions