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

[PATCH] COLUMN_CHECK fails on valid decimal data

    XMLWordPrintable

    Details

    • Sprint:
      10.1.10

      Description

      Similar to MDEV-8565 , COLUMN_CHECK can fail with valid Decimal values:

      select column_check(column_create('0', '0' as decimal, '1', '0' as decimal));
      		 
      Result: 0 (failed)

      I think the patch for MDEV-8565 simply missed that decimal 0 is also stored in 0 bytes, as in:

      /* Store decimal zero as empty string */
      		 
        if (precision == 0)
      		 
          return ER_DYNCOL_OK;

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8565 [PATCH] COLUMN_CHECK fails on valid data

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link Pull request

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              adamchainz Adam Johnson
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: