diff options
Diffstat (limited to 'mysql-test/t/type_json.test')
-rw-r--r-- | mysql-test/t/type_json.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/t/type_json.test b/mysql-test/t/type_json.test new file mode 100644 index 00000000000..0f6d091d6e3 --- /dev/null +++ b/mysql-test/t/type_json.test @@ -0,0 +1,28 @@ +# +# MDEV-9144 JSON data type +# + +create or replace table t1(a json); +show create table t1; + +create or replace table t1(a json character set utf8 default '{a:1}'); +show create table t1; + +create or replace table t1(a json binary not null check (json_valid(a))); +show create table t1; +insert t1 values ('[]'); +--error ER_CONSTRAINT_FAILED +insert t1 values ('a'); + +set timestamp=unix_timestamp('2010:11:12 13:14:15'); +create or replace table t1(a json default(json_object('now', now()))); +show create table t1; +insert t1 values (); +select * from t1; + +drop table t1; + +--error ER_PARSE_ERROR +select cast('{a:1}' as text); +--error ER_PARSE_ERROR +select cast('{a:1}' as json); |