Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.1.2
-
None
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.