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

[PATCH] COLUMN_CHECK fails on valid data

    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: