Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Done
-
Affects Version/s: 3.1.3.Final
-
Fix Version/s: 3.2.0.Final
-
Component/s: Storage
-
Labels:None
-
Git Pull Request:
Description
The DatabaseBinaryStore attempts to create a table with the following statement:
CREATE TABLE CONTENT_STORE ( |
cid VARCHAR(255) NOT NULL, |
mime_type VARCHAR(255), |
ext_text VARCHAR(1000), |
usage INTEGER, |
usage_time TIMESTAMP, |
payload BLOB,
|
primary key(cid) |
)
|
However, "usage" is a reserved word in MySQL5, and therefore the table cannot be created. Additionally, no error message appears to be recorded in the log.