diff options
| author | unknown <jimw@mysql.com> | 2005-01-08 07:31:13 +0100 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-01-08 07:31:13 +0100 |
| commit | 895b50d74c772eac555faa69521c3a976a85d1e9 (patch) | |
| tree | 7f55e20f0d208559f97dd4e14dca6b66d09390cd /sql/sql_show.cc | |
| parent | 0c57a67ce0434fa78e2b64f569a271d166371a32 (diff) | |
| download | mariadb-git-895b50d74c772eac555faa69521c3a976a85d1e9.tar.gz | |
Use 'USING <indextype>' in results of SHOW CREATE TABLE, it's the preferred
syntax. (Bug #7233)
sql/sql_show.cc:
Use 'USING <indextype>' in SHOW CREATE TABLE, it's the preferred syntax
mysql-test/r/ctype_utf8.result:
Update results
mysql-test/r/show_check.result:
Update results
mysql-test/r/sql_mode.result:
Update results
mysql-test/t/show_check.test:
Use preferred syntax 'USING BTREE' instead of 'TYPE BTREE'
Diffstat (limited to 'sql/sql_show.cc')
| -rw-r--r-- | sql/sql_show.cc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/sql_show.cc b/sql/sql_show.cc index ba13dd1ff04..142badeb85c 100644 --- a/sql/sql_show.cc +++ b/sql/sql_show.cc @@ -1408,12 +1408,12 @@ store_create_info(THD *thd, TABLE *table, String *packet) { if (table->db_type == DB_TYPE_HEAP && key_info->algorithm == HA_KEY_ALG_BTREE) - packet->append(" TYPE BTREE", 11); + packet->append(" USING BTREE", 12); // +BAR: send USING only in non-default case: non-spatial rtree if ((key_info->algorithm == HA_KEY_ALG_RTREE) && !(key_info->flags & HA_SPATIAL)) - packet->append(" TYPE RTREE", 11); + packet->append(" USING RTREE", 12); } packet->append(" (", 2); |