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

[PATCH] COLUMN_CHECK fails on valid data

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.0.20, 10.1.7, 10.1.8, 10.0.21-galera
    • Fix Version/s: 10.0.22, 10.1.9
    • Component/s: Dynamic Columns
    • Labels:
      None
    • Environment:
      Server version: 10.0.20-MariaDB-1~wheezy-wsrep-log

      Description

      COLUMN_CHECK fails on valid data

      SELECT COLUMN_CHECK(COLUMN_CREATE('a',0,'b','1'))
      Result: 0 (failed)
       
      SELECT COLUMN_CHECK(COLUMN_CREATE('a',1,'b','1'))
      Result: 1 (correct)
       
      SELECT COLUMN_JSON(COLUMN_CREATE('a',0,'b','1'))
      Result: {"a":0,"b":"1"} (correct)
       
      SELECT COLUMN_JSON(COLUMN_CREATE('a',1,'b','1'))
      Result: {"a":1,"b":"1"} (correct)

      It appears that COLUMN_CHECK fails when one of the dynamic column values is set to INTEGER 0, and only when there is more than 1 dynamic column present. COLUMN_JSON is able to parse the results properly, so the returned values from COLUMN_CREATE appears to be correct.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              darkain Vincent Milum Jr
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: