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

Crash in CONVERT_TZ

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 10.0.3, 5.5.31, 5.3.12
        • Fix Version/s: 5.5.32, 5.3.13
        • Component/s: None
        • Labels:
          None

          Description

          This query crashes the server (debug build):

          SELECT CONVERT_TZ(GREATEST(DATE('2021-00-00'),DATE('2021-00-00')),'+00:00','+7:5');

          So does this one:

          SELECT CONVERT_TZ(GREATEST(TIMESTAMP('2021-00-00'),TIMESTAMP('2021-00-00')),'+00:00','+7:5');

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                bar Alexander Barkov added a comment - - edited

                #4 tztime.cc:799: my_time_t sec_since_epoch(int, int, int, int, int, int): Assertion `mon > 0 && mon < 13' failed
                #5 0x00000000006df9f9 in Time_zone_offset::TIME_to_gmt_sec (this=0x2887d40,
                t=0x7fffcc2e92f0, error_code=0x7fffcc2e9324)
                at /home/bar/maria-bzr/maria-10.0-connect/sql/tztime.cc:1385
                #6 0x00000000006dc801 in TIME_to_timestamp (thd=0x2b1b920, t=0x7fffcc2e92f0,
                error_code=0x7fffcc2e9324)

                Show
                bar Alexander Barkov added a comment - - edited #4 tztime.cc:799: my_time_t sec_since_epoch(int, int, int, int, int, int): Assertion `mon > 0 && mon < 13' failed #5 0x00000000006df9f9 in Time_zone_offset::TIME_to_gmt_sec (this=0x2887d40, t=0x7fffcc2e92f0, error_code=0x7fffcc2e9324) at /home/bar/maria-bzr/maria-10.0-connect/sql/tztime.cc:1385 #6 0x00000000006dc801 in TIME_to_timestamp (thd=0x2b1b920, t=0x7fffcc2e92f0, error_code=0x7fffcc2e9324)

                  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: