Error "no such built-in procedure AUTOCOMPLETE"

[it-dude-ru]

If I connect to manticore server with mysql client and try queries like CALL AUTOCOMPLETE('нач', 'otechnik_books_for_guest_distributed');, it works correctly.

But when I try this:

$this->client = new Client([
            'host' => 'manticore',
            'port' => 9308,
            'transport' => 'Http',
        ], $logger);
$query = "CALL AUTOCOMPLETE('нач', 'otechnik_books_for_guest_distributed')";
$rawMode = true;
$response = $this->client->sql($query, $rawMode);

I recieve the error "no such built-in procedure AUTOCOMPLETE".
Can you advise something, how to make it work correctly?

[it-dude-ru]

I've found that manticoresearch-php creates query like this:

curl "http://localhost:9308/sql?mo
de=raw&query=CALL+AUTOCOMPLETE%28%27%D0%BD%D0%B0%D1%87%27%2C+%27otechnik_books_for_guest_distributed%27%29%3B"

And manticore server answers to that with error:
{"error":"no such built-in procedure AUTOCOMPLETE"}

But, if I replace symbols of "+" with "%20", the query becomes correct.

curl "http://localhost:9308/sql?mode=raw&query=CALL%20AUTOCOMPLETE%28%27%D0%BD%D0%B0%
D1%87%27%2C%20%27otechnik_books_for_guest_distributed%27%29%3B"
[{"total":16,"error":"","warning":"","columns":[{"query":{"type":"string"}}],"data":[{"query":"над"},{"query":"святой"},{"query":"надо"},{"query":"свой"},{"query":"надобно"},{"query":"другой"},{"query":"надолго"},{"query":"той"},{"query":"надписи"},{"query":"какой"},{"query":"надписью"},{"query":"полной"},{"query":"надпись"},{"query":"живой"},{"query":"надолзе"},{"query":"хлад"}]}]

So, the question is - why spaces in query is replaced with "+", and how I can make it work correctly?

[it-dude-ru]

Well, it turned out that there is exist a method autocomplete. Unfortunately, it isn't mentioned in docs. So, if you want to autocomlete something, you should do like this:

$params = [
    'body' => [
        'table' => $table,
        'query' => $query,
        'options' => [
            'fuzziness' => 2,
            'preserve' => 0,
            'layouts' => 'ru,us',
            'append' => 1
        ]
    ]
];

$response = $this->client->autocomplete($params);

The response will be similar to it:

[
    {
        "total": 3,
        "error": "",
        "warning": "",
        "columns": [
            {
                "query": {
                    "type": "string"
                }
            }
        ],
        "data": [
            {
                "query": "suggestion1"
            },
            {
                "query": "suggestion2"
            },
            {
                "query": "suggestion3"
            }
        ]
    }
]

[sanikolaev]

The related PR which improves the docs is #251