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

information_schema.tables is differnt row count

    XMLWordPrintable

Details

    Description

      MariaDB-10.2.15

      Table row count is different!

      MariaDB [sbtest]> select count(*) from sbtest.sbtest1;
      +----------+
      | count(*) |
      +----------+
      |  1000000 |
      +----------+
      1 row in set (0.24 sec)
       
      MariaDB [sbtest]> SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = 'sbtest' ORDER BY table_name;
      +------------+------------+
      | table_name | table_rows |
      +------------+------------+
      | sbtest1    |     986400 |
      +------------+------------+
      1 row in set (0.00 sec)
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            nyxneuf Na Yun Ho
            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.