XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 3.1.0
    • Component/s: SQL
    • Labels:
      None

      Description

      In Teradata/Hive and PostgreSQL 'like any' and 'like all' operators are mostly used when we are matching a text field with numbers of patterns. For example:

      Teradata / Hive 3.0:

      --like any
      select 'foo' LIKE ANY ('%foo%','%bar%');
      
      --like all
      select 'foo' LIKE ALL ('%foo%','%bar%');
      

      PostgreSQL:

      -- like any
      select 'foo' LIKE ANY (array['%foo%','%bar%']);
      
      -- like all
      select 'foo' LIKE ALL (array['%foo%','%bar%']);
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                yumwang Yuming Wang
                Reporter:
                yumwang Yuming Wang
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: