XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      This SQL script checks recognition of JSON data type and triggers checks on INSERT and UPDATE statements:

      USE test;
      DROP TABLE IF EXISTS tj;
      CREATE TABLE tj(j JSON); --ENGINE=COLUMNSTORE;
      INSERT INTO tj(j) VALUES ('()'); -- invalid
      INSERT INTO tj(j) VALUES ('[]'), ('{}'), ('"a"'); -- valid
      SELECT * FROM tj WHERE j = '"A"'; -- empty set.
      SELECT * FROM tj WHERE j = '"a"'; -- single row.
      INSERT INTO tj(j) VALUES ('{"a":"b", "b":"a"}');
      SELECT * FROM tj WHERE j = '{"b":"a","a":"b"}'; -- empty set, comparison is not structural.
      UPDATE tj SET j = CONCAT(j,'()');
      

      The goal of this task is to make it properly work with Columnstore engine.

      Attachments

        Issue Links

          Activity

            People

              sergey.zefirov Sergey Zefirov
              sergey.zefirov Sergey Zefirov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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