← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/table_cache_dictionary/tests/r/table_cache.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-03-18 12:12:31 UTC
  • Revision ID: james.westby@ubuntu.com-20100318121231-k6g1xe6cshbwa0f8
Tags: upstream-2010.03.1347
Import upstream version 2010.03.1347

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/table_cache_dictionary/tests/r/table_cache.result
 
1
show create table data_dictionary.TABLE_CACHE;
 
2
Table   Create Table
 
3
TABLE_CACHE     CREATE TABLE `table_cache` (
 
4
  `SESSION_ID` bigint NOT NULL DEFAULT '0',
 
5
  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
 
6
  `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
 
7
  `VERSION` bigint NOT NULL DEFAULT '0',
 
8
  `IS_NAME_LOCKED` varchar(5) NOT NULL DEFAULT '',
 
9
  `ROWS` bigint NOT NULL DEFAULT '0',
 
10
  `AVG_ROW_LENGTH` bigint NOT NULL DEFAULT '0',
 
11
  `TABLE_SIZE` bigint NOT NULL DEFAULT '0',
 
12
  `AUTO_INCREMENT` bigint NOT NULL DEFAULT '0'
 
13
) ENGINE=FunctionEngine
 
14
select count(*) FROM data_dictionary.TABLE_CACHE;
 
15
count(*)
 
16
#
 
17
flush tables;
 
18
select * FROM data_dictionary.TABLE_CACHE ORDER BY TABLE_SCHEMA, TABLE_NAME;
 
19
SESSION_ID      TABLE_SCHEMA    TABLE_NAME      VERSION IS_NAME_LOCKED  ROWS    AVG_ROW_LENGTH  TABLE_SIZE      AUTO_INCREMENT
 
20
#       data_dictionary table_cache     #       #       #       595     #       #
 
21
create table a ( a int);
 
22
create table b ( b int);
 
23
select * FROM a,b;
 
24
a       b
 
25
select * FROM data_dictionary.TABLE_CACHE ORDER BY TABLE_SCHEMA, TABLE_NAME;
 
26
SESSION_ID      TABLE_SCHEMA    TABLE_NAME      VERSION IS_NAME_LOCKED  ROWS    AVG_ROW_LENGTH  TABLE_SIZE      AUTO_INCREMENT
 
27
#       data_dictionary table_cache     #       #       #       595     #       #
 
28
#       test    a       #       #       #       6       #       #
 
29
#       test    b       #       #       #       6       #       #
 
30
DROP TABLES a,b;