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

WEEK mode argument out of range silently taken modulo

    XMLWordPrintable

Details

    Description

      SELECT WEEK('2026-01-01', 4294967295); – MDB: 52 (mode mod 8 = 7) MY: 0

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41549 Date and datetime strings take year/month/day/hour/minute/second modulo 2^32 (and TIME strings minute/second modulo 2^64) without a warning: CAST('4294969296-11-21' AS DATE) = 2000-11-21

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Confirmed

          Activity

            People

              raghunandan.bhat Raghunandan Bhat
              chunlingqin chunlingqin
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 2d
                  2d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.