diff options
| author | vancepym <vancepym@163.com> | 2017-01-23 20:33:00 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-01-23 20:33:00 +0800 |
| commit | ee6067e98c3b07e3bb40a60c637679c2e10c6f51 (patch) | |
| tree | dfa09191d2069caa5bf0e37a356d84984cbcc4af | |
| parent | c2ce97785ff193f3a5a69518bbabf04c05b6efc8 (diff) | |
| download | seaweedfs-ee6067e98c3b07e3bb40a60c637679c2e10c6f51.tar.xz seaweedfs-ee6067e98c3b07e3bb40a60c637679c2e10c6f51.zip | |
Fix: the maximum-length character exceed 255
The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255. When CHAR values are stored, they are right-padded with spaces to the specified length.
see https://dev.mysql.com/doc/refman/5.7/en/char.html
| -rw-r--r-- | weed/filer/mysql_store/mysql_store.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/weed/filer/mysql_store/mysql_store.go b/weed/filer/mysql_store/mysql_store.go index 6910206ce..4a8e889df 100644 --- a/weed/filer/mysql_store/mysql_store.go +++ b/weed/filer/mysql_store/mysql_store.go @@ -184,7 +184,7 @@ func (s *MySqlStore) Close() { var createTable = ` CREATE TABLE IF NOT EXISTS %s ( id bigint(20) NOT NULL AUTO_INCREMENT, - uriPath char(256) NOT NULL DEFAULT "" COMMENT 'http uriPath', + uriPath char(255) NOT NULL DEFAULT "" COMMENT 'http uriPath', fid char(36) NOT NULL DEFAULT "" COMMENT 'seaweedfs fid', createTime int(10) NOT NULL DEFAULT 0 COMMENT 'createdTime in unix timestamp', updateTime int(10) NOT NULL DEFAULT 0 COMMENT 'updatedTime in unix timestamp', |