~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
10
10
SELECT * FROM character_sets ORDER BY CHARACTER_SET_NAME;
11
11
SELECT * FROM collations ORDER BY COLLATION_NAME;
12
12
 
 
13
#
 
14
# do a query on the CHARACTER_SET table in I_S 
 
15
#
 
16
SELECT *
 
17
FROM data_dictionary.character_sets
 
18
ORDER BY character_set_name;
 
19
 
 
20
#
 
21
# perform a query on the COLLATIONS table
 
22
#
 
23
SELECT *
 
24
FROM data_dictionary.collations
 
25
ORDER BY collation_name;
 
26
 
 
27
 
13
28
# Slap tests for concurrency
14
29
CREATE SCHEMA drizzleslap;
15
30
 
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=";"
 
31
--exec $DRIZZLE_SLAP --silent  --concurrency=5 --iterations=20  --query="select * from data_dictionary.character_sets" --delimiter=";"
 
32
--exec $DRIZZLE_SLAP --silent  --concurrency=5 --iterations=20  --query="select * from data_dictionary.collations" --delimiter=";"
 
33
 
 
34
# Test for data_dictionary.CHARACTER_SETS &
 
35
select * from data_dictionary.CHARACTER_SETS
 
36
where CHARACTER_SET_NAME like 'latin1%';
 
37
 
 
38
# Test for data_dictionary.COLLATIONS &
 
39
 
 
40
--replace_column 5 #
 
41
select * from data_dictionary.COLLATIONS
 
42
where COLLATION_NAME like 'latin1%';
 
43
 
18
44
 
19
45
DROP SCHEMA drizzleslap;
20
46
DROP SCHEMA data_dictionary;