|
drop table if exists t2;
|
create table t2 (b blob) engine=Columnstore;
|
insert into t2 values (column_create('foo','bar'));
|
select column_json(b) from t2;
|
|
MariaDB f93bfb9288d020b190f5c73a31223fff6439687d
|
MariaDB [db]> insert into t2 values (column_create('foo','bar'));
|
Query OK, 1 row affected (0.148 sec)
|
|
MariaDB [db]> select column_json(b) from t2;
|
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'column_json' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.
|
It's not very surprising that functionality is not supported, but the error is strange, and also probably INSERT should be rejected.
|