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

[PATCH] COLUMN_CHECK fails on valid data

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0.20, 10.1.7, 10.1.8, 10.0.21-galera
    • 10.0.22, 10.1.9
    • Dynamic Columns
    • None
    • 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

              sanja Oleksandr Byelkin
              darkain Vincent Milum Jr
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.