You haven't checked the note: *(note: the above example uses MariaDB 10.0.1<https://kb.askmonty.org/en/mariadb-1001-release-notes/>. In MariaDB 5.3 <https://kb.askmonty.org/en/what-is-mariadb-53/>, columns can only be identified by numbers. See the #mariadb-53-vs-mariadb-100<https://kb.askmonty.org/en/dynamic-columns/#mariadb-53-vs-mariadb-100> section below)* * * * * On Tue, Jul 2, 2013 at 9:03 AM, River wubx <wubingxi@gmail.com> wrote:
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 支持，优化，架构设计
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp