Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34578

Server crashes when attempting to run JSON_OBJECTAGG as a window function

    XMLWordPrintable

Details

    Description

      I'm connecting to MariaDB using JDBC (e.g. from my own application, or using Dbeaver). I'll run this statement:

      select
        json_objectagg(t.k, t.v) over (order by t.k)
      from (
        select
          t.*
        from (
          select
            'a' as k,
            1 as v
        ) t
      ) as t
      order by t.k;
      

      And get this error:

      SQL Error [08000]: Socket fail to connect to host:address=(host=localhost)(port=3307)(type=primary). Connection refused: no further information
      

      This effectively crashes the server

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              lukas.eder Lukas Eder
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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