← Back to team overview

linux-traipu team mailing list archive

[Bug 420029] Re: TO_DAYS function returns incorrect value

 

** Changed in: drizzle
       Status: Confirmed => Fix Released

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

Title:
  TO_DAYS function returns incorrect value

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Fix Released

Bug description:
  In the crash-me test there is a check for TO_DAYS function. Drizzle is
  returning an incorrect value.  The TO_DAYS function takes a date
  argument and is suppose to return the number of days since the year 0.
  Note that we should add a test to our test suite for this  once this
  bug is fixed

  drizzle> select to_days('1996-01-01');
  +-----------------------+
  | to_days('1996-01-01') |
  +-----------------------+
  |               2450084 |  <------ should be 729024
  +-----------------------+
  1 row in set (0 sec)

  drizzle> select to_days('0001-01-01');
  +-----------------------+
  | to_days('0001-01-01') |
  +-----------------------+
  |               1721426 |    <----- should be 366
  +-----------------------+
  1 row in set (0 sec)

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