← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/data_dictionary_like_info.result

  • Committer: Brian Aker
  • Date: 2010-02-16 01:41:47 UTC
  • mfrom: (1273.13.66 build)
  • Revision ID: brian@gaz-20100216014147-d14la0yrezusgisn
Merge of Brian stuff

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/data_dictionary_like_info.result
22
22
select * from data_dictionary.COLUMNS where table_name="t1"
23
23
and column_name= "a";
24
24
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        COLUMN_DEFAULT  IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   COLLATION_NAME  COLUMN_COMMENT
25
 
mysqltest       t1      a       0       0       TRUE    4       #       0       0       0       #       #
 
25
mysqltest       t1      a       0       0       TRUE    INTEGER #       0       0       0       #       #
26
26
select table_name, column_name from data_dictionary.columns 
27
27
where table_schema = 'mysqltest' and table_name = 't1';
28
28
table_name      column_name
40
40
where table_schema="data_dictionary" and table_name="COLUMNS" and
41
41
(column_name="character_set_name" or column_name="collation_name");
42
42
DATA_TYPE
43
 
1
 
43
VARCHAR
44
44
select TABLE_TYPE from data_dictionary.tables where 
45
45
table_schema="data_dictionary" and table_name="COLUMNS";
46
46
TABLE_TYPE
55
55
select table_name, column_name, DATA_TYPE from data_dictionary.columns
56
56
where DATA_TYPE = 'datetime';
57
57
table_name      column_name     DATA_TYPE
 
58
INNODB_TRX      trx_started     DATETIME
 
59
INNODB_TRX      trx_wait_started        DATETIME
58
60
SELECT COUNT(*) FROM DATA_DICTIONARY.TABLES A
59
61
WHERE NOT EXISTS 
60
62
(SELECT * FROM DATA_DICTIONARY.COLUMNS B
96
98
from data_dictionary.columns
97
99
where table_name='t1';
98
100
column_name     DATA_TYPE       CHARACTER_OCTET_LENGTH  CHARACTER_MAXIMUM_LENGTH
99
 
f1      2       0       0
100
 
f2      2       0       0
 
101
f1      BLOB    0       0
 
102
f2      BLOB    0       0
101
103
drop table t1;
102
104
create table t1(f1 int, f2 int, f3 BIGINT, f4 int,
103
105
f5 BIGINT, f6 int, f7 int);
156
158
 or DATA_TYPE = 'varchar')
157
159
group by DATA_TYPE order by DATA_TYPE, num;
158
160
DATA_TYPE       group_concat(table_schema, '.', table_name)     num
 
161
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.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_dictionary.LOCAL_TABLE_NAMES,data_dictionary.LOCAL_TABLE_STATUS,data_dict        101
 
162
Warnings:
 
163
Warning 1260    1 line(s) were cut by GROUP_CONCAT()
159
164
create table t1(f1 char(1) not null, f2 char(9) not null);
160
165
select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
161
166
data_dictionary.columns where table_schema='test' and table_name = 't1';