Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-1452

Improve function listing order

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Trivial
    • Resolution: Fixed
    • None
    • 0.10.1
    • SQL Shell, Web UI
    • 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. before_lag.png
          145 kB
          Dongjoon Hyun
        3. after_lag.png
          137 kB
          Dongjoon Hyun

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: