← Back to team overview

maria-developers team mailing list archive

Dynamic Columns Test Error

 

MariaDB [test]> show create table assets ;
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table

                       |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| assets | CREATE TABLE `assets` (
  `item_name` varchar(32) NOT NULL,
  `dynamic_cols` blob,
  PRIMARY KEY (`item_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> insert into assets values ('MariaDB T-shirt',
COLUMN_CREATE('color', 'blue', 'size', 'XL'));
ERROR 1921 (22007): Illegal value used as argument of dynamic column
function
MariaDB [test]> select version();
+--------------------+
| version()          |
+--------------------+
| 5.5.31-MariaDB-log |
+--------------------+
1 row in set (0.00 sec)


Why?


-- 
姓名: river/吴炳锡    手机:13501245755
http://www.mysqlsupport.cn
创业公司MySQL 支持,优化,架构设计

Follow ups