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

row_count() function always returns 0 for any engine

    XMLWordPrintable

Details

    Description

      from kb questions: https://mariadb.com/kb/en/library/does-row_count-work-on-column-store-tables/

      MariaDB [test]> create table inno1(id int);
      Query OK, 0 rows affected (0.02 sec)
       
      MariaDB [test]> insert into inno1 values (1), (2);
      Query OK, 2 rows affected (0.01 sec)
      Records: 2  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> select row_count();
      +-------------+
      | row_count() |
      +-------------+
      |           0 |
      +-------------+
      1 row in set (0.01 sec)
      

      The same logic on a regular mariadb server will return 2 for row_count.

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dthompson David Thompson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.