Details

    • Branch Version/s:
      5.2.x, 5.1.x
    • Backported to Branch:
      Committed

      Description

      When Liferay portal is using MySQL and "database.mysql.function.lower.enabled" is set to false (the default setting), the portal automatically removes case sensitive searches to improve performance. If MySQL is using a case sensitive character set (such as latin1_general_cs), and the property is not set to true, this breaks case insensitive searches. Since users can overlook this property, "database.mysql.function.lower.enabled" will be removed and Liferay portal will automatically detect if MySQL is case sensitive or not.

        Issue Links

          Activity

          douglas.wong Douglas Wong created issue -
          douglas.wong Douglas Wong made changes -
          Field Original Value New Value
          Fix Version/s 6.0.2 RC [ 10524 ]
          douglas.wong Douglas Wong made changes -
          Link This issue relates LPE-2632 [ LPE-2632 ]
          douglas.wong Douglas Wong made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          douglas.wong Douglas Wong made changes -
          Status In Progress [ 3 ] In Review [ 10006 ]
          douglas.wong Douglas Wong made changes -
          Link This issue relates LPS-9943 [ LPS-9943 ]
          douglas.wong Douglas Wong made changes -
          Backport Committed [Committed]
          brian.chan Brian Chan made changes -
          Affects Version/s 6.0.1 RC [ 10502 ]
          Affects Version/s 5.2.3 [ 10367 ]
          Affects Version/s 5.1.2 [ 10346 ]
          brian.chan Brian Chan made changes -
          Status In Review [ 10006 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          zsolt.balogh Zsolt Balogh made changes -
          Link This issue is related to LPP-255 [ LPP-255 ]
          cynthia.wilburn Cynthia Wilburn (Inactive) made changes -
          Fix Version/s 6.0.2 RC - SP [ 10525 ]
          vicki.tsang Vicki Tsang (Inactive) made changes -
          Workflow Liferay Workflow 2.2 [ 230155 ] LPS Workflow [ 274554 ]
          andrew.kim Andrew Kim made changes -
          Workflow LPS Workflow [ 274554 ] Restricted LPS Workflow [ 381823 ]
          andrew.kim Andrew Kim made changes -
          Workflow Restricted LPS Workflow [ 381823 ] Copy of LPS Workflow [ 417398 ]
          andrew.kim Andrew Kim made changes -
          Workflow Copy of LPS Workflow [ 417398 ] LPS Workflow [ 449008 ]
          andrew.kim Andrew Kim made changes -
          Workflow LPS Workflow [ 449008 ] Copy 2 of LPS Workflow [ 481358 ]
          andrew.kim Andrew Kim made changes -
          Workflow Copy 2 of LPS Workflow [ 481358 ] LPS Workflow [ 513254 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow LPS Workflow [ 513254 ] PUBLIC - LPS Generic Workflow [ 565036 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 565036 ] Copy of PUBLIC - LPS Generic Workflow [ 599368 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow Copy of PUBLIC - LPS Generic Workflow [ 599368 ] PUBLIC - LPS Generic Workflow [ 631297 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Component/s Infrastructure [ 14596 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Issue Type Improvement [ 4 ] Bug [ 1 ]
          Assignee Douglas Wong [ douglas.wong ] SE Support [ support-lep@liferay.com ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 631297 ] PUBLIC - LPS General Workflow [ 725020 ]
          randy.zhu Randy Zhu (Inactive) made changes -
          Workflow PUBLIC - LPS General Workflow [ 725020 ] PUBLIC - LPS Bugs Workflow [ 822335 ]
          esther.sanz Esther Sanz made changes -
          Component/s Infrastructure [ 14596 ]
          esther.sanz Esther Sanz made changes -
          Component/s Environments [ 18012 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open In Progress In Progress
          7m 26s 1 Douglas Wong 28/May/10 12:24 PM
          In Progress In Progress In Review In Review
          3s 1 Douglas Wong 28/May/10 12:24 PM
          In Review In Review Closed Closed
          1h 36m 1 Brian Chan 28/May/10 2:01 PM

            People

            • Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              douglas.wong Douglas Wong
              Recent user:
              Esther Sanz
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                6 years, 9 weeks, 6 days ago

                Development

                  Subcomponents