From 7ff24eb01fe4a9db441a00184fef6a99c82c75ac Mon Sep 17 00:00:00 2001
From: "serg@serg.mylan" <>
Date: Fri, 20 Feb 2004 20:38:34 +0100
Subject: longer myisam keys

---
 mysql-test/r/key.result | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'mysql-test/r/key.result')

diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result
index dca7b580378..115f15bacb6 100644
--- a/mysql-test/r/key.result
+++ b/mysql-test/r/key.result
@@ -185,3 +185,24 @@ NULL	2
 a	1
 a	2
 drop table t1;
+create table t1 (i int, a char(200), b text, unique (a), unique (b(300))) charset utf8;
+insert t1 values (1, repeat('a',210), repeat('b', 310));
+Warnings:
+Warning	1265	Data truncated for column 'a' at row 1
+insert t1 values (2, repeat(0xD0B1,215), repeat(0xD0B1, 310));
+Warnings:
+Warning	1265	Data truncated for column 'a' at row 1
+select i, length(a), length(b), char_length(a), char_length(b) from t1;
+i	length(a)	length(b)	char_length(a)	char_length(b)
+1	200	310	200	310
+2	400	620	200	310
+select i from t1 where a=repeat(_utf8 'a',200);
+i
+1
+select i from t1 where a=repeat(_utf8 0xD0B1,200);
+i
+2
+select i from t1 where b=repeat(_utf8 'b',310);
+i
+1
+drop table t1;
-- 
cgit v1.2.1