Comment 1 for bug 321684

Revision history for this message
Aarti Pai (aarti-pai) wrote :

The QUARTER() function succeeds in these instances where it should have failed - Invalid dates:
See /home/aarti/repos/temporal-data/tests/suite/temporal/t/quarter.test

#--error 1686
#SELECT QUARTER("0000-01-01");
#--error 1686
#SELECT QUARTER("0001-00-01");
#--error 1686
#SELECT QUARTER("0001-01-00");
#--error 1686
#SELECT QUARTER("2000-02-30");

SELECT QUARTER('07-31-2009');
QUARTER('07-31-2009')
NULL
Warnings:
Warning 1292 Incorrect datetime value: '07-31-2009'

SELECT QUARTER('1976-15-15');
QUARTER('1976-15-15')
NULL

SELECT QUARTER('0000-00-00');
QUARTER('0000-00-00')
0

SELECT QUARTER('2008-12-00');
QUARTER('2008-12-00')
4