Attachment #104442 for bug #144621

View | Details | Raw Unified | Return to bug 144621
Collapse All | Expand All

Lines 240-247 Link Here

(-)/usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/ctype_utf8.result (-2 / +2 lines)
240	hex(s1)	240	hex(s1)
241	41	241	41
242	drop table t1;	242	drop table t1;
243	create table t1 (a text character set utf8, primary key(a(360)));	243	create table t1 (a text character set utf8, primary key(a(3600)));
244	ERROR 42000: Specified key was too long; max key length is 1000 bytes	244	ERROR 42000: Specified key was too long; max key length is 3072 bytes
245	CREATE TABLE t1 ( a varchar(10) ) CHARACTER SET utf8;	245	CREATE TABLE t1 ( a varchar(10) ) CHARACTER SET utf8;
246	INSERT INTO t1 VALUES ( 'test' );	246	INSERT INTO t1 VALUES ( 'test' );
247	SELECT a.a, b.a FROM t1 a, t1 b WHERE a.a = b.a;	247	SELECT a.a, b.a FROM t1 a, t1 b WHERE a.a = b.a;

Lines 164-170 Link Here

(-)/usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/ctype_utf8.test (-1 / +1 lines)
164	# UTF8 breaks primary keys for cols > 333 characters	164	# UTF8 breaks primary keys for cols > 333 characters
165	#	165	#
166	--error 1071	166	--error 1071
167	create table t1 (a text character set utf8, primary key(a(360)));	167	create table t1 (a text character set utf8, primary key(a(3600)));
168		168
169		169
170	#	170	#




Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
drop table t1;
CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e));
ERROR 42000: Specified key was too long; max key length is 3072 bytes
CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255));
ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);
ERROR 42000: Specified key was too long; max key length is 3072 bytes
DROP TABLE t1;
CREATE TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a));
INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4);

drop table t1;
create table t1 (v varchar(65530), key(v));
Warnings:
Warning	1071	Specified key was too long; max key length is 3072 bytes
drop table if exists t1;
create table t1 (v varchar(65536));
Warnings:

Lines 337-344 Link Here

(-)/usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/myisam.test (-2 / +2 lines)
337	#	337	#
338		338
339	--error 1071	339	--error 1071
340	CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255), KEY t1 (a, b, c, d, e));	340	CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e));
341	CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255));	341	CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255));
342	--error 1071	342	--error 1071
343	ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);	343	ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);
344	DROP TABLE t1;	344	DROP TABLE t1;




a	1
hello	1
drop table t1;
create table t1 (a text, unique (a(3100)));
ERROR 42000: Specified key was too long; max key length is 3072 bytes
create table t1 (a text, key (a(3100)));
Warnings:
Warning	1071	Specified key was too long; max key length is 3072 bytes
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` text,
  KEY `a` (`a`(3072))
) ENGINE=MyISAM DEFAULT CHARSET=latin1
drop table t1;
CREATE TABLE t1 (

Lines 132-139 Link Here

(-)/usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/type_blob.test (-2 / +2 lines)
132	drop table t1;	132	drop table t1;
133		133
134	-- error 1071	134	-- error 1071
135	create table t1 (a text, unique (a(2100))); # should give an error	135	create table t1 (a text, unique (a(3100))); # should give an error
136	create table t1 (a text, key (a(2100))); # key is auto-truncated	136	create table t1 (a text, key (a(3100))); # key is auto-truncated
137	show create table t1;	137	show create table t1;
138	drop table t1;	138	drop table t1;

Return to bug 144621

Lines 322-332 Link Here

(-)/usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/myisam.result (-5 / +5 lines)
322	Table Op Msg_type Msg_text	322	Table Op Msg_type Msg_text
323	test.t1 check status OK	323	test.t1 check status OK
324	drop table t1;	324	drop table t1;
325	CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255), KEY t1 (a, b, c, d, e));	325	CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e));
326	ERROR 42000: Specified key was too long; max key length is 1000 bytes	326	ERROR 42000: Specified key was too long; max key length is 3072 bytes
327	CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255));	327	CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255));
328	ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);	328	ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);
329	ERROR 42000: Specified key was too long; max key length is 1000 bytes	329	ERROR 42000: Specified key was too long; max key length is 3072 bytes
330	DROP TABLE t1;	330	DROP TABLE t1;
331	CREATE TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a));	331	CREATE TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a));
332	INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4);	332	INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4);
Lines 1668-1674 Link Here
1668	drop table t1;	1668	drop table t1;
1669	create table t1 (v varchar(65530), key(v));	1669	create table t1 (v varchar(65530), key(v));
1670	Warnings:	1670	Warnings:
1671	Warning 1071 Specified key was too long; max key length is 1000 bytes	1671	Warning 1071 Specified key was too long; max key length is 3072 bytes
1672	drop table if exists t1;	1672	drop table if exists t1;
1673	create table t1 (v varchar(65536));	1673	create table t1 (v varchar(65536));
1674	Warnings:	1674	Warnings:

Lines 356-371 Link Here

(-)/usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/type_blob.result (-5 / +5 lines)
356	a 1	356	a 1
357	hello 1	357	hello 1
358	drop table t1;	358	drop table t1;
359	create table t1 (a text, unique (a(2100)));	359	create table t1 (a text, unique (a(3100)));
360	ERROR 42000: Specified key was too long; max key length is 1000 bytes	360	ERROR 42000: Specified key was too long; max key length is 3072 bytes
361	create table t1 (a text, key (a(2100)));	361	create table t1 (a text, key (a(3100)));
362	Warnings:	362	Warnings:
363	Warning 1071 Specified key was too long; max key length is 1000 bytes	363	Warning 1071 Specified key was too long; max key length is 3072 bytes
364	show create table t1;	364	show create table t1;
365	Table Create Table	365	Table Create Table
366	t1 CREATE TABLE `t1` (	366	t1 CREATE TABLE `t1` (
367	`a` text,	367	`a` text,
368	KEY `a` (`a`(1000))	368	KEY `a` (`a`(3072))
369	) ENGINE=MyISAM DEFAULT CHARSET=latin1	369	) ENGINE=MyISAM DEFAULT CHARSET=latin1
370	drop table t1;	370	drop table t1;
371	CREATE TABLE t1 (	371	CREATE TABLE t1 (