manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
9.07k stars 509 forks source link

Collations are not supported in json string comparison #2744

Closed glookka closed 1 week ago

glookka commented 1 week ago

Bug Description:

Collations are not supported in json string comparison, see test_206.

These queries

sphinxql-278> set collation_connection=libc_ci;
Query OK, 0 rows affected

sphinxql-279> select id, json1, json1.username in ( 'Alice', 'damon' ) as cnd from json_attr where cnd=1;
    id  json1   cnd
    123 {"username":"Alice","year":2000,"floatkey":1.010000}    1
1 rows in set

do not return this result which is wrong as libc_ci is case insensitive.

456 {"username":"Damon","year":2003,"floatkey":4.440000}    1

Manticore Search Version:

6.3.1

Operating System Version:

Any

Have you tried the latest development version?

Yes

Internal Checklist:

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

- [x] Implementation completed - [x] Tests developed - [x] Documentation updated - [x] Documentation reviewed - [x] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133) updated
glookka commented 1 week ago

Fixed in c88bd295ef4636b857dda0f256f59107af98ae2b