josephg / josephg/ShareJS

Mysql database bug

Open
#237 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
5k
Forks
454
PR merge metrics
No merged PRs in 30d

Description

Please change lengths 256 to 255, with 256, primary key creation raise arror and mysql dont work:

mysql> CREATE TABLE sharejs.snapshots (
-> doc varchar(256) NOT NULL,
-> v int NOT NULL,
-> type varchar(256) NOT NULL,
-> snapshot text NOT NULL,
-> meta text NOT NULL,
-> created_at timestamp NOT NULL,
-> CONSTRAINT snapshots_pkey PRIMARY KEY (doc, v)
-> )
-> ;
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.