Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2157 add built-in support of popular MySQL functions
  3. TRAFODION-2270

support ORDER BY clause in GROUP_CONCAT function

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.1-incubating
    • None
    • None

    Description

      currently, GROUP_CONCAT() in Trafodion cannot recognize order by clause, need to support it.

      for example:
      SELECT student_name,
      GROUP_CONCAT(DISTINCT test_score
      ORDER BY test_score asc SEPARATOR ' ')
      FROM student
      GROUP BY student_name;

      Attachments

        Issue Links

          Blocked

          Sub-task - The sub-task of the issue TRAFODION-2163 support MYSQL style function GROUP_CONCAT

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #795

          Activity

            People

              ovis_poly liu ming
              ovis_poly liu ming
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: