← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/data_dictionary_like_info.test

  • Committer: Brian Aker
  • Date: 2010-02-25 07:54:52 UTC
  • mfrom: (1273.13.101 build)
  • Revision ID: brian@gaz-20100225075452-19eozreshbrerypu
Merge of all patches in build.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/data_dictionary_like_info.test
5
5
DROP TABLE IF EXISTS t0,t1,t2,t3,t4,t5;
6
6
DROP SCHEMA IF EXISTS data_dictionary;
7
7
--enable_warnings
8
 
CREATE SCHEMA data_dictionary;
9
8
 
10
9
--replace_column 1 #
11
10
select count(*) from data_dictionary.SCHEMAS where schema_name > 'm';
12
11
--replace_column 1 #
13
12
select count(*) from data_dictionary.schemas;
14
 
#show databases like 't%';
15
 
#show databases;
 
13
show databases like 't%';
 
14
show databases;
16
15
 
17
16
# Test for data_dictionary.tables &
18
17
# show tables
28
27
select table_name from data_dictionary.TABLES
29
28
where table_schema = "mysqltest" and table_name like "t%";
30
29
 
31
 
#show tables like 't%';
 
30
show tables like 't%';
32
31
--replace_column 8 # 12 # 13 #
33
 
#show table status;
34
 
#show columns from t3 like "a%";
 
32
show table status;
 
33
show columns from t3 like "a%";
35
34
select * from data_dictionary.COLUMNS where table_name="t1"
36
35
and column_name= "a";
37
36
 
39
38
connection user3;
40
39
select table_name, column_name from data_dictionary.columns 
41
40
where table_schema = 'mysqltest' and table_name = 't1';
42
 
#show columns from mysqltest.t1;
 
41
show columns from mysqltest.t1;
43
42
connect (user4,localhost,mysqltest_3,,mysqltest);
44
43
connection user4;
45
44
connection default;
149
148
select column_name, column_default from columns
150
149
  where table_schema='test' and table_name='t1';
151
150
use test;
152
 
#show columns from t1;
 
151
show columns from t1;
153
152
drop table t1;
154
153
 
155
154
#
187
186
# Bug #12770 DESC cannot display the info. about temporary table
188
187
#
189
188
create temporary table t1(f1 int, index(f1));
190
 
#show columns from t1;
191
 
#describe t1;
192
 
#show indexes from t1;
 
189
show columns from t1;
 
190
describe t1;
 
191
show indexes from t1;
193
192
drop table t1;
194
193
 
195
194
#
334
333
  f8 datetime default '2006-01-01'
335
334
);
336
335
select column_default from data_dictionary.columns where table_name= 't1';
337
 
#show columns from t1;
 
336
show columns from t1;
338
337
drop table t1;
339
338
 
340
339
#
460
459
#
461
460
--replace_column 1 #
462
461
SELECT count(*) FROM data_dictionary.plugins;
463
 
 
464
 
--disable_warnings
465
 
DROP SCHEMA IF EXISTS data_dictionary;
466
 
--enable_warnings