PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-9944

Liferay Portal will automatically detect if MySQL is case sensitive

    Details

    • Branch Version/s:
      5.2.x, 5.1.x
    • Backported to Branch:
      Committed
    • Similar Issues:
      Show 5 results 

      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 created issue -
          Douglas Wong made changes -
          Field Original Value New Value
          Fix Version/s 6.0.2 RC [ 10524 ]
          Douglas Wong made changes -
          Link This issue relates LPE-2632 [ LPE-2632 ]
          Douglas Wong made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Douglas Wong made changes -
          Status In Progress [ 3 ] In Review [ 10006 ]
          Douglas Wong made changes -
          Link This issue relates LPS-9943 [ LPS-9943 ]
          Douglas Wong made changes -
          Backport Committed [Committed]
          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 made changes -
          Status In Review [ 10006 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Zsolt Balogh made changes -
          Link This issue is related to LPP-255 [ LPP-255 ]
          Cynthia Wilburn (Inactive) made changes -
          Fix Version/s 6.0.2 RC - SP [ 10525 ]
          Vicki Tsang made changes -
          Workflow Liferay Workflow 2.2 [ 230155 ] LPS Workflow [ 274554 ]
          Andrew Kim made changes -
          Workflow LPS Workflow [ 274554 ] Restricted LPS Workflow [ 381823 ]
          Andrew Kim made changes -
          Workflow Restricted LPS Workflow [ 381823 ] Copy of LPS Workflow [ 417398 ]
          Andrew Kim made changes -
          Workflow Copy of LPS Workflow [ 417398 ] LPS Workflow [ 449008 ]
          Andrew Kim made changes -
          Workflow LPS Workflow [ 449008 ] Copy 2 of LPS Workflow [ 481358 ]
          Andrew Kim made changes -
          Workflow Copy 2 of LPS Workflow [ 481358 ] LPS Workflow [ 513254 ]
          Randy Zhu made changes -
          Workflow LPS Workflow [ 513254 ] PUBLIC - LPS Generic Workflow [ 565036 ]
          Randy Zhu made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 565036 ] Copy of PUBLIC - LPS Generic Workflow [ 599368 ]
          Randy Zhu made changes -
          Workflow Copy of PUBLIC - LPS Generic Workflow [ 599368 ] PUBLIC - LPS Generic Workflow [ 631297 ]
          Randy Zhu made changes -
          Component/s Infrastructure [ 14596 ]
          Randy Zhu made changes -
          Issue Type Improvement [ 4 ] Bug [ 1 ]
          Assignee Douglas Wong [ douglas.wong ] SE Support [ support-lep@liferay.com ]
          Randy Zhu made changes -
          Workflow PUBLIC - LPS Generic Workflow [ 631297 ] PUBLIC - LPS General Workflow [ 725020 ]
          Randy Zhu made changes -
          Workflow PUBLIC - LPS General Workflow [ 725020 ] PUBLIC - LPS Bugs Workflow [ 822335 ]
          Esther Sanz made changes -
          Component/s Infrastructure [ 14596 ]
          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:
              SE Support
              Reporter:
              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:
                5 years, 5 weeks, 4 days ago

                Development

                  Structure Helper Panel