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 /mysql-test/r/sql_mode.result | |
| 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 'mysql-test/r/sql_mode.result')
| -rw-r--r-- | mysql-test/r/sql_mode.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/sql_mode.result b/mysql-test/r/sql_mode.result index c18be2df403..e0bbc0f2148 100644 --- a/mysql-test/r/sql_mode.result +++ b/mysql-test/r/sql_mode.result @@ -17,7 +17,7 @@ t1 CREATE TABLE `t1` ( `pseudo` varchar(35) character set latin2 NOT NULL default '', `email` varchar(60) character set latin2 NOT NULL default '', PRIMARY KEY (`a`), - UNIQUE KEY `email` TYPE BTREE (`email`) + UNIQUE KEY `email` USING BTREE (`email`) ) ENGINE=HEAP DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC set @@sql_mode="ansi_quotes"; show variables like 'sql_mode'; @@ -30,7 +30,7 @@ t1 CREATE TABLE "t1" ( "pseudo" varchar(35) character set latin2 NOT NULL default '', "email" varchar(60) character set latin2 NOT NULL default '', PRIMARY KEY ("a"), - UNIQUE KEY "email" TYPE BTREE ("email") + UNIQUE KEY "email" USING BTREE ("email") ) ENGINE=HEAP DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC set @@sql_mode="no_table_options"; show variables like 'sql_mode'; @@ -43,7 +43,7 @@ t1 CREATE TABLE `t1` ( `pseudo` varchar(35) character set latin2 NOT NULL default '', `email` varchar(60) character set latin2 NOT NULL default '', PRIMARY KEY (`a`), - UNIQUE KEY `email` TYPE BTREE (`email`) + UNIQUE KEY `email` USING BTREE (`email`) ) set @@sql_mode="no_key_options"; show variables like 'sql_mode'; |