← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to tests/r/data_dictionary_like_info.result

  • Committer: Padraig O'Sullivan
  • Date: 2010-04-17 01:38:47 UTC
  • mfrom: (1237.9.238 bad-staging)
  • Revision ID: osullivan.padraig@gmail.com-20100417013847-ibjioqsfbmf5yg4g
Merge trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/data_dictionary_like_info.result
1
1
DROP TABLE IF EXISTS t0,t1,t2,t3,t4,t5;
2
 
DROP SCHEMA IF EXISTS data_dictionary;
3
2
select count(*) from data_dictionary.SCHEMAS where schema_name > 'm';
4
3
count(*)
5
4
#
11
10
test
12
11
show databases;
13
12
Database
14
 
data_dictionary
15
 
information_schema
 
13
DATA_DICTIONARY
 
14
INFORMATION_SCHEMA
16
15
mysql
17
16
test
18
17
create database mysqltest;
41
40
select * from data_dictionary.COLUMNS where table_name="t1"
42
41
and column_name= "a";
43
42
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     COLUMN_TYPE     ORDINAL_POSITION        COLUMN_DEFAULT  COLUMN_DEFAULT_IS_NULL  COLUMN_DEFAULT_UPDATE   IS_NULLABLE     IS_INDEXED      IS_USED_IN_PRIMARY      IS_UNIQUE       IS_MULTI        IS_FIRST_IN_MULTI       INDEXES_FOUND_IN        DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   COLLATION_NAME  COLUMN_COMMENT
44
 
mysqltest       t1      a       INTEGER 0               TRUE            TRUE    FALSE   FALSE   FALSE   FALSE   FALSE   0       INTEGER 0       0       0       0               
 
43
mysqltest       t1      a       INTEGER 0       NULL    TRUE            TRUE    FALSE   FALSE   FALSE   FALSE   FALSE   0       INTEGER 0       0       0       0               
45
44
select table_name, column_name from data_dictionary.columns 
46
45
where table_schema = 'mysqltest' and table_name = 't1';
47
46
table_name      column_name
138
137
drop table t1;
139
138
create table t1 (a int not null, b int);
140
139
use data_dictionary;
141
 
select column_name, column_default from columns
 
140
select column_name, column_default,column_default_is_null from columns
142
141
where table_schema='test' and table_name='t1';
143
 
column_name     column_default
144
 
a       
145
 
b       
 
142
column_name     column_default  column_default_is_null
 
143
a       NULL    FALSE
 
144
b       NULL    TRUE
146
145
use test;
147
146
show columns from t1;
148
147
Field   Type    Null    Default Default_is_NULL On_Update
192
191
 or DATA_TYPE = 'varchar')
193
192
group by DATA_TYPE order by DATA_TYPE, num;
194
193
DATA_TYPE       group_concat(table_schema, '.', table_name)     num
195
 
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.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_PART        133
 
194
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.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_PART        145
196
195
Warnings:
197
196
Warning 1260    1 line(s) were cut by GROUP_CONCAT()
198
197
create table t1(f1 char(1) not null, f2 char(9) not null);
247
246
table_name      column_name
248
247
SELECT MAX(table_name) FROM data_dictionary.tables;
249
248
MAX(table_name)
250
 
TABLE_CONSTRAINTS
 
249
VIEW_TABLE_USAGE
251
250
SELECT table_name from data_dictionary.tables
252
251
WHERE table_name=(SELECT MAX(table_name)
253
252
FROM data_dictionary.tables);
254
253
table_name
255
 
TABLE_CONSTRAINTS
 
254
VIEW_TABLE_USAGE
256
255
create table t1 (f1 int);
257
256
create table t2 (f1 int, f2 int);
258
257
select table_name from data_dictionary.tables
300
299
f7 datetime not null,
301
300
f8 datetime default '2006-01-01'
302
301
);
303
 
select column_default from data_dictionary.columns where table_name= 't1';
304
 
column_default
305
 
 
306
 
 
307
 
 
308
 
 
309
 
 
310
 
10
311
 
10
312
 
2006-01-01
 
302
select column_name,column_default,column_default_is_null from data_dictionary.columns where table_name= 't1';
 
303
column_name     column_default  column_default_is_null
 
304
f1      NULL    TRUE
 
305
f2      NULL    FALSE
 
306
f3              FALSE
 
307
f4      NULL    TRUE
 
308
f5      NULL    FALSE
 
309
f6      10      FALSE
 
310
f7      NULL    FALSE
 
311
f8      2006-01-01      FALSE
313
312
show columns from t1;
314
313
Field   Type    Null    Default Default_is_NULL On_Update
315
314
f1      VARCHAR TRUE            TRUE    
318
317
f4      VARCHAR TRUE            TRUE    
319
318
f5      BIGINT  FALSE           FALSE   
320
319
f6      BIGINT  FALSE   10      FALSE   
321
 
f7      DATETIME        FALSE   10      FALSE   
 
320
f7      DATETIME        FALSE           FALSE   
322
321
f8      DATETIME        TRUE    2006-01-01      FALSE   
323
322
drop table t1;
324
323
SET max_heap_table_size = DEFAULT;
340
339
select * from `data_dictionary`.`INDEXES` where `TABLE_NAME` = NULL;
341
340
TABLE_SCHEMA    TABLE_NAME      INDEX_NAME      IS_USED_IN_PRIMARY      IS_UNIQUE       IS_NULLABLE     KEY_LENGTH      INDEX_TYPE      INDEX_COMMENT
342
341
select * from data_dictionary.schemas where schema_name = NULL;
343
 
SCHEMA_NAME     DEFAULT_COLLATION_NAME
 
342
SCHEMA_NAME     DEFAULT_COLLATION_NAME  SCHEMA_CREATION_TIME    SCHEMA_UPDATE_TIME
344
343
select * from data_dictionary.tables where table_schema = NULL;
345
 
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_COMMENT
 
344
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_CREATION_TIME     TABLE_UPDATE_TIME       TABLE_COMMENT
346
345
select * from data_dictionary.tables where table_name = NULL;
347
 
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_COMMENT
 
346
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_CREATION_TIME     TABLE_UPDATE_TIME       TABLE_COMMENT
348
347
#
349
348
# Test that the query is visible to self and others.
350
349
#