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

group_concat( column_json(dynamic_column )) return empty result

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0.10
        • Component/s: None
        • Labels:
          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))                            |
+----------------------------------------------------------------------------+
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, |
+----------------------------------------------------------------------------+

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                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)
                Show
                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)
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                the temporary table used for grouping has 0 length field

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

                Reopening to fix the 'Fix version'

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

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    stephane@skysql.com VAROQUI Stephane
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: