← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/status.result

  • 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/r/status.result
33
33
Last_query_cost #
34
34
drop table t1;
35
35
FLUSH STATUS;
36
 
SHOW STATUS LIKE 'max_used_connections';
37
 
Variable_name   Value
38
 
Max_used_connections    1
39
 
SELECT * FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
40
 
VARIABLE_NAME   VARIABLE_VALUE
41
 
Max_used_connections    1
42
 
SHOW STATUS LIKE 'max_used_connections';
43
 
Variable_name   Value
44
 
Max_used_connections    3
45
 
SELECT * FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
46
 
VARIABLE_NAME   VARIABLE_VALUE
47
 
Max_used_connections    3
 
36
SELECT ASSERT(VARIABLE_VALUE = 1) FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
 
37
ASSERT(VARIABLE_VALUE = 1)
 
38
1
 
39
SELECT ASSERT(VARIABLE_VALUE >= 3) FROM data_dictionary.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'max_used_connections';
 
40
ASSERT(VARIABLE_VALUE >= 3)
 
41
1
48
42
CREATE TABLE t1 ( a INT );
49
43
INSERT INTO t1 VALUES (1), (2);
50
44
SELECT a FROM t1 LIMIT 1;
86
80
SHOW SESSION STATUS LIKE 'Last_query_cost';
87
81
Variable_name   Value
88
82
Last_query_cost 0
89
 
SELECT * FROM t1 a, t1 b LIMIT 1;
 
83
SELECT * FROM t1 a CROSS JOIN t1 b LIMIT 1;
90
84
a       a
91
85
1       1
92
86
SHOW SESSION STATUS LIKE 'Last_query_cost';