Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1861

Database binary store schema is incompatible with MySQL 5.5

    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

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rhauch Randall Hauch
                Reporter:
                rhauch Randall Hauch
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: