CURTIME function doesn't work

Bug #804570 reported by Piotr Przybylski on 2011-07-01
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Low
Matthew Rheaume

Bug Description

If CURDATE works as a synonym to CURRENT_DATE, then CURTIME should also. Moreover, it's mentioned in docs: http://docs.drizzle.org/functions/current_time_functions.html

Using 2011.03.13 from Ubuntu 11.04 packages.

Related branches

Brian Aker (brianaker) on 2011-07-12
Changed in drizzle:
importance: Undecided → Low
Henrik Ingo (hingo) on 2011-08-08
tags: added: docs
Changed in drizzle:
status: New → In Progress
assignee: nobody → Matthew Rheaume (mhrheaume)

Hi,
  Please make sure to add documentation for this as I believe that I ve
removed it since it was not working earlier.

Cheers,
-Vijay
On Sep 25, 2011 3:51 PM, "Matthew Rheaume" <email address hidden>
wrote:
> ** Changed in: drizzle
> Status: New => In Progress
>
> ** Changed in: drizzle
> Assignee: (unassigned) => Matthew Rheaume (mhrheaume)
>
> --
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
> https://bugs.launchpad.net/bugs/804570
>
> Title:
> CURTIME function doesn't work
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
Applications:
> In Progress
>
> Bug description:
> If CURDATE works as a synonym to CURRENT_DATE, then CURTIME should
> also. Moreover, it's mentioned in docs:
> http://docs.drizzle.org/functions/current_time_functions.html
>
> Using 2011.03.13 from Ubuntu 11.04 packages.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/drizzle/+bug/804570/+subscriptions

Matthew Rheaume (mhrheaume) wrote :

Certainly Vijay. I was wondering if it had been implemented earlier because there were a few references to Item_func_curtime in the comments, but I couldn't find an actual implementation anywhere. I'll make sure to document thoroughly.

Cheers,
-mhr

There is no implementation for CURTIME() and CURRENT_TIME()( although CURDATE() and CURRENT_DATE() works), but these are still available in documentation.
http://docs.drizzle.org/functions/current_time_functions.html

admins should probably remove them from docs.

my experience with trial..

drizzle> select current_time();
ERROR 1305 (42000): FUNCTION current_time does not exist
drizzle> select curtime();
ERROR 1305 (42000): FUNCTION curtime does not exist
drizzle> SELECT CURTIME();
ERROR 1305 (42000): FUNCTION CURTIME does not exist
drizzle> SELECT CURTIME() + 0;
ERROR 1305 (42000): FUNCTION CURTIME does not exist
drizzle> SELECT current_time() + 0;
ERROR 1305 (42000): FUNCTION current_time does not exist

Vijay Samuel (vjsamuel) on 2012-02-15
Changed in drizzle:
milestone: none → 2012-01-31
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers