MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Jonathan Miller Date:December 8 2006 4:41pm
Subject:bk commit into 5.1 tree (jmiller:1.2376) BUG#20353
View as plain text  
Below is the list of changes that have just been committed into a local
5.1 repository of ndbdev. When ndbdev does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2006-12-08 17:41:49+01:00, jmiller@stripped +2 -0
  prefix_key_search.result, prefix_key_search.test:
    Test case for Bug #20353  Prefix key search return incorrect results for ignorable characters

  mysql-test/r/prefix_key_search.result@stripped, 2006-12-08 17:41:33+01:00, jmiller@stripped +44 -0
    Test case for Bug #20353  Prefix key search return incorrect results for ignorable characters

  mysql-test/r/prefix_key_search.result@stripped, 2006-12-08 17:41:33+01:00, jmiller@stripped +0 -0

  mysql-test/t/prefix_key_search.test@stripped, 2006-12-08 17:41:22+01:00, jmiller@stripped +527 -0
    Test case for Bug #20353  Prefix key search return incorrect results for ignorable characters

  mysql-test/t/prefix_key_search.test@stripped, 2006-12-08 17:41:22+01:00, jmiller@stripped +0 -0

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	jmiller
# Host:	ndb08.mysql.com
# Root:	/data2/mysql-5.1-new-rpl
--- New file ---
+++ mysql-test/r/prefix_key_search.result	06/12/08 17:41:33
Warnings:
Note	1051	Unknown table 't1'
CREATE TABLE t1 (a varchar(128)) character set utf8 collate utf8_unicode_ci;
"Full Row Count"
SELECT COUNT(*) FROM t1;
COUNT(*)
444

"Count w/o key where a='aaaa';"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
109

"Count w/ Perfix Key (a(1))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
1

"Count w/ Perfix Key (a(2))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
1

"Count w/ Perfix Key (a(3))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
1

"Count w/ Perfix Key (a(4))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
1

"Count w/ Perfix Key (a(5))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
77

"Count w/ Full Key"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
COUNT(*)
109

DROP TABLE t1;

--- New file ---
+++ mysql-test/t/prefix_key_search.test	06/12/08 17:41:22
############################################
# Author: JBM
# Date: 07-12-2006
# Purpose: Bug #20353 Prefix key search return 
#          incorrect results for ignorable characters
##############################################

--disable_query_log
DROP TABLE IF EXISTS t1;
--enable_query_log

# Create utf8 based table
CREATE TABLE t1 (a varchar(128)) character set utf8 collate utf8_unicode_ci;

# Load all the which does not have weight
# [.0000.0000.0000.0000]
# ftp://ftp.unicode.org/Public/UCA/latest/allkeys.txt

