maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #05804
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