Uploaded image for project: 'Opencast'
  1. MH-8854

user_action table definition leads to ineficient queries on mysql

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed and reviewed
    • Affects versions: 1.4.0, 1.2
    • Fix versions: 1.4.0
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Incorrectly Functioning Without Workaround
    • Steps to reproduce:
      Hide
      In user_action 2 columns session_id and type are defined as medium text and unidexed

      as these are a) limited length fields and b) used in lookups on the table they should be converted to varchar and indexed
      Show
      In user_action 2 columns session_id and type are defined as medium text and unidexed as these are a) limited length fields and b) used in lookups on the table they should be converted to varchar and indexed
    • Tags (folksonomy):

      TestRail: Results

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                rrolf RĂ¼diger Rolf
                Reporter:
                dhorwitz David Horwitz
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  TestRail: Cases