maria-developers team mailing list archive

[Yper Cube <ypercube@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>
>