Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5335

JSON_DETAILED currently isn't supported

    XMLWordPrintable

Details

    • 2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11

    Description

      Currently on CS 22.08.4, JSON_DETAILED does not work.

      Docs: https://mariadb.com/kb/en/json_detailed/

      Reproduce

      CREATE TABLE `jsontest` (
      		 
        `a` int(11) DEFAULT NULL,
      		 
        `cVarchar` varchar(255) DEFAULT NULL,
      		 
        `cText` MEDIUMTEXT DEFAULT NULL
      		 
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3
      		 
       
      		 
      SET @json = '
      		 
      {"key1":"xxxx", "key2":[1, 2, 3]}
      		 
      ';
      		 
      INSERT INTO jsontest VALUES (1, @json, @json);
      		 
       
      		 
      SELECT cVarchar, JSON_DETAILED(cVarchar), cText, JSON_DETAILED(cText) from jsontest; -- MCS-1001: Function 'json_detailed' isn't supported.

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            allen.herrera Allen Herrera
            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.