James Server
  1. James Server
  2. JAMES-176

MySQL query not using index for string comparison

    Details

      Description

      MySQL SELECT string comparisions are already case-insensitive. Using lower() in a WHERE clause effectively negates the index.

        Activity

        Serge Knystautas created issue -
        Serge Knystautas made changes -
        Field Original Value New Value
        Fix Version/s 2.2.0a15 [ 10447 ]
        Status Open [ 1 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Mark Thomas made changes -
        Workflow jira [ 27180 ] Default workflow, editable Closed status [ 12565986 ]
        Mark Thomas made changes -
        Workflow Default workflow, editable Closed status [ 12565986 ] jira [ 12581385 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Serge Knystautas
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development