← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/randgen_queries.test

https://launchpad.net/bugs/586348
fix pthread atomics. operator precedence is important. The unit test now passes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/randgen_queries.test
45
45
key (`col_enum_key` )) ENGINE=innodb;
46
46
set AUTOCOMMIT=OFF;
47
47
 
48
 
# bookkeeping query in Executor/Drizzle.pm in randgen
49
 
select SQL_BIG_RESULT table_schema, 
 
48
#
 
49
select table_schema, 
50
50
       table_name, 
51
51
       CASE WHEN table_type = 'STANDARD' THEN 'table' 
52
52
            WHEN table_type = 'FUNCTION' then 'function' 
53
53
       ELSE 'misc' END, 
54
54
       column_name,
55
 
       CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary' 
56
 
             WHEN IS_INDEXED = 'YES' THEN 'indexed' 
 
55
       CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary' 
 
56
             WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
57
57
       ELSE 'indexed' END 
58
58
       FROM data_dictionary.tables INNER JOIN
59
 
            data_dictionary.columns USING(table_schema, table_name) ORDER BY table_schema, table_name limit 20;
60
 
# end bookkeeping test
61
 
 
62
 
# bookkeeping query in Executor/Drizzle.pm in randgen - variant 1
63
 
# test of non-DATA_DICTIONARY / INFORMATION_SCHEMA tables
64
 
CREATE SCHEMA randgen_query_test;
65
 
USE randgen_query_test;
66
 
CREATE TABLE t1 (a INT);
67
 
CREATE TABLE t2 LIKE t1;
68
 
CREATE TABLE t3 LIKE t1;
69
 
CREATE TABLE t4 (b CHAR(500));
70
 
CREATE TABLE t5 LIKE t4;
71
 
 
72
 
select SQL_BIG_RESULT table_schema,
73
 
       table_name,
74
 
       CASE WHEN table_type = 'STANDARD' THEN 'table'
75
 
            WHEN table_type = 'FUNCTION' then 'function'
76
 
       ELSE 'misc' END,
77
 
       column_name,
78
 
       CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary'
79
 
             WHEN IS_INDEXED = 'YES' THEN 'indexed'
80
 
       ELSE 'indexed' END
81
 
       FROM data_dictionary.tables INNER JOIN
82
 
            data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')
83
 
       ORDER BY table_schema, table_name limit 20;
84
 
 
85
 
DROP SCHEMA randgen_query_test;
86
 
USE test;
87
 
# end bookkeeping test
 
59
            data_dictionary.columns USING(table_schema, table_name) limit 20;
88
60
 
89
61
 
90
62
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,
91
63
                        (SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
92
64
                        COUNT(*) AS count FROM t1;
93
65
 
94
 
--sorted_result
95
66
select collation_name,character_set_name FROM data_dictionary.collations;
96
67
--replace_column 1 ####.##.####
97
 
--sorted_result
98
68
select COUNT(*) from data_dictionary.tables;
99
69
 
100
70
DROP TABLE t1;