JOIN query on json attribute returns null

[Nick-S-2018]

Bug Description:

mysql -P9306 -h0 -e 'create table t1(f1 json)'
mysql -P9306 -h0 -e 'create table t2(f2 json)'
mysql -P9306 -h0 -e "insert into t1(f1) values('{\"f\":\"a\"}')"
mysql -P9306 -h0 -e "insert into t2(f2) values('{\"g\":\"a\"}')"
mysql -P9306 -h0 -e "select f1.f from t1 left join t2 on t1.f1.f=string(t2.f2.g)"
+------+
| f1.f |
+------+
| NULL |
+------+

Manticore Search Version:

Manticore 6.3.9 80e52e497@25010209 dev

Operating System Version:

Ubuntu 22.04 LTS

Have you tried the latest development version?

Yes

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
• Changelog updated

[MohammedOmar123]

Hi @glookka and @Nick-S-2018
I was searching if manticore provides join feature, and found that it still in beta phase, when do you expect that it will official released?
Thank you so much!

[chongshengdz]

join feature? why not use distributed table instead?

[MohammedOmar123]

@chongshengdz
what is the relation between distributed table and join ?
i need the join statement because i have 2 different entities, and i need to get data from both table based on a shared column

[sanikolaev]

when do you expect that it will official released?

It has been officially released. However, it is still considered a beta version because we haven't received enough feedback from the community yet. The more you and other community members use it and share your experiences — whether it works well or not — the sooner we can remove the beta label. That is to say, this isn't the kind of beta where the functionality has known issues, but rather one where we're refining and optimizing based on real-world usage. Your input is crucial in helping us identify areas for improvement and ensure the final version meets everyone's expectations.