A valid SQL query is
select nullif(count(distinct col1),0) from table1 ;
|
now if I create this as a view with
create view counts4 AS select nullif(count(distinct col1),0) from table1 ;
|
and try to look at the view I get an error
select * from counts4;
|
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<cache>(count(distinct `testdb5`.`table1`.`col1`)),0) AS `nullif(count(distinct ' at line 1 */
|
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
CREATE DATABASE IF NOT EXISTS `testdb5`
|
USE `testdb5`;
|
|
|
CREATE TABLE IF NOT EXISTS `table1` (
|
`col1` varchar(50) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
Thanks!