← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

  • Committer: Brian Aker
  • Date: 2009-02-12 22:45:08 UTC
  • Revision ID: brian@tangent.org-20090212224508-mrd9jwgn1zjdpqdk
Minor refactoring (we will need to disconnect the code from the include
file).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/information_schema.test
33
33
 
34
34
show tables like 't%';
35
35
--replace_column 8 # 12 # 13 #
36
 
show table status;
 
36
#show table status;
37
37
show full columns from t3 like "a%";
38
38
select * from information_schema.COLUMNS where table_name="t1"
39
39
and column_name= "a";
55
55
 
56
56
select * from information_schema.CHARACTER_SETS
57
57
where CHARACTER_SET_NAME like 'latin1%';
58
 
SHOW CHARACTER SET LIKE 'latin1%';
59
58
 
60
59
# Test for information_schema.COLLATIONS &
61
60
# SHOW COLLATION
63
62
--replace_column 5 #
64
63
select * from information_schema.COLLATIONS
65
64
where COLLATION_NAME like 'latin1%';
66
 
--replace_column 5 #
67
 
SHOW COLLATION LIKE 'latin1%';
68
65
 
69
66
select * from information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
70
67
where COLLATION_NAME like 'latin1%';