← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/status.test

  • Committer: Monty Taylor
  • Date: 2011-02-13 17:26:39 UTC
  • mfrom: (2157.2.2 give-in-to-pkg-config)
  • mto: This revision was merged to the branch mainline in revision 2166.
  • Revision ID: mordred@inaugust.com-20110213172639-nhy7i72sfhoq13ms
Merged in pkg-config fixes.

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