diff options
| author | unknown <bar@gw.udmsearch.izhnet.ru> | 2002-03-22 16:25:22 +0400 |
|---|---|---|
| committer | unknown <bar@gw.udmsearch.izhnet.ru> | 2002-03-22 16:25:22 +0400 |
| commit | d96a17ffd1e3001b59a60e5e3d1a43e373cc1f2a (patch) | |
| tree | 2e3eddd2e0d954caf2adeca2466c55f8db7b05d1 | |
| parent | ac44fe1f1248138dfe22b0caa50c21e4d627d394 (diff) | |
| download | mariadb-git-d96a17ffd1e3001b59a60e5e3d1a43e373cc1f2a.tar.gz | |
index name can't be used as key name without space character
| -rw-r--r-- | mysql-test/r/heap.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/heap.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index fc4a116307e..5a2cd50237e 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -62,7 +62,7 @@ explain select * from t1 where a in (869751,736494,226312,802616); table type possible_keys key key_len ref rows Extra t1 range uniq_id uniq_id 4 NULL 4 where used; Using index drop table t1; -create table t1 (x int not null, y int not null, key x(x), unique y(y)) +create table t1 (x int not null, y int not null, key x (x), unique y (y)) type=heap; insert into t1 values (1,1),(2,2),(1,3),(2,4),(2,5),(2,6); select * from t1 where x=1; diff --git a/mysql-test/t/heap.test b/mysql-test/t/heap.test index b08e8f6ea36..43d6a31bc77 100644 --- a/mysql-test/t/heap.test +++ b/mysql-test/t/heap.test @@ -36,7 +36,7 @@ alter table t1 type=myisam; explain select * from t1 where a in (869751,736494,226312,802616); drop table t1; -create table t1 (x int not null, y int not null, key x(x), unique y(y)) +create table t1 (x int not null, y int not null, key x (x), unique y (y)) type=heap; insert into t1 values (1,1),(2,2),(1,3),(2,4),(2,5),(2,6); select * from t1 where x=1; |