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

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

                Dates

                • Created:
                  Updated:
                  Resolved: