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

NOT LIKE with wildcard unexpectedly returns results

    XMLWordPrintableJSON

Details

    Description

      The following returns all rows in the table when it should return no rows:

      select * from emp where first_name not like '%'

      The following returns no rows as expected:

      select * from emp where first_name not like '%%'

      first_name is a VARCHAR column

      Attachments

        1. PHOENIX-3046.patch
          11 kB
          James R. Taylor
        2. PHOENIX-3046_v2.patch
          10 kB
          James R. Taylor

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: