linux-traipu team mailing list archive

[Vijay Samuel <850858@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: drizzle
     Importance: Medium
     Assignee: Vijay Samuel (vjsamuel)
         Status: In Progress

** Changed in: drizzle
   Importance: Undecided => Medium

** Changed in: drizzle
       Status: New => In Progress

** Changed in: drizzle
     Assignee: (unassigned) => Vijay Samuel (vjsamuel)

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/850858

Title:
  Incorrect documentation of EXTRACT

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  In Progress

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/850858/+subscriptions