Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6937

sys.functions table needs a fix in the names column

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Not A Bug
    • Affects Version/s: 1.15.0
    • Fix Version/s: 1.16.0
    • Component/s: Execution - Flow
    • Labels:
      None

      Description

      The function names in the name column of sys.functions in some cases, are the operators, this is not the expected behavior, the name column should have actual names and not the operators.

      I am on Drill 1.15.0 commit : 8743e8f1e8d5bca4d67c94d07a8560ad356ff2b6

      Apache Drill 1.15.0
      "Data is the new oil. Ready to Drill some?"
      0: jdbc:drill:schema=dfs.tmp> select count(*) from sys.functions;
      +---------+
      | EXPR$0 |
      +---------+
      | 2846 |
      +---------+
      1 row selected (0.327 seconds)
      0: jdbc:drill:schema=dfs.tmp>
      
      0: jdbc:drill:schema=dfs.tmp> select distinct name from sys.functions limit 12;
      +--------+
      | name |
      +--------+
      | != |
      | $sum0 |
      | && |
      | - |
      | /int |
      | < |
      | <= |
      | <> |
      | = |
      | == |
      | > |
      | >= |
      +--------+
      12 rows selected (0.175 seconds)
      

        Attachments

          Activity

            People

            • Assignee:
              kkhatua Kunal Khatua
              Reporter:
              khfaraaz Khurram Faraaz
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: