test problem - mysql temporary table field size is too long.

[coalash]

Problems in lib/gaia/store/mysqlsimple.php

149: "keyname VARCHAR(500) NOT NULL, "

With utf-8 environment, mysql key field maximum size is 255. When exceed, error raised like below.

I recommend

149: "keyname VARCHAR(255) NOT NULL, "

---

PHP Fatal error: Uncaught exception 'Gaia\Exception' with message 'database error' in /Users/daydreamer/PhpstormProjects/gaia_core_php/lib/gaia/db/except.php:17
Stack trace:
#0 /Users/daydreamer/PhpstormProjects/gaia_core_php/tests/store/mysqlsimple.t(18): Gaia\DB\Except->execute('CREATE TEMPORAR...')
#1 {main}

Debug:
Array
(
[db] => (Gaia\DB\MySQLi object -
[connection] => 127.0.0.1 via TCP/IP
[error] => 1071: Specified key was too long; max key length is 767 bytes
[lastquery] => CREATE TEMPORARY TABLE IF NOT EXISTS gaia_store_mysqlsimple_test (keyname VARCHAR(500) NOT NULL, data BLOB, ttl INT UNSIGNED NOT NULL, revision BIGINT UNSIGNED NOT NULL, UNIQUE keyname (keyname), INDEX ttl (ttl) ) Engine=InnoDB
)
[query] => CREATE TEMPORARY TABLE IF NOT EXISTS gaia_store_mysqlsimple_test (keyname VARCHAR(500) NOT NULL, data BLOB, ttl INT UNSIGNED NOT NULL, revision BIGINT UNSIGNED NOT NULL, UNIQUE keyname (keyname), IN in /Users/daydreamer/PhpstormProjects/gaia_core_php/lib/gaia/db/except.php on line 17