partial results with SI on

[sanikolaev]

If you run this https://github.com/sanikolaev/Eclipsium_manticore_crash/tree/ac07a3560416f81bf32eaa3d0bcdcff5c1b1490b (git clone; docker compose up) you'll see that Manticore finds significantly less results with SI on compared to when SI is off:

mysql> set global secondary_indexes=1;
Query OK, 0 rows affected (0.06 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|     4000 |
+----------+
1 row in set (0.16 sec)

mysql> set global secondary_indexes=0;
Query OK, 0 rows affected (0.00 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|  2614447 |
+----------+
1 row in set (0.01 sec)

mysql> set global secondary_indexes=1;
Query OK, 0 rows affected (0.00 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|    12000 |
+----------+
1 row in set (0.01 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|    14000 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|    16000 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|    16000 |
+----------+
1 row in set (0.01 sec)

mysql> set global secondary_indexes=0;
Query OK, 0 rows affected (0.02 sec)

mysql> select count(*) from posts_idx where uploaded_at >= 1696494232;
+----------+
| count(*) |
+----------+
|  2624437 |
+----------+
1 row in set (0.45 sec)

The version is:

snikolaev@dev2:~/issue_1458$ mysql -P49306 -h0
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2084
Server version: 6.2.13 f94555a29@230908 dev (columnar 2.2.5 709b9ac@230908) (secondary 2.2.5 709b9ac@230908) git branch master...origin/master

Same w/o count(*):

mysql> set global secondary_indexes=1;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from posts_idx where uploaded_at >= 1696494232 limit 0 option cutoff=0; show meta;
Empty set (0.00 sec)

+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| total          | 0     |
| total_found    | 0     |
| total_relation | eq    |
| time           | 0.001 |
+----------------+-------+
4 rows in set (0.00 sec)

mysql> select * from posts_idx where uploaded_at >= 1696494232 limit 0 option cutoff=0; show meta;
Empty set (0.00 sec)

+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| total          | 1     |
| total_found    | 4000  |
| total_relation | eq    |
| time           | 0.003 |
+----------------+-------+
4 rows in set (0.00 sec)

mysql> set global secondary_indexes=0;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from posts_idx where uploaded_at >= 1696494232 limit 0 option cutoff=0; show meta;
Empty set (0.06 sec)

+----------------+---------+
| Variable_name  | Value   |
+----------------+---------+
| total          | 1       |
| total_found    | 2690363 |
| total_relation | eq      |
| time           | 0.065   |
+----------------+---------+
4 rows in set (0.01 sec)

[sanikolaev]

Can't reproduce in 6.2.13 c10f1d848@231006 dev (columnar 2.2.5 b8be4eb@230928) (secondary 2.2.5 b8be4eb@230928)

Might have been fixed in 3acd671