← 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-19 23:07:45 UTC
  • mto: (1273.13.97 build)
  • mto: This revision was merged to the branch mainline in revision 1309.
  • Revision ID: brian@gaz-20100219230745-cmurfbxj845it9z7
This remove the original info_schema system for the server. More still to
cut, but we are on our way.

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     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
25
 
mysqltest       t1      a       INTEGER 0       0       TRUE    #       TRUE    INTEGER 0       #       #       0       utf8_general_ci 
 
25
mysqltest       t1      a       INTEGER 0               TRUE    #       TRUE    INTEGER 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
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
60
58
SELECT COUNT(*) FROM DATA_DICTIONARY.TABLES A
61
59
WHERE NOT EXISTS 
62
60
(SELECT * FROM DATA_DICTIONARY.COLUMNS B
120
118
select column_name, column_default from columns
121
119
where table_schema='test' and table_name='t1';
122
120
column_name     column_default
123
 
a       0
124
 
b       0
 
121
a       
 
122
b       
125
123
use test;
126
124
drop table t1;
127
125
alter database data_dictionary;
268
266
);
269
267
select column_default from data_dictionary.columns where table_name= 't1';
270
268
column_default
271
 
0
272
 
0
273
 
0
274
 
0
275
 
0
 
269
 
 
270
 
 
271
 
 
272
 
 
273
 
276
274
10
277
275
10
278
276
2006-01-01