summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_json.test
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2017-05-02 15:47:43 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2017-05-02 15:47:43 +0400
commit3ea9d3e59eecadce877416218a7f7789e65ba69a (patch)
tree522544684c5edb376a69e42dc836b4af0cf4bf65 /mysql-test/t/func_json.test
parent4a484e7a207f927089893a0344afa15031803e5d (diff)
downloadmariadb-git-3ea9d3e59eecadce877416218a7f7789e65ba69a.tar.gz
MDEV-12363 Assertion `0' failed in Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*).
maybe_null wasn't properly set for Item_json_func_keys.
Diffstat (limited to 'mysql-test/t/func_json.test')
-rw-r--r--mysql-test/t/func_json.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_json.test b/mysql-test/t/func_json.test
index ce13456bf25..0fc8e97b284 100644
--- a/mysql-test/t/func_json.test
+++ b/mysql-test/t/func_json.test
@@ -287,3 +287,12 @@ SELECT JSON_SEARCH('{"foo":"bar"}', 'all' , @str, '%', @path);
SELECT JSON_VALUE('[{"foo": 1},"bar"]', '$[*][0]');
+#
+# MDEV-12363 Assertion `0' failed in Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*)
+#
+
+CREATE TABLE t1 (f INT NOT NULL);
+INSERT INTO t1 VALUES (0);
+SELECT JSON_KEYS(f) FROM t1 ORDER BY 1;
+DROP TABLE t1;
+