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