On Mon, Sep 7, 2015 at 6:13 PM, Niranda Perera <[email protected]> wrote:

> Hi all,
>
> I came across with the following issue while running the mysql script.
>
> 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key
> was too long; max key length is 767 bytes 0.078 sec
>
> pls refer the mail thread [1]
>
> it turns out that this happens when you use varchar(255<) values and
> innodb does not support it for unique keys. for an example query in
> carbon4-kernel master is [2]
>
> as mentioned in the thread [1] we need to fix this kernel wide, hence
> would like to draw your attention to this.
>

Please create a Jira. So we won't miss this.

Regards,
Aruna

>
> cheers
>
> [1] [Dev] MySQL error while executing dbscripts in windows env
>
> [2]
> https://github.com/wso2/carbon4-kernel/blob/master/distribution/kernel/carbon-home/dbscripts/mysql.sql#L31
>
> --
> *Niranda Perera*
> Software Engineer, WSO2 Inc.
> Mobile: +94-71-554-8430
> Twitter: @n1r44 <https://twitter.com/N1R44>
> https://pythagoreanscript.wordpress.com/
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 

*Aruna Sujith Karunarathna *| Software Engineer
WSO2, Inc | lean. enterprise. middleware.
#20, Palm Grove, Colombo 03, Sri Lanka
Mobile: +94 71 9040362 | Work: +94 112145345
Email: [email protected] | Web: www.wso2.com
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to