Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-4762

Index alteration syntax may cause issues on some systems

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5.2
    • Component/s: None
    • Labels:
      None

      Description

      It was reported that errors are encountered on some systems when using the syntax

      CREATE UNIQUE INDEX `indexname` ON `tablename` ...
      

      And

      DROP INDEX `indexname` ON `tablename`
      

      Instead we should use

      ALTER TABLE `tablename` DROP INDEX `indexname`
      

      And

      ALTER TABLE `tablename` ADD UNIQUE INDEX `indexname` ...
      

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            jonathan Jonathan Reissmueller
            Reporter:
            jonathan Jonathan Reissmueller
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              20/Sep/22

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 20 minutes
              20m

                Agile