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

TRUNCATE forces decimal format for string arguments (internally inconsistent)

    XMLWordPrintable

Details

    Description

      SELECT TRUNCATE('0x10', 1), TRUNCATE('abc', 1), TRUNCATE(0, 1);
      – MariaDB: '0.0' '0.0' 0 <-- string inputs yield '0.0', numeric input yields 0 — self-inconsistent
      – MySQL: 0 0 0
      SELECT CONCAT('X', TRUNCATE('0x10', 1));
      – MariaDB: 'X0.0' MySQL: 'X0'

      Attachments

        Activity

          People

            raghunandan.bhat Raghunandan Bhat
            chunlingqin chunlingqin
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.