← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to tests/t/data_dictionary_like_info.test

  • 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/t/data_dictionary_like_info.test
3
3
 
4
4
--disable_warnings
5
5
DROP TABLE IF EXISTS t0,t1,t2,t3,t4,t5;
6
 
DROP SCHEMA IF EXISTS data_dictionary;
7
6
--enable_warnings
8
7
 
9
8
--replace_column 1 #
145
144
#
146
145
create table t1 (a int not null, b int);
147
146
use data_dictionary;
148
 
select column_name, column_default from columns
 
147
select column_name, column_default,column_default_is_null from columns
149
148
  where table_schema='test' and table_name='t1';
150
149
use test;
151
150
show columns from t1;
332
331
  f7 datetime not null,
333
332
  f8 datetime default '2006-01-01'
334
333
);
335
 
select column_default from data_dictionary.columns where table_name= 't1';
 
334
select column_name,column_default,column_default_is_null from data_dictionary.columns where table_name= 't1';
336
335
show columns from t1;
337
336
drop table t1;
338
337