Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-39245

BigPicture loading crashes for MYSQL 5.6 or older due to the maximum indexed column size being 767 bytes

    XMLWordPrintable

Details

    • Bug
    • Status: Waiting for Release (View Workflow)
    • Blocker
    • Resolution: Done
    • prod/bigpicture/jiraserver/2021/09/17/10/00/8.1.5, prod/biggantt/jiraserver/2021/09/17/10/00/8.1.5
    • None
    • None
    • Yes
    • Boxes
    • BigPicture, BigGantt
    • JIRA server, JIRA cloud
    • 13
    • 13
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}
    • Insufficient hand-over to tests
    • 2 hours, 17 minutes, 27 seconds
    • 5 days, 2 hours, 19 minutes, 22 seconds
    • 13 minutes, 29 seconds
    • 0
    • 3 hours, 20 minutes, 21 seconds
    • 18 hours, 20 minutes, 25 seconds
    • 5 weeks, 15 hours, 15 minutes, 16 seconds

    Description

      Prerequisites:
      Database MYSQL 5.6 or older

      Reproduction steps:

      1. Install BigPicture
      2. Attempt to navigate to any BigPicture module

      Actual result:

      BigPicture crashes and application is unusable, due to the maximum indexed column size being 767 bytes, whereas the popular 3-byte UTF8 coding makes our 450 characters take 450*3 bytes.

      Expected result:
      BigPicture is fully operational, no matter the coding type.

      Attachments

        Activity

          People

            piotr.duzniak Piotr Duźniak
            artur.sedzik Artur Sędzik
            mateusz.milewski Mateusz Milewski , lukasz.debski Łukasz Dębski , monika.bialucha Monika Białucha , system.gerrit Gerrit , piotr.duzniak Piotr Duźniak , artur.sedzik Artur Sędzik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: