← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/collation_dictionary/tests/t/data_dictionary.test

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
Merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/collation_dictionary/tests/t/data_dictionary.test
1
1
# Drizzle's data dictionary.
2
2
 
3
 
CREATE SCHEMA data_dictionary;
4
 
 
5
3
use data_dictionary;
6
4
 
7
5
show create table CHARACTER_SETS ;
10
8
SELECT * FROM character_sets ORDER BY CHARACTER_SET_NAME;
11
9
SELECT * FROM collations ORDER BY COLLATION_NAME;
12
10
 
13
 
# Slap tests for concurrency
14
 
CREATE SCHEMA drizzleslap;
15
 
 
16
 
#--exec $DRIZZLE_SLAP --silent  --concurrency=5 --iterations=20  --query="select * from data_dictionary.character_sets" --delimiter=";"
17
 
#--exec $DRIZZLE_SLAP --silent  --concurrency=5 --iterations=20  --query="select * from data_dictionary.collations" --delimiter=";"
18
 
 
19
 
DROP SCHEMA drizzleslap;
20
 
DROP SCHEMA data_dictionary;
 
11
#
 
12
# do a query on the CHARACTER_SET table in I_S 
 
13
#
 
14
SELECT *
 
15
FROM data_dictionary.character_sets
 
16
ORDER BY character_set_name;
 
17
 
 
18
#
 
19
# perform a query on the COLLATIONS table
 
20
#
 
21
SELECT *
 
22
FROM data_dictionary.collations
 
23
ORDER BY collation_name;
 
24
 
 
25
 
 
26
# Test for data_dictionary.CHARACTER_SETS &
 
27
select * from data_dictionary.CHARACTER_SETS
 
28
where CHARACTER_SET_NAME like 'latin1%';
 
29
 
 
30
# Test for data_dictionary.COLLATIONS &
 
31
 
 
32
--replace_column 5 #
 
33
select * from data_dictionary.COLLATIONS
 
34
where COLLATION_NAME like 'latin1%';