~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/myisam.result

  • Committer: Brian Aker
  • Date: 2009-06-05 23:10:06 UTC
  • mto: This revision was merged to the branch mainline in revision 1055.
  • Revision ID: brian@gaz-20090605231006-01nyw7pfpj2z2v8p
Remove guts in parser for LOCK TABLE.

Show diffs side-by-side

added added

removed removed

Lines of Context:
76
76
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
77
77
1       SIMPLE  t1      ALL     NULL    NULL    NULL    NULL    4       
78
78
drop table t1;
79
 
CREATE TABLE t1 (a INT) ENGINE=MyISAM;
80
 
INSERT INTO  t1 VALUES (1), (2), (3);
81
 
LOCK TABLES t1 WRITE;
82
 
INSERT INTO  t1 VALUES (1), (2), (3);
83
 
OPTIMIZE TABLE t1;
84
 
Table   Op      Msg_type        Msg_text
85
 
test.t1 optimize        status  OK
86
 
DROP TABLE t1;
87
79
create table t1 ( t1 char(255), key(t1(250)));
88
80
Warnings:
89
81
Warning 1071    Specified key was too long; max key length is 767 bytes