Hyoungjun Kim created S2GRAPH-90:
------------------------------------

             Summary: Specified key was too long error.
                 Key: S2GRAPH-90
                 URL: https://issues.apache.org/jira/browse/S2GRAPH-90
             Project: S2Graph
          Issue Type: Bug
    Affects Versions: 0.1.0
            Reporter: Hyoungjun Kim


The following error message is shown when creating table.  
{noformat}
# mysql -uroot < 
./s2core/target/scala-2.11/classes/org/apache/s2graph/core/mysqls/schema.sql
ERROR 1071 (42000) at line 26: Specified key was too long; max key length is 
767 bytes
{noformat}

There is restriction for index key length under the default mysql configuration.
I succeeded creating table after setting some variables. See the following 
article.

http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-avoid-error-1071/
 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to