sql_joined_field can't be stored

[sanikolaev]

sql_joined_field's name can be specified in stored_fields w/o any error and it is shown as stored in desc, but the value doesn't get stored:

source min {    
    type = mysql    
    sql_host = localhost    
    sql_user = test    
    sql_pass =    
    sql_db = test    
    sql_query = select 1, 'abc' doc    
    sql_joined_field = tag from query; select 1, 'joined'    
}    
    
index idx {    
    path = idx    
    source = min    
    stored_fields = doc, tag    
}    
    
searchd {    
    listen = 9315:mysql41    
    log = sphinx_min.log    
    pid_file = /home/snikolaev/9315.pid    
    binlog_path =    
}    

mysql> desc idx;    
 ------- -------- ----------------     
| Field | Type   | Properties     |    
 ------- -------- ----------------     
| id    | bigint |                |    
| doc   | text   | indexed stored |    
| tag   | text   | indexed stored |    
 ------- -------- ----------------     
3 rows in set (0.00 sec)    
    
mysql> select * from idx;    
 ------ ------ ------     
| id   | doc  | tag  |    
 ------ ------ ------     
|    1 | abc  |      |    
 ------ ------ ------     
1 row in set (0.00 sec)    
    
mysql> select * from idx where match('joined');    
 ------ ------ ------     
| id   | doc  | tag  |    
 ------ ------ ------     
|    1 | abc  |      |    
 ------ ------ ------     
1 row in set (0.02 sec)    

The expected behaviour is that the value would be in docstore in this case too.

[madgreen1]

Hi Are there any foreseeable deadlines for fixing this bug? Highlighting in the search does not work because of it.

[sanikolaev]

Hi. I'm afraid it's not in the nearest plans, but I'll check with the team and if it's fairly easy to fix this we'll do it.

[madgreen1]

Hi! There is no solution yet?

[sanikolaev]

Hi

That's correct, the issue is still open. We hope to solve it by the next release. If you need it sooner please fill free to:

• fix it yourself and make a PR - most preferable
• use our professional services - https://manticoresearch.com/services

[githubmanticore]

➤ Ilya Kuznetsov commented:

Fixed in f54b053c