Error on execution 'select from' view with 'GROUP BY LEFT('2018-08-24', 100) '

CREATE OR REPLACE VIEW v1 AS SELECT DISTINCT BIT_OR(100) OVER () FROM DUAL 

GROUP BY LEFT('2018-08-24', 100)  order by 1+2;

SELECT * FROM v1;

DROP VIEW v1;

mysqltest: At line 3: query 'SELECT * FROM v1' failed: 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 'group by left('2018-08-24',100) order by 1 + 2' at line 1