[Groonga-mysql-commit] mroonga/mroonga [master] Reduce two large key

Back to archive index

Kouhei Sutou null+****@clear*****
Fri Dec 14 18:26:42 JST 2012


Kouhei Sutou	2012-12-14 18:26:42 +0900 (Fri, 14 Dec 2012)

  New Revision: 851498e298ef09dbe41716931b1d533e7bc3e9e6
  https://github.com/mroonga/mroonga/commit/851498e298ef09dbe41716931b1d533e7bc3e9e6

  Log:
    Reduce two large key

  Modified files:
    test/sql/suite/mroonga/storage/fulltext/r/two_inner_join.result
    test/sql/suite/mroonga/storage/fulltext/t/two_inner_join.test

  Modified: test/sql/suite/mroonga/storage/fulltext/r/two_inner_join.result (+1 -3)
===================================================================
--- test/sql/suite/mroonga/storage/fulltext/r/two_inner_join.result    2012-12-14 18:22:29 +0900 (1b306a7)
+++ test/sql/suite/mroonga/storage/fulltext/r/two_inner_join.result    2012-12-14 18:26:42 +0900 (e39790e)
@@ -2,12 +2,10 @@ DROP TABLE IF EXISTS users, posts, comments;
 SET NAMES utf8;
 CREATE TABLE users (
 id int NOT NULL,
-name varchar(256) NOT NULL,
+name varchar(50) NOT NULL,
 PRIMARY KEY (id),
 KEY (name)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-Warnings:
-Warning	1071	Specified key was too long; max key length is 767 bytes
 CREATE TABLE posts (
 id int NOT NULL,
 content mediumtext,

  Modified: test/sql/suite/mroonga/storage/fulltext/t/two_inner_join.test (+1 -1)
===================================================================
--- test/sql/suite/mroonga/storage/fulltext/t/two_inner_join.test    2012-12-14 18:22:29 +0900 (0d69583)
+++ test/sql/suite/mroonga/storage/fulltext/t/two_inner_join.test    2012-12-14 18:26:42 +0900 (d033462)
@@ -25,7 +25,7 @@ SET NAMES utf8;
 
 CREATE TABLE users (
   id int NOT NULL,
-  name varchar(256) NOT NULL,
+  name varchar(50) NOT NULL,
   PRIMARY KEY (id),
   KEY (name)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-------------- next part --------------
HTML����������������������������...
Download 



More information about the Groonga-mysql-commit mailing list
Back to archive index