malfunction in field search operator in plain mode

[sanikolaev]

Bug Description:

@f[1] b finds a b in plain mode:

Config:

snikolaev@dev2:~$ cat denis.conf
source s {
  type = csvpipe
  csvpipe_command = echo "1, a b"
  csvpipe_field = f
}

index t {
  source = s
  path = /tmp/t
  min_prefix_len = 1
}

searchd {
  listen = 9315:mysql41
  pid_file = 9315.pid
  binlog_path =
}

Queries:

snikolaev@dev2:~$ mysql -P9315 -h0 -v -e "select * from t where match('@f[1] b'); select * from t where match('@f[2] b')"
--------------
select * from t where match('@f[1] b')
--------------

+------+------+
| id   | f    |
+------+------+
|    1 |  a b |
+------+------+
--------------
select * from t where match('@f[2] b')
--------------

+------+------+
| id   | f    |
+------+------+
|    1 |  a b |
+------+------+

Expected: the first select doesn't find the document.

Notes:

• it works fine in RT mode with and without chunk flushing:

mysql> drop table if exists t; create table t(f text) min_prefix_len='1'; insert into t values(1,'a b'); flush ramchunk t; select * from t where match('@f[1] b'); select * from t where match('@f[2] b');
--------------
drop table if exists t
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
create table t(f text) min_prefix_len='1'
--------------

Query OK, 0 rows affected (0.01 sec)

--------------
insert into t values(1,'a b')
--------------

Query OK, 1 row affected (0.00 sec)

--------------
flush ramchunk t
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
select * from t where match('@f[1] b')
--------------

Empty set (0.00 sec)
--- 0 out of 0 results in 0ms ---

--------------
select * from t where match('@f[2] b')
--------------

+------+------+
| id   | f    |
+------+------+
|    1 | a b  |
+------+------+
1 row in set (0.00 sec)
--- 1 out of 1 results in 0ms ---

• I haven't tried plain mode + rt table

Manticore Search Version:

Manticore 6.3.9 e7afb264d@25011307 dev (columnar 2.3.1 9d9a466@24122408) (secondary 2.3.1 9d9a466@24122408) (knn 2.3.1 9d9a466@24122408)

Operating System Version:

Ubuntu Jammy (dev2)

Have you tried the latest development version?

No

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

Details

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed
• Changelog updated

[tomatolog]

I unable to reproduce the issue. I pushed the case you described into the #2969 there test_068/test.xml has the regression you described but works as it should

sphinxql-49> select * from csv3 where match ('@f[1] b');
0 rows in set

sphinxql-50> select * from csv3 where match ('@f[2] b');
	id	f
	1	 a b

I also checked RT index with flushed disk chunk and the data at the RAM segments and also see the right result similar to test_068/test.xml