Drizzle

EXTRACT() produces an error when it should not

Asked by Aarti Pai

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:
Last reply:

This question was originally filed as bug #322048.

Revision history for this message
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?

Revision history for this message
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.