--disable_query_log
INSERT INTO t1 VALUES ('aaaa');
INSERT INTO t1 VALUES (concat(0x01,'aaaa'));
INSERT INTO t1 VALUES (concat(0x02,'aaaa'));
INSERT INTO t1 VALUES (concat(0x03,'aaaa'));
INSERT INTO t1 VALUES (concat(0x04,'aaaa'));
INSERT INTO t1 VALUES (concat(0x05,'aaaa'));
INSERT INTO t1 VALUES (concat(0x06,'aaaa'));
INSERT INTO t1 VALUES (concat(0x07,'aaaa'));
INSERT INTO t1 VALUES (concat(0x08,'aaaa'));
INSERT INTO t1 VALUES (concat(0x0E,'aaaa'));
INSERT INTO t1 VALUES (concat(0x0F,'aaaa'));
INSERT INTO t1 VALUES (concat(0x11,'aaaa'));
INSERT INTO t1 VALUES (concat(0x12,'aaaa'));
INSERT INTO t1 VALUES (concat(0x13,'aaaa'));
INSERT INTO t1 VALUES (concat(0x14,'aaaa'));
INSERT INTO t1 VALUES (concat(0x15,'aaaa'));
INSERT INTO t1 VALUES (concat(0x16,'aaaa'));
INSERT INTO t1 VALUES (concat(0x17,'aaaa'));
INSERT INTO t1 VALUES (concat(0x18,'aaaa'));
INSERT INTO t1 VALUES (concat(0x19,'aaaa'));
INSERT INTO t1 VALUES (concat(0x1A,'aaaa'));
INSERT INTO t1 VALUES (concat(0x1B,'aaaa'));
INSERT INTO t1 VALUES (concat(0x1C,'aaaa'));
INSERT INTO t1 VALUES (concat(0x1D,'aaaa'));
INSERT INTO t1 VALUES (concat(0x1E,'aaaa'));
INSERT INTO t1 VALUES (concat(0x1F,'aaaa'));
INSERT INTO t1 VALUES (concat(0x7F,'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0081 using utf8), 'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0080 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0081 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0082 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0083 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0084 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0085 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0086 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0087 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0088 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0089 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x008A using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x008B using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x008C using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x008E using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x008F using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0090 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0091 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0092 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0093 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0094 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0095 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0096 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0097 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0098 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x0099 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x009A using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x009B using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x009C using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x009D using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x009E using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x009F using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(0x070F,'aaaa'));
INSERT INTO t1 VALUES (concat(0x180B,'aaaa'));
INSERT INTO t1 VALUES (concat(0x180C,'aaaa'));
INSERT INTO t1 VALUES (concat(0x180D,'aaaa'));
INSERT INTO t1 VALUES (concat(0x180E,'aaaa'));
INSERT INTO t1 VALUES (concat(0x200B,'aaaa'));
INSERT INTO t1 VALUES (concat(0x200C,'aaaa'));
INSERT INTO t1 VALUES (concat(0x200D,'aaaa'));
INSERT INTO t1 VALUES (concat(0x200E,'aaaa'));
INSERT INTO t1 VALUES (concat(0x200F,'aaaa'));
INSERT INTO t1 VALUES (concat(0x202A,'aaaa'));
INSERT INTO t1 VALUES (concat(0x202B,'aaaa'));
INSERT INTO t1 VALUES (concat(0x202C,'aaaa'));
INSERT INTO t1 VALUES (concat(0x202D,'aaaa'));
INSERT INTO t1 VALUES (concat(0x202E,'aaaa'));
INSERT INTO t1 VALUES (concat(0x2060,'aaaa'));
INSERT INTO t1 VALUES (concat(0x206A,'aaaa'));
INSERT INTO t1 VALUES (concat(0x206B,'aaaa'));
INSERT INTO t1 VALUES (concat(0x206C,'aaaa'));
INSERT INTO t1 VALUES (concat(0x206D,'aaaa'));
INSERT INTO t1 VALUES (concat(0x206E,'aaaa'));
INSERT INTO t1 VALUES (concat(0x206F,'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE00 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE01 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE02 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE03 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE04 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE05 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE06 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE07 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE08 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE09 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE0A using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE0B using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE0C using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE0D using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFE0E using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFEFF using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFFF9 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFFFA using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xFFFB using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D173 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D174 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D175 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D176 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D177 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D178 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D179 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0x1D17A using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0001,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0020,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0021,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0022,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0023,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0024,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0025,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0026,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0027,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0028,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0029,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE002A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE002B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE002C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE002D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE002F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0030,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0031,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0032,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0033,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0034,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0035,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0036,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0037,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0038,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0039,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE003A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE003B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE003C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE003D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE003E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE003F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0040,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0041,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0042,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0043,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0044,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0045,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0046,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0047,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0048,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0049,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE004A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE004B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE004C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE004D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE004E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE004F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0050,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0051,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0052,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0053,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0054,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0055,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0056,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0057,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0058,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0059,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE005A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE005B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE005C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE005D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE005E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE005F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0060,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0061,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0062,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0063,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0064,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0065,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0066,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0067,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0068,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0069,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE006A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE006B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE006C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE006D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE006E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE006F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0070,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0071,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0072,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0073,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0074,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0075,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0076,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0077,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0078,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0079,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE007A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE007B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE007C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE007D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE007E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE007F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0100,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0101,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0102,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0103,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0104,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0105,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0106,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0107,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0108,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0109,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE010A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE010B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE010C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE010D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE010E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE010F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0110,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0111,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0112,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0113,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0114,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0115,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0116,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0117,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0118,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0119,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE011A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE011B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE011C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE011D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE011E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE011F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0120,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0121,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0122,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0123,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0124,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0125,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0126,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0127,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0128,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0129,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE012A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE012B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE012C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE012D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE012E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE012F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0130,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0131,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0132,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0133,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0134,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0135,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0136,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0137,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0138,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0139,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE013A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE013B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE013C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE013D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE013E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE013F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0140,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0141,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0142,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0143,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0144,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0145,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0146,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0147,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0148,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0149,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE014A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE014B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE014C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE014D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE014E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE014F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0150,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0151,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0152,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0153,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0154,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0155,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0156,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0157,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0158,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0159,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE015A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE015B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE015C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE015D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE015E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE015F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0160,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0161,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0162,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0163,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0164,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0165,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0166,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0167,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0168,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0169,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE016A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE016B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE016C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE016D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE016E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE016F,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0170,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0171,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0172,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0173,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0174,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0175,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0176,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0177,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0178,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE0179,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE017A,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE017B,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE017C,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE017D,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE017E,'aaaa'));
INSERT INTO t1 VALUES (concat(0xE017F,'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0180 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0181 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0182 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0183 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0184 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0185 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0186 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0187 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0188 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0189 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE018A using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE018B using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE018C using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE018D using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE018E using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE018F using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0190 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0191 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0192 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0193 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0194 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0195 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0196 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0197 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0198 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE0199 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE019A using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE019B using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE019C using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE019D using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE019E using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE019F using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A0 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A1 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A2 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A3 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A4 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A5 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A6 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A7 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A8 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01A9 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01AA using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01AB using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01AC using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01AD using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01AE using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01AF using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B0 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B1 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B2 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B3 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B4 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B5 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B6 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B7 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B8 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01B9 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01BA using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01BB using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01BC using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01BD using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01BE using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01BF using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C0 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C1 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C2 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C3 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C4 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C5 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C6 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C7 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C8 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01C9 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01CA using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01CB using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01CC using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01CD using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01CE using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01CF using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D0 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D1 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D2 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D3 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D4 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D5 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D6 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D7 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D8 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01D9 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01DA using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01DB using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01DC using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01DD using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01DE using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01DF using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E0 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E1 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E2 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E3 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E4 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E5 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E6 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E7 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E8 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01E9 using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01EA using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01EB using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01EC using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01ED using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01EE using utf8),'aaaa'));
INSERT INTO t1 VALUES (concat(convert(_ucs2 0xE01EF using utf8),'aaaa'));
--enable_query_log


--echo "Full Row Count"
SELECT COUNT(*) FROM t1;
--echo 
#SELECT a, hex(a) FROM t1;

--echo "Count w/o key where a='aaaa';"
#SELECT a, hex(a) FROM t1 WHERE a='aaaa';
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

--disable_query_log
ALTER TABLE t1 ADD KEY key_a (a(1));
--enable_query_log
--echo "Count w/ Perfix Key (a(1))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

--disable_query_log
ALTER TABLE t1 DROP KEY key_a;
ALTER TABLE t1 ADD KEY key_a (a(2));
--enable_query_log
--echo "Count w/ Perfix Key (a(2))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

--disable_query_log
ALTER TABLE t1 DROP KEY key_a;
ALTER TABLE t1 ADD KEY key_a (a(3));
--enable_query_log
--echo "Count w/ Perfix Key (a(3))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

--disable_query_log
ALTER TABLE t1 DROP KEY key_a;
ALTER TABLE t1 ADD KEY key_a (a(4));
--enable_query_log
--echo "Count w/ Perfix Key (a(4))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

--disable_query_log
ALTER TABLE t1 DROP KEY key_a;
ALTER TABLE t1 ADD KEY key_a (a(5));
--enable_query_log
--echo "Count w/ Perfix Key (a(5))"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

--disable_query_log
ALTER TABLE t1 DROP KEY key_a;
ALTER TABLE t1 ADD KEY (a);
--enable_query_log
--echo "Count w/ Full Key"
SELECT COUNT(*) FROM t1 WHERE a='aaaa';
--echo 

# Test cleanup
DROP TABLE t1;

# End of 5.1 test case

Thread
bk commit into 5.1 tree (jmiller:1.2376) BUG#20353Jonathan Miller8 Dec