~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/status.result

  • Committer: Brian Aker
  • Date: 2011-01-19 07:44:19 UTC
  • mfrom: (2095.2.1 drizzle-build)
  • Revision ID: brian@tangent.org-20110119074419-v0g4txvz471habc4
Test cleanup for lcov

Show diffs side-by-side

added added

removed removed

Lines of Context:
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;