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

TRUNCATE forces decimal format for string arguments (internally inconsistent)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.11, 11.4, 11.8, 12.3, 13.0, 13.1
    • N/A
    • Data types
    • Not for Release Notes

    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:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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