summaryrefslogtreecommitdiff
path: root/mysql-test/r/dyncol.result
diff options
context:
space:
mode:
authorunknown <sanja@montyprogram.com>2014-03-13 10:38:41 +0200
committerunknown <sanja@montyprogram.com>2014-03-13 10:38:41 +0200
commit70c08df4dc6899991c29c4db3253d8e4efc4ee77 (patch)
treeae111c9dfcac2a46cc36867a1abc921af67de714 /mysql-test/r/dyncol.result
parent89406110796a7bea9dccd92a8e61ca30d388f94b (diff)
downloadmariadb-git-70c08df4dc6899991c29c4db3253d8e4efc4ee77.tar.gz
MDEV-5840: group_concat( column_json(dynamic_column )) return empty result
Fixed max_length of dynamic columns json/create/add functions.
Diffstat (limited to 'mysql-test/r/dyncol.result')
-rw-r--r--mysql-test/r/dyncol.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/dyncol.result b/mysql-test/r/dyncol.result
index ca2130cd700..5646de88d26 100644
--- a/mysql-test/r/dyncol.result
+++ b/mysql-test/r/dyncol.result
@@ -1755,3 +1755,16 @@ Warning 1265 Data truncated for column 'dyncol' at row 1
SELECT COLUMN_ADD( COLUMN_ADD( dyncol, 1, REPEAT('b',130) ), 3, 'y' ) FROM t1;
ERROR HY000: Encountered illegal format of dynamic column string
DROP TABLE t1;
+#
+#MDEV-5840: group_concat( column_json(dynamic_column )) return empty
+#result
+#
+create table t1 (dyn blob);
+insert into t1 values (column_create('name1','value1','name2','value2'));
+select group_concat(cast(column_json(dyn) as char)) from t1;
+group_concat(cast(column_json(dyn) as char))
+{"name1":"value1","name2":"value2"}
+drop table t1;
+#
+# end of 10.0 tests
+#