diff options
| author | unknown <kaa@mbp.local> | 2008-02-01 13:26:53 +0500 |
|---|---|---|
| committer | unknown <kaa@mbp.local> | 2008-02-01 13:26:53 +0500 |
| commit | 78e19d4283572f1706738980b8242a5e65619caf (patch) | |
| tree | 10fd15c8a7e25051fea9020a59edb8545baab06b /mysql-test/r/create.result | |
| parent | 8f081d6fa22bbdc4a0407069257cfe11822bb7ba (diff) | |
| parent | 4d794c233419658cd79b416a3ce45d0b1efea688 (diff) | |
| download | mariadb-git-78e19d4283572f1706738980b8242a5e65619caf.tar.gz | |
Merge mbp.local:/Users/kaa/src/opt/bug25162/my50-bug25162
into mbp.local:/Users/kaa/src/opt/bug25162/my51-bug25162
mysql-test/t/create.test:
Auto merged
sql/sql_yacc.yy:
Null merge.
mysql-test/r/create.result:
Manual merge.
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 0613c9ba488..1327925c24e 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -1545,6 +1545,20 @@ Handler_read_prev 0 Handler_read_rnd 0 Handler_read_rnd_next 7 drop table t1,t2; +CREATE TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1)); +DROP TABLE t1; +CREATE TABLE t1(c1 VARCHAR(33), KEY (c1) USING BTREE); +DROP TABLE t1; +CREATE TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1) USING HASH) ENGINE=MEMORY; +SHOW INDEX FROM t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 1 c1 1 c1 NULL 0 NULL NULL YES HASH +DROP TABLE t1; +CREATE TABLE t1(c1 VARCHAR(33), KEY USING HASH (c1) USING BTREE) ENGINE=MEMORY; +SHOW INDEX FROM t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 1 c1 1 c1 A NULL NULL NULL YES BTREE +DROP TABLE t1; End of 5.0 tests CREATE TABLE t1 (a int, b int); insert into t1 values (1,1),(1,2); |