EXTRACT() produces an error when it should not

Bug #322048 reported by Aarti Pai on 2009-01-27

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

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  Edit
Everyone can see this information.

Other bug subscribers