← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/r/innodb-system-table-view.result

  • Committer: Lee Bieber
  • Date: 2010-12-05 04:52:45 UTC
  • mfrom: (1974.1.2 build)
  • Revision ID: kalebral@gmail.com-20101205045245-ey8nbzofn98dr7gb
Merge Padraig - Small fix needed when building a plugin out-of-tree.
Merge Joe - More work on storing transaction log in innodb

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/tests/r/innodb-system-table-view.result
2
2
TABLE_ID        NAME    FLAG    N_COLS  SPACE
3
3
11      SYS_FOREIGN     0       7       0
4
4
12      SYS_FOREIGN_COLS        0       7       0
 
5
13      SYS_REPLICATION_LOG     0       5       0
5
6
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_INDEXES;
6
7
INDEX_ID        NAME    TABLE_ID        TYPE    N_FIELDS        PAGE_NO SPACE
7
8
11      ID_IND  11      3       1       302     0
8
9
12      FOR_IND 11      0       1       303     0
9
10
13      REF_IND 11      0       1       304     0
10
11
14      ID_IND  12      3       2       305     0
 
12
15      ID_IND  13      3       1       307     0
11
13
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_COLUMNS;
12
14
TABLE_ID        NAME    POS     MTYPE   PRTYPE  LEN
13
15
11      ID      0       1       2949124 0
18
20
12      POS     1       6       0       4
19
21
12      FOR_COL_NAME    2       1       2949124 0
20
22
12      REF_COL_NAME    3       1       2949124 0
 
23
13      ID      0       3       4129792 8
 
24
13      MESSAGE 1       5       4129792 0
21
25
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FIELDS;
22
26
INDEX_ID        NAME    POS
23
27
11      ID      0
25
29
13      REF_NAME        0
26
30
14      ID      0
27
31
14      POS     1
 
32
15      ID      0
28
33
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FOREIGN;
29
34
ID      FOR_NAME        REF_NAME        N_COLS  TYPE
30
35
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FOREIGN_COLS;
33
38
TABLE_ID        NAME    STATS_INITIALIZED       NUM_ROWS        CLUST_INDEX_SIZE        OTHER_INDEX_SIZE        MODIFIED_COUNTER        AUTOINC HANDLES_OPENED
34
39
11      SYS_FOREIGN     Uninitialized   0       0       0       0       0       0
35
40
12      SYS_FOREIGN_COLS        Uninitialized   0       0       0       0       0       0
 
41
13      SYS_REPLICATION_LOG     Uninitialized   0       0       0       0       0       0
36
42
CREATE TABLE parent (id INT NOT NULL,
37
43
PRIMARY KEY (id)) ENGINE=INNODB;
38
44
CREATE TABLE child (id INT, parent_id INT,
56
62
NAME    FLAG    N_COLS  SPACE
57
63
SYS_FOREIGN     0       7       0
58
64
SYS_FOREIGN_COLS        0       7       0
 
65
SYS_REPLICATION_LOG     0       5       0
59
66
test/child      1       5       0
60
67
test/parent     1       4       0
61
68
SELECT name, n_fields