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

group_concat( column_json(dynamic_column )) return empty result

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.9
    • 10.0.10
    • None
    • None

    Description

      mysql> desc mysql.http_status_history;
      		 
      +--------+-------------+------+-----+---------+-------+
      		 
      | Field  | Type        | Null | Key | Default | Extra |
      		 
      +--------+-------------+------+-----+---------+-------+
      		 
      | id     | smallint(6) | NO   | PRI | 0       |       |
      		 
      | status | blob        | YES  |     | NULL    |       |
      		 
      +--------+-------------+------+-----+---------+-------+
      		 

      select id,column_json(status)  from http_status_history;
      		 
       
      		 
       {"date":"2014-03-12 21:36:57","UPTIME":"10","ROWS_READ":"-437","MEMORY_USED":"1.18e6","SELECT_SCAN":"-1","OPENED_FILES":"76","HANDLER_WRITE":"-38","ROWS_TMP_READ":"-400","HANDLER_COMMIT":"-1","HANDLER_UPDATE":"-38","HANDLER_READ_KEY":"-438","INNODB_ROWS_READ":"53","HANDLER_TMP_WRITE":"-400","INNODB_LOG_WRITES":"1","KEY_READ_REQUESTS":"16","COM_REPLACE_SELECT":"-1","CREATED_TMP_TABLES":"-1","INNODB_DATA_FSYNCS":"7","INNODB_DATA_WRITES":"11","INNODB_DATA_WRITTEN":"230400","INNODB_DBLWR_WRITES":"2","ARIA_PAGECACHE_READS":"2","INNODB_OS_LOG_FSYNCS":"2","INNODB_PAGES_WRITTEN":"7","INNODB_ROWS_INSERTED":"1","HANDLER_READ_RND_NEXT":"-400","INNODB_OS_LOG_WRITTEN":"512","TABLE_LOCKS_IMMEDIATE":"14","OPENED_PLUGIN_LIBRARIES":"33","UPTIME_SINCE_FLUSH_STATUS":"10","INNODB_DBLWR_PAGES_WRITTEN":"7","ARIA_PAGECACHE_READ_REQUESTS":"113","ARIA_PAGECACHE_WRITE_REQUESTS":"6","INNODB_BUFFER_POOL_BYTES_DIRTY":"-81920","INNODB_BUFFER_POOL_PAGES_DIRTY":"-5","INNODB_BUFFER_POOL_PAGES_FLUSHED":"7","INNODB_BUFFER_POOL_READ_REQUESTS":"70","INNODB_BUFFER_POOL_WRITE_REQUESTS":"4"} |
      		 
      | {"date":"2014-03-12 21:37:08","UPTIME":"11","BUSY_TIME":"5.9e-5","QUESTIONS":"1","ROWS_READ":"-435","BYTES_SENT":"33","MEMORY_USED":"1.18e6","SELECT_SCAN":"-1","OPENED_FILES":"76","HANDLER_WRITE":"-37","ROWS_TMP_READ":"-400","BYTES_RECEIVED":"57","HANDLER_COMMIT":"-1","HANDLER_UPDATE":"-37","HANDLER_READ_KEY":"-437","INNODB_ROWS_READ":"54","HANDLER_TMP_WRITE":"-400","INNODB_LOG_WRITES":"1","KEY_READ_REQUESTS":"16","COM_REPLACE_SELECT":"-1","CREATED_TMP_TABLES":"-1","INNODB_DATA_FSYNCS":"7","INNODB_DATA_WRITES":"11","INNODB_DATA_WRITTEN":"230400","INNODB_DBLWR_WRITES":"2","ARIA_PAGECACHE_READS":"2","INNODB_OS_LOG_FSYNCS":"2","INNODB_PAGES_WRITTEN":"7","INNODB_ROWS_INSERTED":"1","HANDLER_READ_RND_NEXT":"-399","INNODB_OS_LOG_WRITTEN":"512","TABLE_LOCKS_IMMEDIATE":"14","OPENED_PLUGIN_LIBRARIES":"33","UPTIME_SINCE_FLUSH_STATUS":"11","INNODB_DBLWR_PAGES_WRITTEN":"7","ARIA_PAGECACHE_READ_REQUESTS":"113","ARIA_PAGECACHE_WRITE_REQUESTS":"6","INNODB_BUFFER_POOL_BYTES_DIRTY":"-81920","INNODB_BUFFER_POOL_PAGES_DIRTY":"-5","INNODB_BUFFER_POOL_PAGES_FLUSHED":"7","INNODB_BUFFER_POOL_READ_REQUESTS":"71","INNODB_BUFFER_POOL_WRITE_REQUESTS":"4"} |
      		 

       select GROUP_CONCAT(cast(column_json(status) as char))  from  mysql.http_status_history;
      		 
      +----------------------------------------------------------------------------+
      		 
      | GROUP_CONCAT(cast(column_json(status) as char))                            |
      		 
      +----------------------------------------------------------------------------+
      		 
      | ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, |
      		 
      +----------------------------------------------------------------------------+

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova added a comment - 

          create table t1 (dyn blob);
          		 
          insert into t1 values (column_create('name1','value1','name2','value2'));
          		 
          select group_concat(cast(column_json(dyn) as char)) from t1;
          		 

          +----------------------------------------------+
          		 
          | group_concat(cast(column_json(dyn) as char)) |
          		 
          +----------------------------------------------+
          		 
          |                                              |
          		 
          +----------------------------------------------+
          		 
          1 row in set (0.00 sec)

          elenst Elena Stepanova added a comment - create table t1 (dyn blob); insert into t1 values (column_create( 'name1' , 'value1' , 'name2' , 'value2' )); select group_concat( cast (column_json(dyn) as char )) from t1; +----------------------------------------------+ | group_concat(cast(column_json(dyn) as char)) | +----------------------------------------------+ | | +----------------------------------------------+ 1 row in set (0.00 sec)
          sanja Oleksandr Byelkin added a comment -

          the temporary table used for grouping has 0 length field

          sanja Oleksandr Byelkin added a comment - the temporary table used for grouping has 0 length field
          elenst Elena Stepanova added a comment -

          Reopening to fix the 'Fix version'

          elenst Elena Stepanova added a comment - Reopening to fix the 'Fix version'

          People

            sanja Oleksandr Byelkin
            stephane@skysql.com VAROQUI Stephane
            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.