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

Count as a window function doesn't work with NULLs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.5
    • Fix Version/s: 1.5.1, 1.4.4
    • Component/s: None
    • Labels:
      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

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            patricksafarov Patrick Safarov
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: