Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.3
    • Fix Version/s: 10.0.7
    • Component/s: None
    • Labels:
      None

      Description

      HOUR() correctly returns hour>23 values in this script:

      CREATE TABLE t1 (a TIME);
      INSERT INTO t1 VALUES ('1 00:00:00');
      SELECT a, HOUR(a) FROM t1;
      +----------+---------+
      | a        | HOUR(a) |
      +----------+---------+
      | 24:00:00 |      24 |
      +----------+---------+
      

      and in this script:

      SELECT HOUR(MAKETIME(24,0,0));
      +------------------------+
      | HOUR(MAKETIME(24,0,0)) |
      +------------------------+
      |                     24 |
      +------------------------+
      

      However, it does not work well in some cases:

      SELECT HOUR('1 00:00:00'), HOUR(TIME('1 00:00:00'));
      +--------------------+--------------------------+
      | HOUR('1 00:00:00') | HOUR(TIME('1 00:00:00')) |
      +--------------------+--------------------------+
      |                  0 |                        0 |
      +--------------------+--------------------------+
      

      MySQL-5.5 exhibit the same behaviour.
      MySQL-5.6 correctly returns "24" for both expressions in the last query.

      So this bug should probably be fixed only in 10.0
      (while 5.3 and 5.5 should keep the original behaviour).

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            serg Sergei Golubchik added a comment -

            I'd say, it should be fixed from 5.3 upwards

            Show
            serg Sergei Golubchik added a comment - I'd say, it should be fixed from 5.3 upwards
            Hide
            bar Alexander Barkov added a comment -

            Fixed in 5.3 and 5.5.

            Show
            bar Alexander Barkov added a comment - Fixed in 5.3 and 5.5.
            Show
            dbart Daniel Bartholomew added a comment - http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3992 http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/2502.567.173

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: