select nullif(count(col1),0) gives wrong result if in a view

Description

This is related to and MDEV-9576.

returns 3

creating a view with the same query and it returns 5.
to recreate ->

then

Environment

openbsd, windows

Status

Assignee

Sergei Golubchik

Reporter

MartinL

Labels

None

External issue ID

None

External issue ID

None

Components

Fix versions

Affects versions

Priority

Critical
Configure