CALL AUTOCOMPLETE() sometimes produces a List<Map<String, String>>, sometimes List<Map<String, Int>> in JSON results

[Ocramius]

Bug Description:

Given following SQL query:

CALL AUTOCOMPLETE('hello', 'my_index', 1 as append);

When using the /sql endpoint, Manticore will respond with data such as [{"query": "hello"}, {"query": "helloer"}]

When using a numeric value, things change:

CALL AUTOCOMPLETE('123', 'my_index', 1 as append);

When using the /sql endpoint, Manticore will respond with data such as [{"query": 123}, {"query": 12345}]

It seems like some auto-magic casting is occurring? Is that intentional?

Manticore Search Version:

7.4.6

Operating System Version:

irrelevant

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.}

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

[sanikolaev]

Thanks for the issue @Ocramius . I don't think the casting is intentional.

MRE:

mysql -P9306 -h0 -v -e "drop table if exists my_index; create table my_index(f text) min_infix_len='2'; insert into my_index(f) values('helloer'),('12345')"; curl -s "0:9308/sql?mode=raw" -d "CALL AUTOCOMPLETE('hello', 'my_index', 1 as append)"|jq .; curl -s "0:9308/sql?mode=raw" -d "CALL AUTOCOMPLETE('123', 'my_index', 1 as append)"|jq .
--------------
drop table if exists my_index
--------------

--------------
create table my_index(f text) min_infix_len='2'
--------------

--------------
insert into my_index(f) values('helloer'),('12345')
--------------

[
  {
    "total": 1,
    "error": "",
    "warning": "",
    "columns": [
      {
        "query": {
          "type": "string"
        }
      }
    ],
    "data": [
      {
        "query": "helloer"
      }
    ]
  }
]
[
  {
    "total": 1,
    "error": "",
    "warning": "",
    "columns": [
      {
        "query": {
          "type": "string"
        }
      }
    ],
    "data": [
      {
        "query": 12345
      }
    ]
  }
]