Forum Stats

  • 3,854,665 Users
  • 2,264,397 Discussions
  • 7,905,749 Comments

Discussions

NDB Cluster Engine Supports JSON datatype?

user10361386
user10361386 Member Posts: 3
edited May 12, 2016 5:24AM in MySQL Community Space

Hi,

We are planning to use JSON with NDB Cluser and downloaded the mysql-cluster-gpl-7.4.10-linux-glibc2.5-x86_64 but it delivers mysql 5.6.28 ((mysql-5.6.28 ndb-7.4.10) which doesn't deliver JSON support.

We downloaded the development version mysql-cluster-gpl-7.5.1-linux-glibc2.5-x86_64(mysql-5.7.11 ndb-7.5.1) which does deliver the JSON support but not for the table which have ENGINE=NDBCLUSTER.

mysql> CREATE TABLE `json_tst` (`jdoc` json DEFAULT NULL) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ERROR 1112 (42000): Table 'json_tst' uses an extension that doesn't exist in this MySQL version

mysql> CREATE TABLE `json_tst` (`jdoc` json DEFAULT NULL);

Query OK, 0 rows affected (0.01 sec)

mysql> show create table json_tst\G

*************************** 1. row ***************************

       Table: json_tst

Create Table: CREATE TABLE `json_tst` (

  `jdoc` json DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

1 row in set (0.00 sec)

mysql> CREATE TABLE `json_tst2` (ID int(11) NOT NULL auto_increment PRIMARY KEY,`jdoc` json DEFAULT NULL) ENGINE=NDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ERROR 1112 (42000): Table 'json_tst2' uses an extension that doesn't exist in this MySQL version

mysql> CREATE TABLE `json_tst2` (ID int(11) NOT NULL auto_increment PRIMARY KEY,`jdoc` varchar(20) DEFAULT NULL) ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

2016-04-11T21:29:31.305349Z 4 [Note] NDB Binlog: CREATE TABLE Event: REPL$test/json_tst2

Query OK, 0 rows affected (0.11 sec)

Please send me the reply on [email protected].

Amit

Tagged:
Dave Stokes-MySQL Community Team-Oracleivwvi

Answers