WEEK function doesn't exist or invalid error message

Bug #804571 reported by Piotr Przybylski on 2011-07-01
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Undecided
Unassigned

Bug Description

drizzle> select week('2011-11-11');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '('2011-11-11')' at line 1

This function should work or the error should say:

drizzle> ERROR 1305 (42000): FUNCTION week does not exist

The same concerns TIME.

Using 2011.03.13 from Ubuntu 11.04 packages.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers