Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.10.1
    • Component/s: SQL Shell, Web UI
    • Labels:
      None

      Description

      Tajo shows users function list in two places(CLI,Web) in only alphabetical `function name` and emunerical(not alphabetical) `result type` order. This issue propose to display them in full alphabetical `function name`, `type`, `result type', 'argument type' order.

      tsql

      default> \df sum
       Name            | Result type     | Argument types        | Description                                   | Type      
      -----------------+-----------------+-----------------------+-----------------------------------------------+-----------
       sum             | INT8            | int4                  | the sum of a set of numbers                   | AGGREGATIO
       sum             | INT8            | int8                  | the sum of a set of numbers                   | AGGREGATIO
       sum             | INT8            | int8                  | the sum of a distinct and non-null values     | DISTINCT_A
       sum             | INT8            | int4                  | the sum of a distinct and non-null values     | DISTINCT_A
       sum             | FLOAT8          | float8                | the sum of a distinct and non-null values     | DISTINCT_A
       sum             | FLOAT8          | float4                | the sum of a distinct and non-null values     | DISTINCT_A
       sum             | FLOAT8          | float8                | the sum of a set of numbers                   | AGGREGATIO
       sum             | FLOAT8          | float4                | the sum of a set of numbers                   | AGGREGATIO
      
      default> \df sum
       Name            | Result type     | Argument types        | Description                                   | Type      
      -----------------+-----------------+-----------------------+-----------------------------------------------+-----------
       sum             | float8          | float4                | the sum of a set of numbers                   | aggregatio
       sum             | float8          | float8                | the sum of a set of numbers                   | aggregatio
       sum             | int8            | int4                  | the sum of a set of numbers                   | aggregatio
       sum             | int8            | int8                  | the sum of a set of numbers                   | aggregatio
       sum             | float8          | float4                | the sum of a distinct and non-null values     | distinct_a
       sum             | float8          | float8                | the sum of a distinct and non-null values     | distinct_a
       sum             | int8            | int4                  | the sum of a distinct and non-null values     | distinct_a
       sum             | int8            | int8                  | the sum of a distinct and non-null values     | distinct_a
      

      `http://localhost:26080/functions.jsp` will change the result in the same order.

        Attachments

        1. TAJO-1452.Hyun.150327.0.patch.txt
          8 kB
          Dongjoon Hyun
        2. after_lag.png
          137 kB
          Dongjoon Hyun
        3. before_lag.png
          145 kB
          Dongjoon Hyun

          Activity

            People

            • Assignee:
              dongjoon Dongjoon Hyun
              Reporter:
              dongjoon Dongjoon Hyun
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: