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

ST_COLLECT(1) IS NULL is false

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.2
    • 12.2
    • Server
    • None
    • Unexpected results
    • Q1/2026 Server Development

    Description

      select st_collect(1), st_collect(1) is null;
      +---------------+-----------------------+
      | st_collect(1) | st_collect(1) is null |
      +---------------+-----------------------+
      | NULL          |                     0 |
      +---------------+-----------------------+
      

      The reason for that is that Item_func_collect::is_null() doesn't evaluate the item

      Attachments

        Activity

          People

            serg Sergei Golubchik
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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