[MDEV-20641] Native SQL command to filter, order and other Created: 2019-09-21  Updated: 2019-09-25  Resolved: 2019-09-25

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - SphinxSE
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Strelkov Andrey Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Good day, according to the instructions for working with SphinxSE, in order to set the search filter to the Sphinx index, you need to use special parameters/commands inside the query="..."
Please tell me whether it is possible to be able to apply standard commands. I. e. that Sphinx could except query="" still listen to commands of type LIKE, ORDER and others.
Probably due to other specifics of the engine, I understand that query can be more specific the query, specifying, and using the standard commands is not possible, but I just have a software with which I plan to apply to tables of the type SphinxSE unfortunately can not build a query of type query=""
Maybe it was great to have reverse support for the usual commands of filtering, sorting, etc. (even if not as flexible as it could be achieved with query="")



 Comments   
Comment by Sergei Golubchik [ 2019-09-25 ]

yes, they work, but won't be as fast as special SphinxSE syntax

Generated at Thu Feb 08 09:01:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.