← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/varchar.inc

  • Committer: Brian Aker
  • Date: 2008-12-18 21:36:23 UTC
  • mfrom: (685.4.10 enable-tests)
  • Revision ID: brian@tangent.org-20081218213623-nsgvfbcax1z6epx4
Merge from Jay

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/varchar.inc
208
208
create table t1 (v varchar(10), c char(10), t text, key(v(5)), key(c(5)), key(t(5)));
209
209
show create table t1;
210
210
drop table t1;
211
 
create table t1 (v char(10) character set utf8);
 
211
create table t1 (v char(10));
212
212
show create table t1;
213
213
drop table t1;
214
214
 
221
221
#
222
222
# Test long varchars
223
223
#
224
 
 
225
 
create table t1 (v varchar(65530), key(v(10)));
226
 
insert into t1 values(repeat('a',65530));
227
 
select length(v) from t1 where v=repeat('a',65530);
228
 
drop table t1;
 
224
# @TODO The below fails because it assumes latin1
 
225
# as the charset.  Possibly re-enable a similar test
 
226
# for UTF8-only in future
 
227
#create table t1 (v varchar(65530), key(v(10)));
 
228
#insert into t1 values(repeat('a',65530));
 
229
#select length(v) from t1 where v=repeat('a',65530);
 
230
#drop table t1;
229
231
 
230
232
#
231
233
# Bug #9489: problem with hash indexes