MDEV-11439 No data type JSON, but CAST(something AS JSON) pretends to work

remove CAST(... AS JSON) from the grammar for 10.2.4

2 files changed, 3 insertions, 12 deletions

diff --git a/mysql-test/r/func_json.result b/mysql-test/r/func_json.result
index e8d11fce56f..80b257cdd31 100644
--- a/mysql-test/r/func_json.result
+++ b/mysql-test/r/func_json.result
@@ -402,15 +402,6 @@ json_object("a", json_object("b", "abcd"))
 select json_object("a", '{"b": "abcd"}');
 json_object("a", '{"b": "abcd"}')
 {"a": "{\"b\": \"abcd\"}"}
-select json_object("a", cast('{"b": "abcd"}' as json));
-json_object("a", cast('{"b": "abcd"}' as json))
-{"a": {"b": "abcd"}}
-select cast(NULL AS JSON);
-cast(NULL AS JSON)
-NULL
-select json_depth(cast(NULL as JSON));
-json_depth(cast(NULL as JSON))
-NULL
 select json_depth('[[], {}]');
 json_depth('[[], {}]')
 2
diff --git a/mysql-test/t/func_json.test b/mysql-test/t/func_json.test
index aedc65159c5..ea616cbb19f 100644
--- a/mysql-test/t/func_json.test
+++ b/mysql-test/t/func_json.test
@@ -161,10 +161,10 @@ select json_unquote('abc');
 
 select json_object("a", json_object("b", "abcd"));
 select json_object("a", '{"b": "abcd"}');
-select json_object("a", cast('{"b": "abcd"}' as json));
+#select json_object("a", cast('{"b": "abcd"}' as json));
 
-select cast(NULL AS JSON);
-select json_depth(cast(NULL as JSON));
+#select cast(NULL AS JSON);
+#select json_depth(cast(NULL as JSON));
 select json_depth('[[], {}]');
 select json_depth('[[[1,2,3],"s"], {}, []]');
 select json_depth('[10, {"a": 20}]');