← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/status.result

  • Committer: Brian Aker
  • Date: 2011-01-18 07:21:16 UTC
  • mfrom: (2079.3.3 session-fix)
  • Revision ID: brian@tangent.org-20110118072116-nuflltzguzhq9rgg
Merge in update so that test-run.pl runs all of test/suite and fix for
create table like and FK.

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
 
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
 
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
42
48
CREATE TABLE t1 ( a INT );
43
49
INSERT INTO t1 VALUES (1), (2);
44
50
SELECT a FROM t1 LIMIT 1;
80
86
SHOW SESSION STATUS LIKE 'Last_query_cost';
81
87
Variable_name   Value
82
88
Last_query_cost 0
83
 
SELECT * FROM t1 a CROSS JOIN t1 b LIMIT 1;
 
89
SELECT * FROM t1 a, t1 b LIMIT 1;
84
90
a       a
85
91
1       1
86
92
SHOW SESSION STATUS LIKE 'Last_query_cost';