Does ROW_COUNT() work on column store tables?
I'm always getting 0 from ROW_COUNT on column store tables. I created an innodb table I get the same results there...
version = 10.2.10-MariaDB-log
version_comment = Columnstore 1.1.2-1
MariaDB > CREATE TABLE test1 (c1 INT(10)) ENGINE=columnstore\G
QUERY OK, 0 ROWS affected (0.18 sec)
MariaDB > INSERT INTO test1 (c1) VALUES (55555)\G
QUERY OK, 1 ROW affected (0.06 sec)
MariaDB >SELECT ROW_COUNT()\G
***** 1. ROW *****
ROW_COUNT(): 0
1 ROW IN SET (0.00 sec)
MariaDB > SELECT * FROM test1\G
***** 1. ROW *****
c1: 55555
1 ROW IN SET (0.02 sec)
MariaDB > DELETE FROM test1 WHERE c1 = 55555\G
QUERY OK, 1 ROW affected (0.08 sec)
MariaDB > SELECT ROW_COUNT()\G
***** 1. ROW *****
ROW_COUNT(): 0
1 ROW IN SET (0.00 sec)
MariaDB > SELECT * FROM test1\G
Empty SET (0.01 sec)
Answer Answered by David Thompson in this comment.
With this one we fixed it in both 1.0 and 1.1 so it will also be available in 1.0.12 which will be out soon if you haven't upgraded to 1.1.2. And it will be in 1.1.3 which will be released early next year.
Thank You
