~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

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

• browse files at revision 1291
• compare with another revision
• download diff
• download tarball
• view history from revision 1291

Show diffs side-by-side

added

removed

plugin/table_cache_dictionary/tests/r/table_definition_cache.result

 

1

show create table data_dictionary.TABLE_DEFINITION_CACHE;

 

2

Table   Create Table

 

3

TABLE_DEFINITION_CACHE  CREATE TABLE `table_definition_cache` (

 

4

  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',

 

5

  `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',

 

6

  `VERSION` bigint NOT NULL DEFAULT '0',

 

7

  `TABLE_COUNT` bigint NOT NULL DEFAULT '0',

 

8

  `IS_NAME_LOCKED` varchar(5) NOT NULL DEFAULT ''

 

9

) ENGINE=FunctionEngine

 

10

select count(*) FROM data_dictionary.TABLE_DEFINITION_CACHE;

 

11

count(*)

 

12

#

 

13

flush tables;

 

14

select * FROM data_dictionary.TABLE_DEFINITION_CACHE  ORDER BY TABLE_SCHEMA, TABLE_NAME;

 

15

TABLE_SCHEMA    TABLE_NAME      VERSION TABLE_COUNT     IS_NAME_LOCKED

 

16

#       table_definition_cache  #       #       #

 

17

create table a ( a int);

 

18

create table b ( b int);

 

19

select * FROM a,b;

 

20

a       b

 

21

select * FROM data_dictionary.TABLE_DEFINITION_CACHE  ORDER BY TABLE_SCHEMA, TABLE_NAME;

 

22

TABLE_SCHEMA    TABLE_NAME      VERSION TABLE_COUNT     IS_NAME_LOCKED

 

23

#       table_definition_cache  #       #       #

 

24

#       a       #       #       #

 

25

#       b       #       #       #

 

26

DROP TABLES a,b;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1