** 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
--
Mailing list: https://launchpad.net/~linux-traipu
Post to : [email protected]
Unsubscribe : https://launchpad.net/~linux-traipu
More help : https://help.launchpad.net/ListHelp
