← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/status.test

  • Committer: lbieber
  • Date: 2010-10-02 19:48:35 UTC
  • mfrom: (1730.6.19 drizzle-make-lcov)
  • Revision ID: lbieber@orisndriz08-20101002194835-q5zd9qc4lvx1xnfo
Merge Hartmut - clean up lex, now require flex to build, also "make lcov" improvements

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/status.test
74
74
--enable_result_log
75
75
 
76
76
# Prerequisite.
77
 
SELECT ASSERT(VARIABLE_VALUE = 1) FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
 
77
SHOW STATUS LIKE 'max_used_connections';
 
78
SELECT * FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
78
79
 
79
80
# Save original setting.
80
81
connect (con1,localhost,root,,);
86
87
disconnect con1;
87
88
 
88
89
# Check that max_used_connections still reflects maximum value.
89
 
SELECT ASSERT(VARIABLE_VALUE >= 3) FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
 
90
SHOW STATUS LIKE 'max_used_connections';
 
91
SELECT * FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
90
92
 
91
93
#
92
94
# Bug #30377: EXPLAIN loses last_query_cost when used with UNION
115
117
SELECT (SELECT a FROM t1 LIMIT 1) x FROM t1 LIMIT 1;
116
118
SHOW SESSION STATUS LIKE 'Last_query_cost';
117
119
 
118
 
SELECT * FROM t1 a CROSS JOIN t1 b LIMIT 1;
 
120
SELECT * FROM t1 a, t1 b LIMIT 1;
119
121
SHOW SESSION STATUS LIKE 'Last_query_cost';
120
122
 
121
123
DROP TABLE t1;