← 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: kalebral at gmail
  • Date: 2010-12-04 04:58:08 UTC
  • mto: (1971.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1972.
  • Revision ID: kalebral@gmail.com-20101204045808-acto22oxfg43m02e
a few more updates of files that did not have license or had incorrect license structure

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       9       0
6
5
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_INDEXES;
7
6
INDEX_ID        NAME    TABLE_ID        TYPE    N_FIELDS        PAGE_NO SPACE
8
7
11      ID_IND  11      3       1       302     0
9
8
12      FOR_IND 11      0       1       303     0
10
9
13      REF_IND 11      0       1       304     0
11
10
14      ID_IND  12      3       2       305     0
12
 
15      PRIMARY 13      3       2       307     0
13
 
16      COMMIT_IDX      13      0       2       308     0
14
11
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_COLUMNS;
15
12
TABLE_ID        NAME    POS     MTYPE   PRTYPE  LEN
16
13
11      ID      0       1       2949124 0
21
18
12      POS     1       6       0       4
22
19
12      FOR_COL_NAME    2       1       2949124 0
23
20
12      REF_COL_NAME    3       1       2949124 0
24
 
13      ID      0       6       0       8
25
 
13      SEGID   1       6       0       4
26
 
13      COMMIT_ID       2       6       0       8
27
 
13      END_TIMESTAMP   3       6       0       8
28
 
13      MESSAGE_LEN     4       6       0       4
29
 
13      MESSAGE 5       5       4129792 0
30
21
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FIELDS;
31
22
INDEX_ID        NAME    POS
32
23
11      ID      0
34
25
13      REF_NAME        0
35
26
14      ID      0
36
27
14      POS     1
37
 
15      ID      0
38
 
15      SEGID   1
39
 
16      COMMIT_ID       0
40
 
16      ID      1
41
28
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FOREIGN;
42
29
ID      FOR_NAME        REF_NAME        N_COLS  TYPE
43
30
SELECT * FROM DATA_DICTIONARY.INNODB_SYS_FOREIGN_COLS;
46
33
TABLE_ID        NAME    STATS_INITIALIZED       NUM_ROWS        CLUST_INDEX_SIZE        OTHER_INDEX_SIZE        MODIFIED_COUNTER        AUTOINC HANDLES_OPENED
47
34
11      SYS_FOREIGN     Uninitialized   0       0       0       0       0       0
48
35
12      SYS_FOREIGN_COLS        Uninitialized   0       0       0       0       0       0
49
 
13      SYS_REPLICATION_LOG     Uninitialized   0       0       0       0       0       0
50
36
CREATE TABLE parent (id INT NOT NULL,
51
37
PRIMARY KEY (id)) ENGINE=INNODB;
52
38
CREATE TABLE child (id INT, parent_id INT,
70
56
NAME    FLAG    N_COLS  SPACE
71
57
SYS_FOREIGN     0       7       0
72
58
SYS_FOREIGN_COLS        0       7       0
73
 
SYS_REPLICATION_LOG     0       9       0
74
59
test/child      1       5       0
75
60
test/parent     1       4       0
76
61
SELECT name, n_fields