syntax error on view with nullif and count

Description

A valid SQL query is

now if I create this as a view with

and try to look at the view I get an error

this exact same procedure works fine on mariadb 10.0.23
and this bug may have something to do with https://lists.launchpad.net/maria-developers/msg09111.html

I can't test it on 10.1.10 since windows wont allow me to downgrade and I cant uninstall.
This (again) affects all kodi users that can't create db's anymore

to recreate db

Thanks!

Environment

windows, openbsd

Assignee

Sergei Golubchik

Reporter

MartinL

Labels

None

Components

Fix versions

Affects versions

Priority

Critical
Configure