← Back to branch summary

~posulliv/drizzle/schema-less

« back to all changes in this revision

Viewing changes to tests/r/data_dictionary_like_info.result

  • Committer: Brian Aker
  • Date: 2010-03-02 07:03:12 UTC
  • mfrom: (1309.2.10 drizzle-build)
  • Revision ID: brian@gaz-20100302070312-u8xyk09u2970pgzp
Merge.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/data_dictionary_like_info.result
38
38
t3      InnoDB  0       DEFAULT 0       0       0       #       0       0       0       #       #       0       utf8_general_ci 0               
39
39
t5      InnoDB  0       DEFAULT 0       0       0       #       0       0       0       #       #       0       utf8_general_ci 0               
40
40
show columns from t3 like "a%";
41
 
Field   Type    Null    Default Default is NULL On Update
 
41
Field   Type    Null    Default Default_is_NULL On_Update
 
42
a       INTEGER TRUE            TRUE    
42
43
select * from data_dictionary.COLUMNS where table_name="t1"
43
44
and column_name= "a";
44
45
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     COLUMN_TYPE     ORDINAL_POSITION        COLUMN_DEFAULT  COLUMN_DEFAULT_IS_NULL  COLUMN_DEFAULT_UPDATE   IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   COLLATION_NAME  COLUMN_COMMENT
49
50
t1      a
50
51
t1      b
51
52
show columns from mysqltest.t1;
52
 
Field   Type    Null    Default Default is NULL On Update
 
53
Field   Type    Null    Default Default_is_NULL On_Update
53
54
a       INTEGER TRUE            TRUE    
54
55
b       VARCHAR TRUE            TRUE    
55
56
drop tables mysqltest.t4, mysqltest.t1, t2, t3, t5;
146
147
b       
147
148
use test;
148
149
show columns from t1;
149
 
Field   Type    Null    Default Default is NULL On Update
 
150
Field   Type    Null    Default Default_is_NULL On_Update
150
151
a       INTEGER FALSE           FALSE   
151
152
b       INTEGER TRUE            TRUE    
152
153
drop table t1;
170
171
drop table t1;
171
172
create temporary table t1(f1 int, index(f1));
172
173
show columns from t1;
173
 
Field   Type    Null    Default Default is NULL On Update
 
174
Field   Type    Null    Default Default_is_NULL On_Update
174
175
f1      INTEGER TRUE            TRUE    
175
176
describe t1;
176
177
Field   Type    Null    Default Default is NULL On Update
177
178
f1      INTEGER TRUE            TRUE    
178
179
show indexes from t1;
179
 
Table   Key_name        Seq_in_index    Column_name
180
 
t1      f1      0       f1
 
180
Table   Unique  Key_name        Seq_in_index    Column_name
 
181
t1      FALSE   f1      1       f1
181
182
drop table t1;
182
183
create table t1(f1 varbinary(32), f2 varbinary(64));
183
184
select character_maximum_length, character_octet_length
193
194
 or DATA_TYPE = 'varchar')
194
195
group by DATA_TYPE order by DATA_TYPE, num;
195
196
DATA_TYPE       group_concat(table_schema, '.', table_name)     num
196
 
VARCHAR data_dictionary.CHARACTER_SETS,data_dictionary.CHARACTER_SETS,data_dictionary.CHARACTER_SETS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.GLOBAL_STATEMENTS,data_dictionary.GLOBAL_STATEMENTS,data_dictionary.GLOBAL_STATUS,data_dictionary.GLOBAL_STATUS,data_dictionary.GLOBAL_VARIABLES,data_dictionary.GLOBAL_VARIABLES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_d        121
 
197
VARCHAR data_dictionary.CHARACTER_SETS,data_dictionary.CHARACTER_SETS,data_dictionary.CHARACTER_SETS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLLATIONS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.COLUMNS,data_dictionary.GLOBAL_STATEMENTS,data_dictionary.GLOBAL_STATEMENTS,data_dictionary.GLOBAL_STATUS,data_dictionary.GLOBAL_STATUS,data_dictionary.GLOBAL_VARIABLES,data_dictionary.GLOBAL_VARIABLES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEXES,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_dictionary.INDEX_PARTS,data_d        131
197
198
Warnings:
198
199
Warning 1260    1 line(s) were cut by GROUP_CONCAT()
199
200
create table t1(f1 char(1) not null, f2 char(9) not null);
312
313
10
313
314
2006-01-01
314
315
show columns from t1;
315
 
Field   Type    Null    Default Default is NULL On Update
 
316
Field   Type    Null    Default Default_is_NULL On_Update
316
317
f1      VARCHAR TRUE            TRUE    
317
318
f2      VARCHAR FALSE           FALSE   
318
319
f3      VARCHAR TRUE            FALSE