EXTRACT() produces an error when it should not

Asked by Aarti Pai on 2009-01-27

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

Question information

Language:
English Edit question
Status:
Answered
For:
Drizzle Edit question
Assignee:
No assignee Edit question
Last query:
2009-01-27
Last reply:
2009-01-28
Aarti Pai (aarti-pai) said : #1

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

Jay Pipes (jaypipes) said : #2

There is a little pink minus sign icon next to the bug (or blueprint or branch) name on the associated page. You can click to delete the item. It's easy to miss!

Can you help with this problem?

Provide an answer of your own, or ask Aarti Pai for more information if necessary.

To post a message you must log in.