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

            Ascending order - Click to sort in descending order
            jonathan Jonathan Reissmueller created issue -
            jonathan Jonathan Reissmueller made changes -
            Field Original Value New Value
            Rank Ranked higher
            jonathan Jonathan Reissmueller made changes -
            Sprint 5.6.0 Sprint 2 [ 167 ]
            jonathan Jonathan Reissmueller made changes -
            Rank Ranked higher
            jonathan Jonathan Reissmueller made changes -
            Rank Ranked higher
            jonathan Jonathan Reissmueller made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jonathan Jonathan Reissmueller made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 20 minutes [ 1200 ]
            Worklog Id 15948 [ 15948 ]
            jonathan Jonathan Reissmueller made changes -
            Status In Progress [ 3 ] In Review [ 5 ]
            Resolution Fixed [ 1 ]
            abdy Abdy Franco made changes -
            Status In Review [ 5 ] Closed [ 6 ]

              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