~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Monty Taylor
  • Date: 2008-09-06 00:05:54 UTC
  • mfrom: (377.1.5 drizzle)
  • Revision ID: monty@inaugust.com-20080906000554-lvjbntm1d6jgcqt4
Merged in from brian.

Show diffs side-by-side

added added

removed removed

Lines of Context:
248
248
column_type     group_concat(table_schema, '.', table_name)     num
249
249
varchar(20)     information_schema.PLUGINS      1
250
250
varchar(27)     information_schema.COLUMNS      1
251
 
create table t1(f1 char(1) not null, f2 char(9) not null)
252
 
default character set utf8;
 
251
create table t1(f1 char(1) not null, f2 char(9) not null);
253
252
select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
254
253
information_schema.columns where table_schema='test' and table_name = 't1';
255
254
CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH
256
 
1       4
257
 
9       36
 
255
1       1
 
256
9       9
258
257
drop table t1;
259
258
set @a:= '.';
260
259
create table t1(f1 char(5));