Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5133

Test suite tests *_func_view fail in time zones East of UTC+3

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.33a
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          Slackware Linux 14.0 + kernel 3.10.4 32-bit i386

          Description

          Tests innodb_func_view, memory_func_view and myisam_func_view all fail on the timestamp of 1970-01-01 03:00:01. This timestamp is expressed in local time but stored in UTC time. In countries like Australia (UTC+10:00), this tmestamp falls before the Epoch and so is rejected.
          The attached patch changes the timestamp to 1970-01-01 13:00:01, which should pass almost everywhere (the International Date Line has a deviation in the South Pacific which could enable UTC+14:00 but any such countries are too small to show up on my A5 world map).

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                Why not 14:00 to pass everywhere?

                Show
                sanja Oleksandr Byelkin added a comment - Why not 14:00 to pass everywhere?
                Hide
                Permalink
                duncan_roe Duncan Roe added a comment -

                OK you got it

                Show
                duncan_roe Duncan Roe added a comment - OK you got it
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                Thank you a lot! (I was going to do it just wanted to know if there is something special about 13 hour which I could not see, so you made my work way more simple)

                Show
                sanja Oleksandr Byelkin added a comment - Thank you a lot! (I was going to do it just wanted to know if there is something special about 13 hour which I could not see, so you made my work way more simple)

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    duncan_roe Duncan Roe
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: