← Back to branch summary

~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-26 02:37:40 UTC
  • mto: (1226.1.2 push)
  • mto: This revision was merged to the branch mainline in revision 1227.
  • Revision ID: brian@gaz-20091126023740-oqpp5xsxmirrgbnp
Remove OPTIMIZE, place in ALTER TABLE (which does the same thing).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/show_check.result
48
48
-- Here we enable metadata just to check that the collation of the
49
49
-- resultset is non-binary for string type. This should be changed
50
50
-- after Bug#29394 is implemented.
51
 
optimize table t1;
52
 
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
53
 
def                                     Table   8       512     7       Y       0       31      45
54
 
def                                     Op      8       40      8       Y       0       31      45
55
 
def                                     Msg_type        8       40      6       Y       0       31      45
56
 
def                                     Msg_text        8       1020    2       Y       0       31      45
57
 
Table   Op      Msg_type        Msg_text
58
 
test.t1 optimize        status  OK
59
 
optimize table t1;
60
 
Table   Op      Msg_type        Msg_text
61
 
test.t1 optimize        status  OK
 
51
alter table t1 engine="default";
 
52
alter table t1 engine="default";
62
53
drop table t1;
63
54
-- Here we enable metadata just to check that the collation of the
64
55
-- resultset is non-binary for string type. This should be changed