Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1403

Trailing whitespace in CHAR/VARCHAR break string matches - Revisited

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.4
    • Fix Version/s: 1.1.5
    • Component/s: None
    • Labels:
      None

      Description

      This is a continuation of the following bug (which was fixed in 1.1.4):

      https://jira.mariadb.org/browse/MCOL-1246

      However, the bug does not address some edge case comparisons.

      For instance, we've identified 2 cases where this is not working as expected:

      1. This returns 0 results when the 'name' is "Majestic12 " (note trailing space):

      SELECT name from `wpafb` where lower(name) like 'majestic12 ';
      

      2. This one, I'm not as sure if it is a bug or not, but was reported nonetheless. This query finds all rows in the table whether they end in space of not:

      SELECT CONCAT(name,'#') from `hangar18` where name like '% ';
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              ccalender Chris Calender
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.