~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/show_check.result

  • Committer: Brian Aker
  • Date: 2009-11-24 02:06:37 UTC
  • mfrom: (1223.1.7 push)
  • Revision ID: brian@gaz-20091124020637-9gb65vj98x1arydm
MergeĀ forĀ staging.

Show diffs side-by-side

added added

removed removed

Lines of Context:
7
7
-- Here we enable metadata just to check that the collation of the
8
8
-- resultset is non-binary for string type. This should be changed
9
9
-- after Bug#29394 is implemented.
10
 
check table t1 fast;
11
 
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
12
 
def                                     Table   8       512     7       Y       0       31      45
13
 
def                                     Op      8       40      5       Y       0       31      45
14
 
def                                     Msg_type        8       40      6       Y       0       31      45
15
 
def                                     Msg_text        8       1020    2       Y       0       31      45
16
 
Table   Op      Msg_type        Msg_text
17
 
test.t1 check   status  OK
18
 
check table t1 fast;
19
 
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
20
 
def                                     Table   8       512     7       Y       0       31      45
21
 
def                                     Op      8       40      5       Y       0       31      45
22
 
def                                     Msg_type        8       40      6       Y       0       31      45
23
 
def                                     Msg_text        8       1020    2       Y       0       31      45
24
 
Table   Op      Msg_type        Msg_text
25
 
test.t1 check   status  OK
26
 
check table t1 changed;
 
10
check table t1;
27
11
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
28
12
def                                     Table   8       512     7       Y       0       31      45
29
13
def                                     Op      8       40      5       Y       0       31      45
32
16
Table   Op      Msg_type        Msg_text
33
17
test.t1 check   status  OK
34
18
insert into t1 values (5,5,5);
35
 
check table t1 changed;
36
 
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
37
 
def                                     Table   8       512     7       Y       0       31      45
38
 
def                                     Op      8       40      5       Y       0       31      45
39
 
def                                     Msg_type        8       40      6       Y       0       31      45
40
 
def                                     Msg_text        8       1020    2       Y       0       31      45
41
 
Table   Op      Msg_type        Msg_text
42
 
test.t1 check   status  OK
43
 
check table t1 medium;
44
 
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
45
 
def                                     Table   8       512     7       Y       0       31      45
46
 
def                                     Op      8       40      5       Y       0       31      45
47
 
def                                     Msg_type        8       40      6       Y       0       31      45
48
 
def                                     Msg_text        8       1020    2       Y       0       31      45
49
 
Table   Op      Msg_type        Msg_text
50
 
test.t1 check   status  OK
51
 
check table t1 extended;
 
19
check table t1;
52
20
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
53
21
def                                     Table   8       512     7       Y       0       31      45
54
22
def                                     Op      8       40      5       Y       0       31      45