← 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

Merging change info_schema changes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/data_dictionary_like_info.result
7
7
select count(*) from data_dictionary.schemas;
8
8
count(*)
9
9
#
 
10
show databases like 't%';
 
11
Database (t%)
 
12
test
 
13
show databases;
 
14
Database
 
15
data_dictionary
 
16
information_schema
 
17
mysql
 
18
test
10
19
create database mysqltest;
11
20
create table mysqltest.t1(a int, b VARCHAR(30), KEY string_data (b));
12
21
create table test.t2(a int);
19
28
table_name
20
29
t1
21
30
t4
 
31
show tables like 't%';
 
32
Tables_in_test (t%)
 
33
t2
 
34
t3
 
35
t5
 
36
show table status;
 
37
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
 
38
t2      InnoDB  0       DEFAULT 0       0       0       #       0       0       0       #       #       0       utf8_general_ci 0               
 
39
t3      InnoDB  0       DEFAULT 0       0       0       #       0       0       0       #       #       0       utf8_general_ci 0               
 
40
t5      InnoDB  0       DEFAULT 0       0       0       #       0       0       0       #       #       0       utf8_general_ci 0               
 
41
show columns from t3 like "a%";
 
42
Field   Type    Null    Default Default is NULL On Update
22
43
select * from data_dictionary.COLUMNS where table_name="t1"
23
44
and column_name= "a";
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_KEY      EXTRA   COLUMN_COMMENT
25
 
mysqltest       t1      a       0       0       TRUE    INTEGER #       0       0       0       #       #               
 
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
 
46
mysqltest       t1      a       INTEGER 0               TRUE            TRUE    INTEGER 0       0       0       0               
26
47
select table_name, column_name from data_dictionary.columns 
27
48
where table_schema = 'mysqltest' and table_name = 't1';
28
49
table_name      column_name
29
50
t1      a
30
51
t1      b
 
52
show columns from mysqltest.t1;
 
53
Field   Type    Null    Default Default is NULL On Update
 
54
a       INTEGER TRUE            TRUE    
 
55
b       VARCHAR TRUE            TRUE    
31
56
drop tables mysqltest.t4, mysqltest.t1, t2, t3, t5;
32
57
drop database mysqltest;
33
58
select * from data_dictionary.CHARACTER_SETS
55
80
select table_name, column_name, DATA_TYPE from data_dictionary.columns
56
81
where DATA_TYPE = 'datetime';
57
82
table_name      column_name     DATA_TYPE
58
 
INNODB_TRX      trx_started     DATETIME
59
 
INNODB_TRX      trx_wait_started        DATETIME
60
83
SELECT COUNT(*) FROM DATA_DICTIONARY.TABLES A
61
84
WHERE NOT EXISTS 
62
85
(SELECT * FROM DATA_DICTIONARY.COLUMNS B
120
143
select column_name, column_default from columns
121
144
where table_schema='test' and table_name='t1';
122
145
column_name     column_default
123
 
a       0
124
 
b       0
 
146
a       
 
147
b       
125
148
use test;
 
149
show columns from t1;
 
150
Field   Type    Null    Default Default is NULL On Update
 
151
a       INTEGER FALSE           FALSE   
 
152
b       INTEGER TRUE            TRUE    
126
153
drop table t1;
127
154
alter database data_dictionary;
128
155
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '' at line 1
143
170
use test;
144
171
drop table t1;
145
172
create temporary table t1(f1 int, index(f1));
 
173
show columns from t1;
 
174
Field   Type    Null    Default Default is NULL On Update
 
175
f1      INTEGER TRUE            TRUE    
 
176
describe t1;
 
177
Field   Type    Null    Default Default is NULL On Update
 
178
f1      INTEGER TRUE            TRUE    
 
179
show indexes from t1;
 
180
Table   Key_name        Seq_in_index    Column_name
 
181
t1      f1      0       f1
146
182
drop table t1;
147
183
create table t1(f1 varbinary(32), f2 varbinary(64));
148
184
select character_maximum_length, character_octet_length
158
194
 or DATA_TYPE = 'varchar')
159
195
group by DATA_TYPE order by DATA_TYPE, num;
160
196
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.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.INNODB_STATUS,        105
 
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        106
162
198
Warnings:
163
199
Warning 1260    1 line(s) were cut by GROUP_CONCAT()
164
200
create table t1(f1 char(1) not null, f2 char(9) not null);
268
304
);
269
305
select column_default from data_dictionary.columns where table_name= 't1';
270
306
column_default
271
 
0
272
 
0
273
 
0
274
 
0
275
 
0
 
307
 
 
308
 
 
309
 
 
310
 
 
311
 
276
312
10
277
313
10
278
314
2006-01-01
 
315
show columns from t1;
 
316
Field   Type    Null    Default Default is NULL On Update
 
317
f1      VARCHAR TRUE            TRUE    
 
318
f2      VARCHAR FALSE           FALSE   
 
319
f3      VARCHAR TRUE            FALSE   
 
320
f4      VARCHAR TRUE            TRUE    
 
321
f5      BIGINT  FALSE           FALSE   
 
322
f6      BIGINT  FALSE   10      FALSE   
 
323
f7      DATETIME        FALSE   10      FALSE   
 
324
f8      DATETIME        TRUE    2006-01-01      FALSE   
279
325
drop table t1;
280
326
SET max_heap_table_size = DEFAULT;
281
327
USE test;
288
334
WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';
289
335
TABLE_COLLATION
290
336
select * from data_dictionary.columns where table_schema = NULL;
291
 
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_KEY      EXTRA   COLUMN_COMMENT
 
337
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
292
338
select * from `data_dictionary`.`COLUMNS` where `TABLE_NAME` = NULL;
293
 
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_KEY      EXTRA   COLUMN_COMMENT
 
339
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
294
340
select * from `data_dictionary`.`INDEXES` where `TABLE_SCHEMA` = NULL;
295
341
TABLE_SCHEMA    TABLE_NAME      INDEX_NAME      IS_PRIMARY      IS_UNIQUE       IS_NULLABLE     KEY_LENGTH      INDEX_TYPE      INDEX_COMMENT
296
342
select * from `data_dictionary`.`INDEXES` where `TABLE_NAME` = NULL;