Comment 3 for bug 1384658

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

This is an upstream bug : http://bugs.mysql.com/bug.php?id=74619

****** Testcase

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;