Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-20024

sql_mode="oracle" does not support LISTAGG() function

    XMLWordPrintable

Details

    Description

      This function works similar to MariaDB's GROUP_CONCAT() function and is commonly used in ORACLE PL/SQL or general reporting queries.

      Oracle Doc: https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030

      Attachments

        Activity

          People

            Unassigned Unassigned
            Faisal Faisal Saeed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 15d
                15d
                Remaining:
                Remaining Estimate - 14d 7h
                14d 7h
                Logged:
                Remaining Estimate - 14d 7h
                1h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.