DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(a DECIMAL(0,0));
ALTER TABLE t1 ADD b INT,ADD c TIME(6);
ALTER TABLE t1 MODIFY a DATETIME(5);
INSERT INTO t1 SET a=0;
SET sql_mode='NO_ZERO_DATE';
SELECT(SELECT t1.a)aa,COUNT(DISTINCT b) FROM t1 GROUP BY aa+0;
This is an upstream bug : http:// bugs.mysql. com/bug. php?id= 74619
****** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test; 'NO_ZERO_ DATE'; COUNT(DISTINCT b) FROM t1 GROUP BY aa+0;
CREATE TABLE t1(a DECIMAL(0,0));
ALTER TABLE t1 ADD b INT,ADD c TIME(6);
ALTER TABLE t1 MODIFY a DATETIME(5);
INSERT INTO t1 SET a=0;
SET sql_mode=
SELECT(SELECT t1.a)aa,