Incorrect documentation of EXTRACT

Bug #850858 reported by Vijay Samuel
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Medium
Vijay Samuel

Bug Description

cocs state that:

SELECT EXTRACT(SECOND FROM TIME '08:15:22.5');

Result: 22.5

but on running on the client yields:
drizzle> SELECT EXTRACT(SECOND FROM TIME '08:15:22.5');
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 ''08:15:22.5')' at line 1

incorrect docs need to be removed.

Related branches

Vijay Samuel (vjsamuel)
Changed in drizzle:
assignee: nobody → Vijay Samuel (vjsamuel)
importance: Undecided → Medium
status: New → In Progress
Vijay Samuel (vjsamuel)
Changed in drizzle:
status: In Progress → Fix Committed
Vijay Samuel (vjsamuel)
Changed in drizzle:
status: Fix Committed → Fix Released
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.