EXTRACT() produces an error when it should not

Bug #322048 reported by Aarti Pai

This bug report was converted into a question: question #58917: EXTRACT() produces an error when it should not.

6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Invalid
Undecided
Unassigned

Bug Description

See extract.test. '1000-01-10 00:00:00' is a valid date/time, and drizzle should succeed without producing any errors.

drizzletest: At line 41: query 'SELECT EXTRACT(DAY_HOUR FROM '1000-01-10 00:00:00')' succeeded - should have failed with errno 1686...

SELECT EXTRACT(DAY_HOUR FROM '1000-01-10 00:00:00');
EXTRACT(DAY_HOUR FROM '1000-01-10 00:00:00')
1000

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

This is not a bug. There was an error in my test script. How do I delete a bug I submitted in error?

Changed in drizzle:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.