Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2643

LIKE predicate single-character wildcard '_' does not match any characters in a CHAR column

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • 4.7.0
    • 4.7.0
    • None
    • None

    • Phoenix 4.7.0 on Calcite 1.5

    Description

      select at1.col3 from at1 group by at1.col3 having at1.col3 like 'A_';

      returns no results despite containing a value 'AA'

      Attachments

        Issue Links

          is a clone of

          Bug - A problem which impairs or prevents the functions of the product. PHOENIX-2645 Wildcard characters do not match newline characters

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              kliew Kevin Liew
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: