Error when tring to set string attribute to any value

[drewblin]

Describe the environment

Manticore Search version: 2.8.1

**OS version:**FreeBSD 11.2-RELEASE-p4

Describe the problem

Description of the issue:
Got error when tring to set string attribute to any value

Steps to reproduce:

1. Create RT index with
   rt_attr_string = street_full_name

2. Call
   update address_v2 set street_full_name = '' where id = 2;
   or
   update address_v2 set street_full_name = 'qwer' where id = 2;

3. Get error:
   ERROR 1064 (42000): sphinxql: syntax error, unexpected QUOTED_STRING near ''' where id = 2'

[tomatolog]

prior to Manticore3 you can not update STRING attributes as said in docs

All attributes types (int, bigint, float, MVA, JSON(see below)), except for strings attributes, can be dynamically updated.

That is why you got error for your queries.
To make it work you have to switch to Manticore3 there issue was fixed or switch to another attribute type in case you have to stick with Manticore 2.8.1

[drewblin]

Oh, sorry. I read documentation, but haven't pay attention that it was for Manticore3.