Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3839

Count as a window function doesn't work with NULLs

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.5
    • 1.4.4, 1.5.1
    • None
    • None

    Description

      MariaDB [smtp_email_validator]> select count(null) over () from logs where timestamp > now() - interval 1 hour; 
      ERROR 1815 (HY000): Internal error: InetStreamSocket::readToMagic: Remote is closed
      MariaDB [smtp_email_validator]> show warnings\G
      *************************** 1. row ***************************
        Level: Error
         Code: 1815
      Message: Internal error: InetStreamSocket::readToMagic: Remote is closed
      *************************** 2. row ***************************
        Level: Error
         Code: 1030
      Message: Got error 1815 "Unknown error 1815" from storage engine InfiniDB
      *************************** 3. row ***************************
        Level: Error
         Code: 1815
      Message: Internal error: /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp: Could not get a connection to a ExeMgr
      3 rows in set (0.000 sec)
      

      If we use an expression as a `count ` argument, it counts all rows including the ones containing NULLs

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            patricksafarov Patrick Safarov
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.