summaryrefslogtreecommitdiff
path: root/mysql-test/r/ctype_latin1.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mnogosearch.org>2013-12-17 15:19:26 +0400
committerAlexander Barkov <bar@mnogosearch.org>2013-12-17 15:19:26 +0400
commitdc407270a1b4911ece0ff9a52ae6af8443b30f39 (patch)
tree421fe3091f6d111803e601193c83b3dcfbbb3746 /mysql-test/r/ctype_latin1.result
parent39a8d7965d912d8fb32436735449ce04e85583d1 (diff)
downloadmariadb-git-dc407270a1b4911ece0ff9a52ae6af8443b30f39.tar.gz
MDEV-5453 Assertion `src' fails in my_strnxfrm_unicode on GROUP BY MID(..) WITH ROLLUP
Fixed a wrong assertion.
Diffstat (limited to 'mysql-test/r/ctype_latin1.result')
-rw-r--r--mysql-test/r/ctype_latin1.result34
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_latin1.result b/mysql-test/r/ctype_latin1.result
index 2debf288f44..52b30808f34 100644
--- a/mysql-test/r/ctype_latin1.result
+++ b/mysql-test/r/ctype_latin1.result
@@ -318,6 +318,23 @@ latin1_swedish_ci 6109
latin1_swedish_ci 61
latin1_swedish_ci 6120
drop table t1;
+#
+# MDEV-5453 Assertion `src' fails in my_strnxfrm_unicode on GROUP BY MID(..) WITH ROLLUP
+#
+SELECT @@collation_connection;
+@@collation_connection
+latin1_swedish_ci
+CREATE TABLE t1 (i INT) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (1),(2);
+SELECT * FROM t1 GROUP BY MID(CURRENT_USER,0) WITH ROLLUP;
+i
+1
+1
+SELECT * FROM t1 GROUP BY MID('test',0) WITH ROLLUP;
+i
+1
+1
+DROP TABLE t1;
select @@collation_connection;
@@collation_connection
latin1_swedish_ci
@@ -365,6 +382,23 @@ latin1_bin 6109
latin1_bin 61
latin1_bin 6120
drop table t1;
+#
+# MDEV-5453 Assertion `src' fails in my_strnxfrm_unicode on GROUP BY MID(..) WITH ROLLUP
+#
+SELECT @@collation_connection;
+@@collation_connection
+latin1_bin
+CREATE TABLE t1 (i INT) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (1),(2);
+SELECT * FROM t1 GROUP BY MID(CURRENT_USER,0) WITH ROLLUP;
+i
+1
+1
+SELECT * FROM t1 GROUP BY MID('test',0) WITH ROLLUP;
+i
+1
+1
+DROP TABLE t1;
select @@collation_connection;
@@collation_connection
latin1_bin